Hi,

I'm facing a small problem...

I have an employees dimension.
My cube count the number of employees through a dynamic DCount formula.

Some users are not able to view the employee dimension, while other users
can see only some members and to finish some users has no restrictions.

Disabling the dimension cause my DCount formula to return nothing.
Disabling some members only cause the DCount formula to return wrong
aggregated values (only authorized members are counted)

I also have a cube used for my dynamic dimension security (only when I have
to disable some members but not all)

Does SQL 2005 provide a good way to do this?
we can wait for it to implement this security level.

Thanks for your help.

Jerome.

See if the approach in this thread could work (for AS 2000). The idea is
to create a virtual dimension from the original employees dimension,
which can be used for counting. It has no security, but is hidden from
users:

http://groups-beta.google.com/group/...rver.olap/msg/
77b89d2e9785f97c
From: Deepak Puri
Date: Wed, 31 Dec 2003 20:20:10 -0800
Subject: Re: Please help
...
Here is a possible solution to this type of problem for the Sales cube
in Foodmart. Not sure how it will work with your dimension, since it may
have > 64K leaf members:

Taking the Store dimension as an example, create a "StoreID" member
property from that dimension table key, then add a new virtual dimension
based on this property. Next, define a Measure like [No of Stores],
using the virtual dimension members: [StoreID].[StoreID].Members in the
NECJ(), rather then the original dimension members. The counts should be
same. Now set the "Visible" property of the virtual dimension to false,
but with no level security. The [No of Stores] measure still works, when
access to the Store dimension is limited to the (All) level. And the new
virtual dimension is hidden from users altogether.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

oohhh... good idea !!! I'll test this...
:-0

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

good !!!

my first tests are good and works fine...
thanks.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote