How to collect data from SAP BusinessObjects (Dataset)
A Metric Insights Dataset or element can be populated automatically based on data fetched from SAP BusinessObjects. This article describes how to create a Dataset from the Plugin Data Sources Editor.
- You must have already established connectivity to SAP BusinessObjects via the respective plugin connection profile.
1. Plugin Data Sources Editor > Datasets tab
- Access Plugin Data Sources Editor > Datasets tab
- Click [New Dataset]
You will be redirected to the Dataset Editor.
2. Dataset Editor > Info tab
- Measured: select the measurement interval that applies to the level of aggregation that you want in your result set
- Collecting: new Datasets are always disabled by default to make sure that you can take time to configure them properly before enabling. This setting is duplicated at the top of the screen
- Name: provide a unique name for your Dataset. Preferably, the Dataset name should explain what kind of data it contains
- Description: optionally, provide any additional information about your Dataset
- Category: specify the Category where you Dataset will be placed
Move to the Data tab to define the source of data and how often it should be updated.
3. Define the Settings for Data Collection
There are two options to configure data fetching:
- with an MIQL query
- from the Visual Editor
See details below.
3.1. Using MIQL Plugin Command
- Data Source: select the connection profile you have created for SAP BusinessObjects
- Data collection trigger: specify the Trigger that will be used to collect data for your Dataset
- Element: select a SAP Business Object that should serve as a basis of your Dataset
- Click [Manage Filters] to add Filters to your data
- All added Filters will be displayed under SAP BusinessObjects Filter Defaults below
- Click the Edit (Pencil) icon to specify how many Values will be used for data filtering
- For more information on using Filters, view Pre-filtering SAP BusinessObjects data
- In the Command tab, input an MIQL Plugin Command listing all data that needs to be fetched from SAP BusinessObjects
- Validate your query
- Entire field names that contain special characters, aggregation and commas must be enclosed in quotes (single or double).
- It is acceptable to enclose all fields and values in quotes.
[…] + Notation is used to signify that the MIQL parts of a statement are optional/can be repeated.
3.2. Using the Visual Editor
The SAP BusinessObjects Query Builder allows for data fetching without the need to learn the plugin syntax and helps avoiding typos/mistakes.
- Select the fields for your Dataset
- Optionally, add Derived fields and/or Count of duplicate rows
Save your settings. Plugin command validation will start automatically.
- Derived fields can later be modified using the Edit (Gear) icon
- Filters added as a field to the results set are distinguishable by a Filter (icon)
4. Plugin command will be validated and data collected on Save
- If the command is validated successfully, the Dataset columns and Data Preview are going to be shown below.
- At the upper right corner of the screen, click Enable & View.