Yes you should be able to do this using Cell level security, using an MDX
formula similar to this one:
NOT ((Measures.B,[Dim].) OR (Measures.B,[Dim].))
The MDX expression that you write must resolve to true for those cell that
you want to enable. So, based on how many cells you want to enable or
disable, your MDX expression may be constructed differently.
Hope this helps
Rita Nikas, MCDBA MCSE
Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
| Subject: Dimension security question
| Date: Tue, 31 Dec 2002 15:30:21 +0100
| I have a cube with two measures: A and B. And a dimension with three
| members: 1, 2 and 3.
| Now I created a role (r) and I want it to see all members of the dimension
| for measure A, but only member 3 for measure B:
| 1 A
| 2 A
| 3 A B
| Is it possible to define with dimension security options?
| Szymon Slupik, CDN S.A.