向用户授予访问规划服务器应用数据库的权限
此信息仅适用于操作报表,而不适用于 Microsoft Office PerformancePoint Server 2007 的其他任何部分。
您必须配置对用作规划服务器应用数据库的 SQL Server 数据库的访问权限。必须对要生成操作报表的所有应用数据库执行此过程。
我们建议您创建一个对该应用数据库中的以下表、视图和存储过程拥有相应权限的 SQL Server 角色。这些对象用于为操作报表提供数据。
注意: |
---|
您可以将服务器标识帐户用于报表。如果将服务器标识帐户用于报表,则无需对表、视图和存储过程的显式权限。有关向用户授予对 SQL Server 应用数据库的权限的信息,请参阅 SQL Server 联机丛书。 |
需要具有对表和视图的选择权限。需要具有对存储过程的执行权限。
Assignments.rdl 使用以下各项:
ApproverListView
AssignmentsView
BizAppNodes
BizFormsView
BizUsersView
CycleInstancesView
ReviewerListView
bsp_OperationalReportsGetModelSiteFromModelSiteID
bsp_OperationalReportsGetAssignmentsDetails
bsp_OperationalReportsGetAssignmentsStatus
bsp_OperationalReportsGetAssignmentsStatusCount
CycleInstances.rdl 使用以下各项:
AssignmentsView
BizAppNodes
BizUsersView
CycleInstancesView
D_Scenario
ErrorInfo
RecurrentCyclesView
bsp_OperationalReportsGetModelSiteFromModelSiteID
bsp_OperationalReportsGetCycleInstancesBizModelID
bsp_OperationalReportsGetCycleInstancesCycleName
bsp_OperationalReportsGetCycleInstancesDetails
bsp_OperationalReportsGetCycleInstancesEndDate
bsp_OperationalReportsGetCycleInstancesStartDate
bsp_OperationalReportsGetCycleInstancesStatus
FormStatus.rdl 使用以下各项:
ApproverListView
AssignmentsView
BizAppNodes
BizFormsView
BizUsersView
CycleInstancesView
ReviewerListView
bsp_OperationalReportsGetModelSiteFromModelSiteID
bsp_OperationalReportsGetAssignmentsFormStatus
bsp_OperationalReportsGetAssignmentsFormStatusCountDetails
bsp_OperationalReportsGetAssignmentsFormStatusDetails
Jobs.rdl 使用以下各项:
BizAppNodes
BizUsersView
CycleInstancesView
JobInstancesView
bsp_OperationalReportsGetModelSiteFromModelSiteID
bsp_OperationalReportsGetBizUsersRunByUserID
bsp_OperationalReportsGetJobInstancesDetails
bsp_OperationalReportsGetJobInstancesEndDate
bsp_OperationalReportsGetJobInstancesId
bsp_OperationalReportsGetJobInstancesStartDate
bsp_OperationalReportsGetJobInstancesStatus
bsp_OperationalReportsGetJobInstancesType
ModelAssociation.rdl 使用以下各项:
AssociationDimensionView
AssociationDimensionScopeView
AssociationMemberView
AssociationModelView
BizAppNodes
bsp_OperationalReportsGetModelSiteFromModelSiteID
bsp_OperationalReportsGetAssociationDimensionScopeSourceDimension
bsp_OperationalReportsGetAssociationDimensionScopeTargetDimension
bsp_OperationalReportsGetAssociationMemberDimensionAssociations
bsp_OperationalReportsGetAssociationModelAssociationList
bsp_OperationalReportsGetAssociationModelAssociationName
bsp_OperationalReportsGetAssociationModelDetails
bsp_OperationalReportsGetAssociationModelSourceModelLabel
bsp_OperationalReportsGetAssociationModelSourceModelSite
bsp_OperationalReportsGetAssociationModelTargetModelLabel
bsp_OperationalReportsGetAssociationModelTargetModelSite