Creating a Dataset from SAP Integrated Business Planning Data
You can import data from SAP Integrated Business Planning into a dataset.
Procedure
-
Create a new dataset and choose a data source:
- Select (Main Menu) Create Dataset.
- Select Data from a data source.
- Select SAP Integrated Business Planning.
NoteFrom the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category. -
Select an existing connection, or select Create New
Connection to create a new connection.
If you create a new connection, you can select the following options:
- Connect to an On-Premise OData
serviceNote
To connect to an On-Premise OData service, ensure that the following tasks are completed:
- The cloud connector is installed. For more information, see Installing the SAPCP Cloud Connector.
- The cloud connector is configured. For more information, see Configuring the SAPCP Cloud Connector.
The SAP Analytics Cloud agent doesn't need to be installed during the configuration process.
For more information, see: Import Data Connection to SAP Integrated Business Planning.
- Connect to an On-Premise OData
service
- Type a name for your query.
-
Choose whether you want to build a query, or type in a query
manually.
- Select Build a Query to build a query using the query builder, or Freehand Query to manually type a query using V2 OData query syntax.
-
If you chose to use the query builder, select a table,
and then select Next.
Build your query by moving data elements into the Selected Data and Filters areas. For more information, see Building a Query.
-
If you selected the Freehand
Query option, type a query in the box and select
OK.
For example, the following query lets you get the product by rating:
Sample CodeKeyPredicate: Categories(1)/Products?$format=json&$select=Name ,Category/Name,Supplier/Name,Supplier/Address&$expand=Category,Supplier&$filter=Supplier/ID eq 0 FunctionImport: GetProductsByRating?rating=3&$format=json&$select=Name,Rating,Category/Name,Supplier/Name,Supplier/Address&$expand=Category,Supplier
For more information on the OData query syntax, refer to the OData documentation.
NoteSAP Analytics Cloud has the following validation rules for freehand queries:
- Duplicated parameters ($select, $expand, $format, $top, $skip, $inlinecount, $filter) in the query are not allowed.
- Only entity set and function import are supported.
- For function import, entity set is only supported as a return type.
- If $select contains the Nav property but without $expand property, the query is invalid.
Next Steps
After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.