|
Hi, 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..
(comments are locked)
|
|
You can define a Cell Security for particular role in the SSAS Database. See Granting Custom Access to Cell Data on MSDN. Pavel.. I want to disable the Drill To Detail Option available in ProClarity for the Measure Third Payment. In the Cube Role I have added the following MDX in the Denied Member set of Dimension Data Tab DRILLTHROUGH MAXROWS 1000 SELECT {[Measures].[Third Payment]} ON 0 FROM [BARS] RETURN [$Trade Date].[Date],[$Value Date].[Date], [$Customer].[Customer ID], [$Customer].[Customer Name], [$Customer].[Fund Manager Name], [Fact Trade TPFX].[TPFX - Buy Amt], [Fact Trade TPFX].[TPFX - Sell Amt] But it is giving syntax error..is this the right approach. Please help
Aug 28 '12 at 01:31 PM
Kirman50
So you want only to disallow access to the details when executing the drill through action? Or also prohibit access to the aggregated value of that particular measure?
Aug 28 '12 at 02:10 PM
Pavel Pawlowski
Pavel.. I want to prohibit access to the details BUT show the aggregated value of that particular measure. Please help..
Aug 28 '12 at 04:51 PM
Kirman50
(comments are locked)
|
|
Hmss.. Basicaly thre will be two possibilities.
link textPavel... 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.
Aug 29 '12 at 09:57 AM
Kirman50
(comments are locked)
|
|
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
(comments are locked)
|
