Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS ROLES (Dimension Data MDX EXPRESSION) Expand / Collapse
Author
Message
Posted Thursday, July 11, 2013 8:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 29, 2014 11:10 PM
Points: 1, Visits: 35
hi all,
Need some help using the mdx expression for dimension data in SSAS Roles.
the question is......
in my cube,i got 2 user fields in my dimension
example:: [Username].[user1] and [username].[user2]
i need to check if the xyz is available in either user1 or user2 and accordingly display them else a blank space while browsing the cube
i want to create a role which will display the dimension data for xyz if it exists in user1 or user2 else it will be left blank. May be some kind of mdx query in the advanced tab of dimension data in ssas roles.

I am not so sure if you got my point.
any queries do let me know....
thanks for d help in advance

Post #1472618
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse