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