Dynamic Reports

  • Article

Dynamic reports are created at run time. Each time the report is run, it gathers the most recent data in the OLAP server if the data is dynamic OLAP data, and in the Data Warehouse (SQL Server) if the data is dynamic SQL data.

Only the report definition, which remains the same over time, is stored. Commerce Server does not save completed dynamic reports; however, you can export dynamic report results to Microsoft Excel and store them there. For information about exporting the results of a dynamic report to Microsoft Excel, see Exporting a Dynamic Report.

The following figure shows how a dynamic report is generated: data is stored in the Data Warehouse, cached in the OLAP database when the Report Preparation DTS task is run, and then accessed by the Business Desk client to run a report.

Figure showing how a dynamic report is generated

Copyright © 2005 Microsoft Corporation.
All rights reserved.