ReportAdvanced.sql Script

Article
11/12/2009

The ReportAdvanced.sql script is located in the \Program Files\Microsoft Commerce Server\Support folder.

The ReportAdvanced.sql script creates the ReportAdvanced database role. The ReportAdvanced role inherits all of the permissions granted to the ReportViewer role.

The ReportAdvanced.sql script grants the ReportAdvanced role permissions on the tables in the Data Warehouse SQL Server database so that Business Desk users can do the following:

Create new dynamic reports
Delete custom reports
Modify existing reports

The ReportAdvanced.sql script grants the ReportAdvanced role the following permissions on the specified Data Warehouse tables:

Data Warehouse table	Permission
`Report`	Insert Update Delete
`ReportDimension`	Delete
`ReportParam`	Delete
`ReportStatus`	Delete
`GroupReportJob`	Delete
`GroupReportStatus`	Delete
`GroupReportDbObject`	Delete

ReportAdvanced.sql Script

Additional resources