You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a dimension called Product for Company.com.
You are updating a role called Tester for the Shopping Department.
For the Managers role, you decide to set the security later.
You should make sure that you permit the Managers role to operate data based on two or less workers.
Which is the correct answer?
A.
You should remove workers of the [Product].[ Products] hierarchy which include more than two children to the permitted configure for the Tester role.
B.
You should increase workers of the [Product].[ Products] hierarchy which include more than two children to the permitted configure for the Tester role.
C.
You should add expression below: [ Products].CurrentMember,,LEAVES).Count <= 2
D.
You should add expression below: [ Products].CurrentMember,,LEAVES).Count <= 2, [Product].[ Products].CurrentMember, 0)