Hi
i am faced with a situation in implementing dimension security on AS 2005
cubes.

i have one cube with 5 dimension say A, B, C, D and E. i have implemented
dimension security on a dimension A. now when i query the data it is showing
me data filtered for that particular user for dimension A but not for others.
So i enable visual totals. And now when i browse the data is showing me the
filtered data for any dimension which i browse. But my requirement is little
different. i want to implement dimension security on Dimension A and based on
that it should filter the data on Dimension A , B and C, but not on Dimension
D and E. when i browse the data on dimension D or E it should show me all the
data irespective of hte security set on Dimension A. is this possible.

Do dimension D and E each have a default (All) level - if so, this
requirement seems inconsistent, since the visual totals for the other
dimensions would be displayed, using the default member from these
dimensions? Maybe some specific examples of data could help clarify
this.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi deepak

Dimension D and E have a default ALL member. Let me give you some more
information. basically i want to apply different security logic on each C, D
and E Dimension. and at any point in time if i use a particular dimension
then the security setting of that dimension alone should be applied and not
others.
Is this possible ?

"Deepak Puri" wrote:

"at any point in time if i use a particular dimension
then the security setting of that dimension alone should be applied and
not others".

Not sure what you mean by using a particular dimension - does that imply
selecting a non-default member for just 1 dimension? Keep in mind that
members of all dimensions are (explicitly or implicitly) included in a
tuple:

http://msdn2.microsoft.com/en-us/library/ms146040.aspx
...
A tuple identifies a cell from a cube. A tuple is composed of one
member, either explicitly or implicitly referenced, from each hierarchy
in the cube. If a member from a specific hierarchy is not explicitly
referenced in the tuple, the default member from that hierarchy is
implicitly included in the tuple.
How should the security work from a user perspective - could you
describe some specific scenarios and data? Maybe that will help clarify
how to map to the security mechanisms in SSAS.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***