Filter Using Role and User in Mdx query
Dear FriendsI am Using Sharepoint2013. I have creating hierarchy level Analytical Report based on Users.
I Will get user id thorough customdata. My Quire is how to join role and user table in mdx data.
Example I tried This
My Base table I have data like this
PK_ID Counrty Value Role_ID
1 India 10 1
2 Pak 9 1
3 USA 11 1
4 India 10 2
5 Pak 9 2
6 India 10 3
User Table
PK_ID USername ROLE_ID
1 Sachin 1
2 Dravid 2
3 Dhoni 3
Role Table
PK_ID ROleID
1 1
2 2
3 3
This is my table structure. How to creating filter in mdx query (User and role based).