Reports Accessing OLAP Cubes and SQL Server
This topic lists the Analysis reports that access the Analysis Server and SQL Server databases.
Use this list to identify the reports that groups of business managers need to access, and then assign the appropriate security credentials to those users.
Dynamic Reports Accessing the Analysis Server Database (OLAP Cubes)
Dynamic Reports Accessing the SQL Server Database
Static Reports Accessing the SQL Server Database
Dynamic Reports Accessing the Analysis Server Database (OLAP Cubes)
No static reports are based on the OLAP cubes. The following table lists the dynamic reports, and the cubes in the OLAP database that each report accesses.
Report | OLAP cube | Permissions for connstr_OLAP (server-side) |
---|---|---|
Usage Trends | mscsWebUsage | Select |
User Trends | mscsWebUsage | Select |
Activity By Browser | mscsWebUsage | Select |
Distinct Users By Time | mscsWebUsage | Select |
Usage Summary by Week of Year | mscsWebUsage | Select |
Usage Summary by Day of Week | mscsWebUsage | Select |
Usage Summary by Hour of Day | mscsWebUsage | Select |
General Activity Statistics | mscsWebUsage | Select |
Entry Pages | Entry Pages | Select |
Exit Pages | Exit Pages | Select |
Bandwidth Summary | Bandwidth | Select |
Bandwidth Trends | Bandwidth | Select |
Product Sales | mscsSales | Select |
Hits by HTTP Status | Page Usage | Select |
Hits by Win32 Status | Page Usage | Select |
Directories | Page Usage | Select |
Top Referring Domains by Requests | mscsWebUsage | Select |
Top Requested Pages | Page Usage | Select |
User Visit Trends | mscsWebUsage | Select |
Campaign Item Summary | mscsCampaign | Select |
Ad Reach and Frequency by Date | mscsCampaign | Select |
Ad Reach and Frequency per Advertiser | mscsCampaign | Select |
Buyer Browse to Purchase | Buyer Visits | Select |
Campaign Event Summary | mscsCampaign | Select |
Shopping Basket Events | Basket Events | Select |
Order Events | OrderEvents | Select |
Dynamic Reports Accessing the SQL Server Database
The following table lists the dynamic reports that access the SQL Server database, and the tables in the database that each report accesses.
Report | Data Warehouse tables | Permissions for connstr_db_dw (server-side) |
|||
---|---|---|---|---|---|
Registered Users by Date Registered | RegisteredUser LinkSiteRegisteredUserRel Site |
Select | |||
User Days to Register | UserRegistrationFactView | Select | |||
User Registration Rate | RegisteredUser LinkSiteRegisteredUserRel Site |
Select |
If you want to access these reports over HTTPS, you must rewrite them as static reports. For instructions, see New Report Scripts.
Static Reports Accessing the SQL Server Database
The following table lists the Business Desk reports and the Data Warehouse tables each report uses.
Report | Data Warehouse tables | Permissions |
---|---|---|
Query Strings (multi-value) | MVQueryStringFactTable MVQStringName Site Date |
Select |
Query Strings (single-value) | SVQueryStringFactTable Site Date |
Select |
Registered User Properties | RegisteredUser LinkSiteRegisteredUserRel Site |
Select |
Customer Sales | OrderFormHeader OrderGroup RegisteredUser Site CurrencyCode |
Select |
New Registered Users | RegisteredUser LinkSiteRegisteredUserRel Site |
Select |
Report | Data Warehouse stored procedure | Permissions |
---|---|---|
Entry Path Analysis | CSDW_MakePathAnalysis | Execute |
See Also
Scripts for Securing Databases Accessed by Reports
Data Warehouse Connection Strings
Configuring Data Warehouse Connection Strings
Configuring the Analysis Server Account
Accessing the Analysis Server Over HTTPS
Relationships Among Data Warehouse Cubes, Dimensions, Source Tables, and Reports
Copyright © 2005 Microsoft Corporation.
All rights reserved.