dbTalk Databases Forums  

Cube access

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cube access in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PerJensen
 
Posts: n/a

Default Cube access - 02-09-2006 , 09:39 AM






I have a problem with some of the cubes I administrate. The setup is as
follows:

The users access a virtual cube that performs the access control to the
underlying cube. The users sometimes lose their access to the cube and to
re-establish the access I have to process the virtual cube. The users tell me
that their access disappears when a user without permission to access the
virtual cube tries to access it. I have tried to test this scenario but I
haven't succeeded in "corrupted" the virtual cube.

The cuberole is defined with the following MDX statement:

STRTOSET(IIF(USERNAME="","{}",SETTOSTR(GENERATE(NO NEMPTYCROSSJOIN([Shortdiv].[Shortdiv].MEMBERS,
{StrToMember( iif(IsError(StrToMember("[Adgang].[" + Mid( USERNAME, Instr (1
, USERNAME, "\" ) + 1 ) + "]")), "[adgang].[All adgang].[UNKNOWN]",
"[Adgang].[" + Mid( USERNAME, Instr (1 , USERNAME, "\" ) + 1 ) + "]" ))},1),
{LINKMEMBER([Shortdiv].CURRENTMEMBER, [Shortdiv])}))))





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.