none
Does row level security works if null value found in cube model ? RRS feed

  • Question

  • I have created one sales cube which has country wise sales table and country table and security group table like below. 

    SALES TABLE:

        country     sales_amount    security_group_id
         India             50000          S1
          UK               50000          S2
         NULL              50000          S1

    COUNTRY NAME:

        country  security_group_id
         India       S1
          UK         S2

    SECURITY TABLE:

      User_name  security_group_id
        ABC               S1
        XYZ               S2

    I am trying to restrict the data country wise,Here I got some issue what if country column has null value and how to handle row level security.

    Friday, August 16, 2019 9:32 AM

Answers

  • Hi Amira,

    Thanks for your question.

    The NULL value of the county column in table "SALES" doesn't affect the execution of row level security. Row level security does restrict data based on which windows user logins in. And the related condition columns are "User_name" and "security_group_id".

    For more details about Row level security, please refer:

    Dynamic row level security with Analysis services tabular model

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by Test test tes Friday, August 16, 2019 9:52 AM
    Friday, August 16, 2019 9:48 AM