You need to implement security in the cube to limit the sites visible to each user.
What should you do?
A . Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.
B . Create an SSAS server role for each user and assign the sites each user can access to his or her server role.
C . Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
D . Create a view on the Sales Transactions table that uses the Security Filter and User table data to limit the sites for each user.
Answer: C