Analysis Reporting
The Analysis Reporting features enable you to analyze the data stored in the Data Warehouse. Microsoft Commerce Server provides dozens of reports so you can analyze product sales, Web site usage, site diagnostics, and so on.
You use the Analysis modules in Commerce Server Business Desk to run reports. If you are using Commerce Server Enterprise Edition, you can export the report results as lists, and then target content to users.
Commerce Server includes the following features that make reporting easy and fast:
- The remote access feature so business managers can access the OLAP database through firewalls or proxy servers and run reports. (This functionality requires SQL Server 2000 Enterprise Edition, including the Enterprise Edition of Analysis Services.)
- The drillthrough feature so you can use Pivot controls to expose underlying data.
In addition, Commerce Server reports run quickly because the data required for many of the reports is stored in an OLAP database.
The Analysis Reporting feature includes the following key components:
- Analysis Business Desk modules. Use these modules to run reports, and then manipulate them in Internet Explorer using Microsoft PivotTables and Microsoft PivotCharts.
- Dynamic reports. Use these reports to gather the most recent data in the Data Warehouse. Dynamic reports are created at run time.
- Dynamic drillthrough reports. Use these dynamic reports to display detailed information about all of the dimensions in the cube that contains the clicked dimension.
- Static reports. Run these reports immediately upon request, and then store them along with the data, in the Data Warehouse.
- The following table lists the reports included in Microsoft Commerce Server 2002.
.gif "Ee824276.note(en-US,CS.20).gif")
Note
- Reports with an asterisk (*) are available only in Commerce Server 2002 Enterprise Edition.
| Dynamic reports that access OLAP cubes (no static reports access the cubes) | Dynamic reports that access the SQL Server database | Static reports that access the SQL Server database |
|---|---|---|
| Usage Trends | *Registered Users by Date Registered | Query Strings (multi value) |
| User Trends | *User Days to Register | Query Strings (single value) |
| Activity by Browser | *User Registration Rate | Entry Path Analysis |
| Distinct Users by Time | *Registered User Properties | |
| Usage Summary by Week of Year | *Customer Sales | |
| Usage Summary by Day of Week | *New Registered Users | |
| Usage Summary by Hour of Day | ||
| General Activity Statistics | ||
| Entry Pages | ||
| Exit Pages | ||
| Bandwidth Summary | ||
| Bandwidth Trends | ||
| Product Sales | ||
| Hits by HTTP Status | ||
| Hits by Win32 Status | ||
| Directories | ||
| Top Referring Domains by Requests | ||
| Top Requested Pages | ||
| *Campaign Item Summary | ||
| *Ad Reach and Frequency by Date | ||
| *Ad Reach and Frequency per Advertiser | ||
| *Buyer Browse to Purchase | ||
| *Campaign Event Summary | ||
The following table lists key Commerce Server 2002 Help topics to help you learn more about Analysis.
| To learn about | See |
|---|---|
| Customizing reports | Analysis/Reporting Schema |
| Security for reports | Scripts for Securing Databases Accessed by Reports |
Copyright © 2005 Microsoft Corporation.
All rights reserved.