1.

You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database for Abc.com. The SSAS database contains a dimension named CKOrders. You are in the process of updating a role named Analyze. You decide to set the security for the Managers role at a later stage. You need to ensure that member of the Managers role are able to run data based on two or less customers. What should you do?

A. You should consider removing the customers of the [CKOrders].[Order] hierarchy which has more than two lower level roles to the allowed configuration for the Analyze role.
B. You should consider adding the customers of the [CKOrders].[Order] hierarchy which has more than two lower level roles to the allowed configuration for the Analyze role.
C. You should consider inserting the expression: [CKOrders].CurrentMember,,LEAVES).Count u003c= 2
D. You should consider inserting the expression
Answer» D. You should consider inserting the expression


Discussion

No Comment Found