I have a measure "ThirdPayment" , users of the role shouldnt see the value in detail...like for example..
ChannelName.Level3 Time.Level3 ThirdPayment
So if the users drills to Level 4 of Channel Name and Level 4 of Time no value should be seen for the ThirdPayment.
This scenarion only exist for ThirdPayment Measure.Request you to please help..
Hmss.. Basicaly thre will be two possibilities.
answered Aug 29 '12 at 05:39 AM
As per your solution to disable the DrillThrough for a particular role.
We have set option as "None" for "Local Cube/Drillthrough Access" in SSAS Role.
This option will disable both Drill To Detail & Actions in ProCalrity.
Regarding SSAS Dynamic Security , yes we can put that in Actions BUT "Drill To Detail" option will still be available in ProCalrity.
Attaching a short document which expalin the steps which have been performed link text
answered Aug 29 '12 at 10:02 AM