I want to retrieve a set of members from my cube where the first member in
the set is different depending on logged on user.

Anyone who has an idea how to achieve this?



Regards,
Christer

Hi Christer,

From your descriptions, I understood that you would like to retrieve
members from cube. However, I am not sure your means in "where the first
member in the set is different depending on logged on user." Could you show
me a sample?

If you means dynamic Dimension Security, I think the following docuemnts in
Webcase will help you a little.

Support WebCast: Dynamic Dimension Security in Microsoft SQL Server 2000
Analysis Services
http://support.microsoft.com/default...b;en-us;828343

More detailed information, I believe, will make us get closer to the
resolution.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Yes, I want a list of members. I have a "Division" dimension in my cube and
in my web app I have a list of 'Divisions'. When a user access this page I
want this list to be sorted in that way that the first entry in list is the
Division where current user is working for. For example:

User A who is working for division D1 should see his list:

D1
D2
D3
D4

User B who is working for division D2 should see his list:

D2
D1
D3
D4


Does this makes sence?

/Christer

""Mingqing Cheng [MSFT]"" <v-mingqc (AT) online (DOT) microsoft.com> wrote

Yes. What you are describing is dimension security.
I suggest you read BOL under the topics: "Dimension Security" and "Custom
Rules in Dimension Security".

I don't think that the topic of dynamic verses normal dimension security is
applicable here.
Only look at using dynamic dimension security if you find that you need more
than several hundred roles to implement your dimension security
requirements.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Christer K" <a@b.com> wrote

Hi Christer,

Based on the example you gave, this is not, strictly speaking, a
dimension security scenario. Each user has access to all members of
Division, only the order changes.

However, I think that the virtual cube approach to dynamic security,
from the [MS] Webcast mentioned by Mingqing, can be adapted. Something
like (see PowerPoint Slide 23):

'Union(STRTOSET(IIF(USERNAME="","{}",SETTOSTR(
NONEMPTYCROSSJOIN([Division].[Division].MEMBERS,
{STRTOMEMBER("[USERS].[All USERS].[" + USERNAME + "]")},
1)))), Division].[Division].MEMBERS)'
The second security cube should have one fact table record per user,
with 2 fields, for the Division and User keys.

Another option would be to add a hidden "User" dimension to the existing
cube, defining Division as a Member Property. This Member Property can
be used to select Divisiion.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!