How to collect data from SAP Business Objects

By fetching data from an existing SAP BusinessObjects (BOBJ) report, you can use the data to create a Metric Insights element.

NOTE: You must have established connectivity for BOBJ.

1. Access New > Report (report example)

  1. Name the Report: Define a unique descriptive name of your element
  2. Reported: choose the measurement interval from the drop-down list
  3. Category: define a category this element belongs to
  4. To move on to defining data collection details, click Next: Define Report

2. Full Editor displays the Data Collection tab

  1. Data Source: select the account you have created for SAP BusinessObjects
  2. Data Collection Schedule: Specify the trigger that will be used to collect the data for your report
  3. Business Objects Document: Select the document which should serve as a basis for this Report
  4. Input Plugin Command listing all the data you would like to fetch from BusinessObjects (manually or using the Visual Editor below the plugin box)
  5. Once you are ready with you command, click Show Data.

2.1. Example using the Visual Editor

Example using the Visual Editor

The SAP Business Objects Query Builder is called by the Visual Editor button.

Select Fields and set Expressions and Save your settings.

3. Plug-in Commands

The query must include the columns, listed in the hint box to the right of the Plug-in command field:

  1. MI dimension (for dimensioned Metrics and Reports only);
  2. measurement datetime
  3. measurement value
Command Description Values Example
fields (dimensions) 'Fields' store the data that is used by Business Objects plug-in and can be compared to columns in a database table, containing one or more values. Business Objects plug-in divides data in two major types: dimensions and measures. (NOTE: Make sure not to confuse dimensions in Business Objects plug-in and Metric Insights Dimensions created for Reports and Metrics.) Dimensions in Business Objects plug-in are descriptive attributes (typically textual fields or discrete numbers), while measures are the fields that can be measured, aggregated, or used for mathematical operations. Dimension fields are usually used for row or column headings. fields = Channel, Year Month, Total Gross Profit
aggregates It is often required to look at numerical data (which is referred to in Business Objects plug-in as Measures) in an aggregated form (via mathimatical functions, such as summation, average, etc.) Aggregation functions perform a calculation on a set of values and return a single value. For example, if you have 3,000 sales transactions from 50 products in your data source, you might want to view the sum of sales for each product, so that you can decide which products have the highest revenue. sum(field), avg(field), count(field), count(*), min(field), max(field) aggregates = sum(profit), min(salary)
filter Using the 'filter' command you can exclude certain values or a range of values for a field. Several filering conditions can be combined by 'OR', 'AND'. NOTE: This filtering is performed by Metric Insights.
Each filtering condition consists of 3 values: field, corporate operator ( <, >, =< <=, etc.), value (numeric, date or ':last_measurement_time') filter = Year Month == '2016-04-11' AND Avg Sales Per Day > 1000000
external filter Filtering may be also performed externally by Business Objects plug-in. Business Objects plug-in handles external filters in the following format: ?(key)=(value) ?country = USA, UK
sort You can specify whether you want your field values to be sorted in the ascending or descenting order. ASC, DESC sort = Name ASC
var This command allows creating a new custom field that can be used in all commands listed above. var mon_salary = salary / 12
fields = Name, mon_salary

4. Plug-in command will be validated and data collected on Save from Visual Editor

  1. If your request syntax is valid, the statement box is green; if there are any errors, the box is colored in red and errors will be explained in the field below. If the request is validated successfully, the Report Columns table is to be displayed below the statement box.
  2. Enable and Publish your Report.

Result

The Report will be displayed in the Viewer.