ReportViewer.sql Script
The ReportViewer.sql script is located in the \Program Files\Microsoft Commerce Server\Support folder.
The ReportViewer.sql script grants the ReportViewer role permissions on the tables in the Data Warehouse SQL Server database and the OLAP database.
This section describes the permissions granted on the tables and views.
Running and Viewing Dynamic Reports (SQL): SELECT
Two dynamic reports access data in the Data Warehouse SQL Server database:
- Registered Users by Date Registered report
- User Registration Rate report
To enable Business Desk users to run and view these dynamic reports, the ReportViewer.sql script grants the ReportViewer role Select permissions on the following tables in the Data Warehouse:
Report
RegisteredUser
LinkSiteRegisteredUserRel
Running and Viewing Dynamic Reports (OLAP): SELECT
To enable Business Desk users to run and view dynamic reports that use data in the Data Warehouse OLAP database, the ReportViewer.sql script grants the ReportViewer role Select permissions on the following views in the OLAP database:
CampaignItemDimensionView
csdw_BuyerTypeDimensionView
csdw_CampaignEventsDXView
csdw_CampaignEventsFactView
csdw_SalesToUser
csdw_UserStatusViewLU
csdw_UserStatusViewRU
csdw_UserTypeDimensionView
csdw_VisitByUser
csdw_VisitInfoDXView
csdw_VisitInfoFactView
csdw_VisitTypeDimensionView
DateDimensionView
EventsDimensionView
FirstRequest
IsRequestDimensionView
PageGroupDimensionView
RegisteredUserDimensionView
SiteDimensionView
sysconstraints
syssegments
Trans_Predictor
UserBrowsingtoPurchaseFactView
UserRegistrationFactView
Viewing Static Reports: SELECT
To enable Business Desk users to view static reports that use data in the Data Warehouse SQL Server database, the ReportViewer.sql script grants the ReportViewer role Select permissions on the following tables in the Data Warehouse database:
ReportDimension
ReportInstanceDbObject
ReportInstanceParam
ReportParam
ReportStatus
GroupReportJob
GroupReportStatus
GroupReportDbObject
Running Static Reports: INSERT
To enable Business Desk users to run static reports that use data in the Data Warehouse SQL Server database, the ReportViewer.sql script grants the ReportViewer role Insert permissions on the following tables in the Data Warehouse database:
ReportInstanceDbObject
ReportInstanceParam
ReportStatus
GroupReportJob
GroupReportStatus
GroupReportDbObject
Deleting Completed Static Reports: DELETE
To enable Business Desk users to delete static reports that use data in the Data Warehouse SQL Server database, the ReportViewer.sql script grants the ReportViewer role Delete permissions on the following tables in the Data Warehouse database:
ReportInstanceParam
ReportStatus
See Also
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.