Creating Dynamic Reports

In Microsoft Commerce Server 2002, new dynamic reports can be created through the Analysis module in Commerce Server Business Desk or by modifying an existing report and running scripts included in the Microsoft Commerce Server Software Development Kit (SDK).

For more information about using Business Desk to create new dynamic report definitions, see Creating New Dynamic Report Definition.

Dynamic reports use an XML framework that contains either an SQL query or a reference to a cube. New dynamic reports can be created from existing dynamic reports by running the existing report, editing the pivot view, and saving the result as a new report. If the new report requires a different SQL query or cube than any existing report, an SQL script must be run. Scripts are provided that can be modified to create both types of dynamic reports. These scripts are located in the installation folder under \Microsoft Commerce Server\SDK\Samples\Business Analytics\Scripts.

New dynamic reports are created by following these steps:

  1. Run the modified SQL script to create the basic report.
  2. Open the newly created report or an existing dynamic report.
  3. Modify the report using the features of the pivot control.
  4. Save the customized report as a new report.

When the above steps have been successfully completed, the new report will appear in the Reports module of Business Desk.

Ee784240.note(en-US,CS.20).gifNote

  • 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.

This section contains:

Copyright © 2005 Microsoft Corporation.
All rights reserved.