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: The SAP Business Warehouse connector supports SAP BW 10.0 NW or 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
BAPI_MDDATASET_DELETE_OBJECT to retrieve the query results.
|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)
|Query Results (CSV)||File|
|1||Error||There was an error during execution|
|2||Error||Unable to authenticate with the SAP server|