CTS starlight

Easily access your financial data without technical complexity, and speed up your analyses.

CTS starlight is an innovative addition to SAP FC that enables users, even outside SAP FC, to dynamically query different data sources, thanks to an intuitive web interface and powerful APIs.

Easily access your financial data without technical complexity, and speed up your analyses.

CTS starlight is an innovative addition to SAP FC that enables users, even outside SAP FC, to dynamically query different data sources, thanks to an intuitive web interface and powerful APIs.

Key benefits

Why choose CTS starlight for your SAP FC data?



Secure access

Choose the data you want to make available and authorize access to the consumers of your choice.



Direct questioning

Query SAP FC data directly at source, without duplicating or creating additional objects.



Web API

Retrieve your data from your BI tool, Excel, or any other tool capable of using a Web API.



Easy to deploy

Secure, easy-to-deploy architecture, available for SQL Server, HANA and Oracle.

How it works

A simple, efficient architecture



SAP FC

Administrators

You manage users’ functional profiles to give them access to CTS starlight functionalities.

Users

You continue to work in SAP FC without changing any of your habits.

Administrators

You create a starlight view, selecting an SAP FC data source, filtering the data and assigning access rights.

Users

You select a starlight view to which you have access, prepare a query, preview the results, then copy the generated lʼURL.



CTS starlight



CTS starlight

Administrators

You create a starlight view, selecting an SAP FC data source, filtering the data and assigning access rights.

Users

You select a starlight view to which you have access, prepare a query, preview the results, then copy the generated lʼURL.



BI tools

Users

You paste the lʼURL into your BI tool (e.g. Power BI, Excel via Power Query), to load and analyze the data in real time.

Detailed features

Explore all the capabilities of CTS starlight

Data

Data sources

All SAP FC data sources are accessible:
– Consolidated amounts
– Package amounts
– Exchange rates
– …

Dimensions

All dimension characteristics and properties are easily accessible in the form of a table for each dimension.

Filters

SAP FC filters can be used in data selection.

Data query

Data selection

CTS starlight offers data selection using :
– Wildcards
– Single value
– List of values
– SAP FC filter

Output format

CTS starlight automatically determines the relevant columns in the result, or the user can choose which columns to obtain.

Query control

The first 100 items of data can be previewed in CTS starlight. As soon as the query is built, CTS starlight evaluates the corresponding volume.

Integration

SAP FC environment

Easy integration into the SAP FC environment for a seamless user experience.

BI tools

Query from your favorite Business Intelligence tools.

Alternative to Excel links

Powerful, reliable alternative to SAP FC’s ‘Excel Links’ functionality.

Security

Access management

The data owner chooses which data to make available, and authorizes access to the consumers of his choice.

Data protection

No recopying of data or creation of additional objects in your database.

Secure architecture

Architecture designed to guarantee the security of your data at every stage.