Creating Dynamic Reports Using Cubes
New dynamic report OLAP reports are described as a running example in the following sections. To create the report, follow these steps:
Create the XML framework. For details on this step, see Create the XML Framework.
Insert the XML and other report parameters into the Report table. For details on this step, see Create the Base Report Definition.
The report shows up in the Reports section of the Analysis module of the Business Desk where it is modified using the pivot control.
A SQL script file, "Analysis - New dynamic OLAP report script.sql", is included in the SDK. This script includes the XML framework and can be modified to create the report. The file is located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts.