Drillthrough not working with data level securtiy enabled in SSAS cube for a read user role

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Drillthrough not working with data level securtiy enabled in SSAS cube for a read user role

Drillthrough not working with data level securtiy enabled in SSAS cube for a read user role

Topic RSS Feed

Posts under the topic: Drillthrough not working with data level securtiy enabled in SSAS cube for a read user role

Posted: 2/6/2012

Jedi Youngling 30  points  Jedi Youngling
  • Joined on: 7/19/2011
  • Posts: 10

I have a read user role in which the users are restricted to some of the attributes of a

dimension.
Created a drillthrough action in cube with some set of measures and dimensions (dimension or

dimension attributes which has data level securtiy enabled are not part of the drillthrough

action).
Set property of Local Cube/Drillthrough access to Drillthrough and Local cube under Cubes

tab in read user role.

Now the drillthrough action is not working for read user role.
But if i remove the data level security then the drillthrouhg action is working fine.

Do i need to set any addtional property?

Appreciate your help, thanks in advance.


Page 1 of 1 (1 items)