Data Collection #
Reportworq supports several functions that are used to “writeback” data into configured data sources like IBM Planning Analytics via the native DBS, DBSS, DBSW formulas. These formulas are only available and executed when Reportworq receives a file for processing using a Reportworq Data Collection license.
RWMDX #
The RWMDX function returns data to an Excel spreadsheet from an IBM Planning Analytics OLAP datasource, using a named Reportworq datasource connection and MDX query.
Syntax
RWMDX( Range or Table Name, Connection Name, MDX Query)
| Parameter | Description |
| Range or Table Name | A reference to an Excel table or a cell range. See Excel Ranges or Table Names for more information. |
| Connection Name | The name of an existing datasource connection that is defined in Reportworq, which will be used to retrieve data for the RWMDX formula. For more information on the configuration of these connections, please see IBM Planning Analytics datasources. |
| MDX Query | The query to execute against the datasource provider. The query must only return a single dataset. |
Examples
The following examples are based on a IBM Planning Analytics datasource connection named “SampleData” in Reportworq.
