You need to implement security in the cube to limitthe sites visible to each user.
What should you do?
A.
Create an SSAS database role in the cube for eachuser and assign the sites each user can access to his
or her database role.
B.
Create a view on the SalesTransactions table thatuses the SecurityFilter and User table data to limit the
sites for each user.
C.
Create an SSAS server role for each user and assign the sites each user can access to his or her server
role.
D.
Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement
dynamic dimension security.
OK
D