SSAS Measure Visibility based on User

Hi,

I have 4 measures in the Cube.

For example : M1 , M2 , M3 and M4

Requirement is "User A" should see all the 4 measures in the Cube whereas "User B” should only be able to see M3 and M4 measures.

Can this type of customization is achievable in the Cube?

asked Oct 12 '12 at 11:46 AM in Default

Kirman1
171 ● 2 ● 3 ● 9

(comments are locked)

1 answer:

You can achieve this by cell security defined for particular role. See Granting Custom Access to Cell Data.

answered Oct 12 '12 at 01:47 PM

Pavel Pawlowski
20.3k ● 5 ● 10 ● 20

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

ssas x141

asked: Oct 12 '12 at 11:46 AM

Seen: 249 times

Last Updated: Oct 12 '12 at 01:47 PM