Creating Static Reports Using MDX

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. Insert the dimensions for the report into the ReportDimension table. For details on this step, see Adding the SQL Report Dimensions.
5. 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.
6. 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.

Note

• The Microsoft Commerce Server 2002 Software Development Kit (SDK), which is included with Commerce Server 2002, contains six SQL script files that enable you to create static and dynamic reports that query either SQL or OLAP data sources. The script files to create these reports are located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts. For more information, see New Report Scripts.

Copyright © 2005 Microsoft Corporation.
All rights reserved.