Data Warehouse OLAP Database
The Analysis Server hosts the Data Warehouse OLAP database (cubes). The Report preparation DTS task populates the cubes with data. The Report Caching DTS task and the Business Desk user access this data when they run dynamic OLAP reports.
To secure the OLAP database, do the following:
- Grant the account that you define for the Analysis Server Select access to all of the Commerce Server views.
- Configure the connection strings to the OLAP database to use Windows Authentication. The connection strings to the OLAP database are ConnStr_OLAP (server side) and ConnStr_OLAP_Client (client side). For instructions, see Configuring Data Warehouse Connection Strings.
- Limit membership in the OLAP Administrators user group. OLAP administrator security is controlled using the Microsoft Windows® 2000 group named OLAP Administrators.
- Limit membership to the Analysis Server database to users or user groups that need to run reports. Additionally you can control access to specific cubes and dimensions used in reports. By default, all users in the Analysis Server domain (and any trusted domains) are granted access to all cubes in the Commerce Server 2002 Analysis Server database. You use the Cube Role Manager in SQL Server Analysis Manager to configure cube security by limiting access of specific users or groups to cubes and dimensions. For information about the OLAP cubes in the Data Warehouse, see OLAP Cubes. For information about Commerce Server analysis reports, see Commerce Server 2002 Reports.
Important
- If the OLAP cubes are on a different computer than the Data Warehouse SQL Server database, you must supply the login credentials for MSSQLServiceOLAPService services for the following cases:
- The login user has permission to the Data Warehouse SQL Server database.
- The login user is a member of the OLAP Administrators group.
The following table lists the dynamic reports and the cubes in the OLAP database that each report accesses. This information is provided for reference.
Report | Requires Select access on these OLAP cubes |
---|---|
Usage Trends | mscsWebUsage |
User Trends | mscsWebUsage |
Activity By Browser | mscsWebUsage |
Distinct Users By Time | mscsWebUsage |
Usage Summary by Week of Year | mscsWebUsage |
Usage Summary by Day of Week | mscsWebUsage |
Usage Summary by Hour of Day | mscsWebUsage |
General Activity Statistics | mscsWebUsage |
Entry Pages | Entry Pages |
Exit Pages | Exit Pages |
Bandwidth Summary | Bandwidth |
Bandwidth Trends | Bandwidth |
Product Sales | mscsSales |
Hits by HTTP Status | Page Usage |
Hits by Win32 Status | Page Usage |
Directories | Page Usage |
Top Referring Domains by Requests | mscsWebUsage |
Top Requested Pages | Page Usage |
User Visit Trends | mscsWebUsage |
Campaign Item Summary | mscsCampaign |
Ad Reach and Frequency by Date | mscsCampaign |
Ad Reach and Frequency per Advertiser | mscsCampaign |
Buyer Browse to Purchase | Buyer Visits |
Campaign Event Summary | mscsCampaign |
Shopping Basket Events | Basket Events |
Order Events | OrderEvents |
Do not grant access to the following cubes; they are not directly accessed by the reports:
mscsCampaignEvents
mscsDateIntersect
mscsOrderedImpressions
mscsVisitInfo
Copyright © 2005 Microsoft Corporation.
All rights reserved.