Configuring the Analysis Server Account

  • Article

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.