2
kudos
spam Kudos Remove

Implementing measure security in SSAS 2008 - Some Random Thoughts

published 744 days, 38 minutes ago posted by jacobsebastianjacobsebastian 753 days, 21 hours, 41 minutes ago
Sunday, May 09, 2010 9:16:12 AM GMT Thursday, April 29, 2010 12:13:47 PM GMT

Recently, I was asked to implement security on a set of sensitive measures, such as profit and all calculated measures on top of them as part of the cube development. It looked like a very straight requirement and I never thought I would have so many sleepless nights over it for the next 2 months.

My very first way of thinking was using the default Microsoft cell security, where I would define a read-contingent policy for the sensitive measures. If you do not define an explicit read-contingent policy, the role will be able to read the derived measures of the sensitive Profit measure despite the fact that it does not have access to the Profit measure.

category: Analysis | clicked: 0 | | source: beyondrelational.com | show counter code

No comments yet, be the first one to post comment.

To post your comment please login or signup