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.
You have created and opened a solution in the studio. For more information, see Create a Customer-Specific Solution.
To create a data source based on a custom business object, you must create and activate your custom business object.
For more information, see Business Objects Quick Guide.
If you want to allow referencing of your data source by another data source and enable navigation from a report to another floorplan that is not a standard UI, you must define this UI. For information, see Generate Screens for a Business Object.
In the Solution Explorer, do the following:
|
Custom Business Object |
SAP Business Object |
|---|---|
|
Right-click your business object and select Create Data Source. The Data Source Wizard opens. |
|
In the Create a Data Source step, define your data source by doing the following:
Select a namespace.
By default, the namespace for your solution is selected; however, to create a data source based on an SAP business object, you can select an SAP namespace.
Select a business object.
Select an anchor node to link to the data source.
|
|
Enter the data source name.
Optional: Enter a description of the data source.
Optional: To allow access restrictions for data in reports based on this data source, select Enable Access Control.
The access restrictions of the anchor business object are inherited; therefore customers can only assign reports based on this data source to work center views with the same access control.
Optional: To allow referencing by another data source and allow the fields of your data source to be used in reports based on the referencing data source, select Allow Referencing.
If you want to allow referencing, under Reference Details, select the key field.
Optional: Under Object Based Navigation, specify a target UI.
Users will be able to navigate from the report to this floorplan.
Optional: To enable read access logging for sensitive personal data, select the Log Sensitive Personal Data checkbox.
Click Next.
In the Select Data Source Fields step, select the fields you want to include in the data source.
You can include fields from other business objects by using associations. 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 Deployment (Business Object).
|
Not all fields and associations modeled in the business object are supported. Only supported fields and associations are displayed. |
Click Next.
Optional: In the Define Transformation Rules step, define transformation rules for fields of data type text (such as name and description), date, or GLOBAL_DataTime by doing the following:
In the Business Object Element area, select a field and on the Transformation tab, select a transformation rule.
Define a field name for the transformation field and then press ENTER.
If the transformation rule allows the selection of a second parameter, next to the Parameter field, click ....
The Select Additional Transformation Rule Parameter dialog box opens.
In the Select Additional Transformation Rule Parameter dialog box, select a second parameter by selecting a row and clicking the first cell in the row.
For information about the available transformation rules, see Transformation Rules.
Click Next.
Optional: In the Define Referenced Data Sources step, modify the parameters by doing the following:
Display and define the names for the selected fields that are characteristics.
Assign an existing data source to each parameter.
|
If necessary, you can change the display name for each parameter. You can assign an existing data source if the fields of an SAP business object are already included in an SAP data source. |
Click Next.
Optional: In the Define Aggregation Behavior step, define the aggregation behavior for business object elements that are key figures.
For more information about aggregation behavior, see Aggregation.
|
The default aggregation of every key figure is Summation. You can change the default or add new aggregations. |
Optional: In the Select Sensitive Personal Data Fields step include sensitive personal data fields for read access logging by selecting the Create Log checkbox against the field. You must then include a reference for the sensitive personal data field.
|
If you select a field that has transformation rules, you can include only the parent field as the reference. |
In the Review step, check that the information you have entered is correct and then click Finish.
|
If you have defined aggregations, check that the selected aggregations are displayed correctly. |
A new item with the file extension .ds (
) appears in the Solution Explorer.
In the Solution Explorer, right-click the data source you have created and select Activate.
The data source is available in SAP's cloud solution. You can check the result by logging on to SAP's cloud solution. In the Business Analytics work center, navigate to the Design Data Source view and search for your data source.
In the studio, you can now create a report that uses your data source. For more information, see Create a Report.
You define the report and the report layout in SAP's cloud solution in the Design Reports view of the Business Analytics work center. For more information, see the relevant documentation of SAP's cloud solution.