Configuring the Analysis Server Account
The following Commerce Server views are used by dynamic reports that run against the SQL Server database. Grant the account that you define for the Analysis Server (OLAP) database Select access to all of these views. No other role or account requires access to these views:
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
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.