ReportViewer.sql Script

Article
11/12/2009

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