You must Sign In to post a response.
  • Category: Sharepoint

    Filter Using Role and User in Mdx query

    Dear Friends

    I 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).
  • #767037
    Hi,
    Please find 'MDX query to filter data based on role' :
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0b88574a-512c-4388-aa4e-bd0f8ed1e12c/mdx-query-to-filter-data-based-on-role?forum=sqlanalysisservices
    Depending upon this you can try for your Base table.


  • Sign In to post your comments