To extract tabular data from SAP® Business Warehouse (BW) based on a multidimensional expressions (MDX) query, add a step with an SAP Business Warehouse Execute MDX Query command.
Note: This connector supports SAP BPC NW/MS 10.0 or SAP BPC 10.1 NW, with non-HANA databases.
To enable this command, an IT admin first creates an SAP Business Warehouse connector.
Execute MDX query
To execute an MDX query against SAP BW data and extract the results to a comma-separated values (CSV) format, add an Execute MDX Query command. When the command runs, it executes the Business Application Programming Interface (BAPI) functions RSR_MDX_CREATE_OBJECT, RSR_MDX_GET_AXIS_INFO, RSR_MDX_GET_FLAT_DATA, and BAPI_MDDATASET_DELETE_OBJECT to retrieve the query results.
Properties
| Property | Detail |
|---|---|
| Query | Enter the MDX query to execute. To create the query, run a report with the desired data in SAP BW, and capture its MDX syntax. Periodic data may require a custom measure.
Note: To test the query in SAP BW, execute transaction code (tcode)
|
Outputs
| Output | Output type |
|---|---|
| Query results (CSV) | File |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | There was an error during execution |
| 2 | Error | Unable to authenticate with the SAP server |