A data source is an object that provides a multidimensional, analytical view of business data. Data sources are the basis of analytical report content and are associated with a specific access context or can be unrestricted.
For information about access contexts, see User and Access Management under Access Restrictions.
Data sources contain the following objects:
Key figures
Fields according to which values are selected. Key figures are numeric values that have a unit of measure or currency assigned. Examples include Invoice Net Value and Purchase Order Quantity.
Characteristics
Fields according to which values are selected. Characteristics are alphanumeric, numeric, or text values. Examples include Product ID, Supplier, and Purchase Order Status. Variables are often associated with specified characteristics. Variables restrict characteristics to one or more specified value selections.
|
This documentation covers the SAP Cloud Applications Studio (“studio”) as a whole; therefore it describes all features that are available within the studio. Not all of these features are available for every cloud solution from SAP. Before using a particular feature, please consult the Feature Matrix to determine whether the feature is available for the cloud solution from SAP for which you are creating your solution. For details, see Feature Matrix. |
In the studio, you can create a data source based on an SAP business object or a custom business object. A data source includes specific data such as key figures and characteristics that administrators for Analytics can use for reporting in the SAP cloud solution.
When you define a data source, you select the relevant fields from your business objects, from SAP business objects, or from a combination of both. You can join the fields of multiple business objects by using associations. The system supports [1..1] associations with a foreign-key relationship.
Optionally, you can:
Define transformation rules.
For more information, see Transformation Rules.
Reference other data sources.
Define aggregation rules to summarize key figures (Summation, Minimum, Maximum, Count) in a report using characteristics.
For more information, see Aggregation.
The studio supports read access across deployment units in data sources. You can use cross-deployment-unit associations to access the data in business objects that are not assigned to the default deployment unit of your solution. For more information, see Syntax for Business Object Definitions under Deployment Unit.
You can join or combine data from different data sources that share common characteristics and contain semantically different key figures. For more information, see Combined Data Sources and Joined Data Sources.
For information about the SAP data sources available in the different application areas, see Data Sources. In addition to the available data sources, this information also gives an overview of the available key figure groups and common characteristics and key figures for data sources by area.
