Creating Static Reports Using MDX

  • Article

The steps involved in creating a static MDX report are described as a running example in the following sections:

  1. Write the MDX query of interest. For details on this step, see Writing the MDX Query.

  2. Add parameter tags to the query. For details on this step, see Adding MDX Parameterization.

  3. Create the base report definition as a set of INSERT statements (one of which is for the query) into the Report table. For details on this step, see Creating the MDX Base Report Definition.

  4. Add the report parameters corresponding to the query parameter tags into the ReportParam table. For details on this step, see Adding the MDX Report Parameters.

  5. Run and display the report.

The report dimensions are inherent to the query and do not have to be inserted into the ReportDimension table. After the steps have been successfully executed, the report will be listed in the Reports module in Commerce Server Business Desk.

  • The running example creates a static report of the top 100 referring domains by visit.


All rights reserved.