TheLotter2017's avatar
TheLotter2017
Frequent Visitor
8 years ago
Status:
Done

Olap Roles security doesn't work

Hi,

we 've implemented role security  in OLAP cube. We used  "Dimension Data" - "Measures Dimension"  in order to hide measures. In case of dimensions it works fine, but with measures - it doesn't work (doesn't matter if it calculated or not). I ve found that the identical case was open in the community - "Security for SSAS live connection not working" from 10/2016 with solution - to download  fix - "SQL Server 2014 SP2 CU6  and as windows security update CVE-2017-8516". But it doesn't work by us.  We appriciate for any addvice and decision. Thank you.

Gateways

4 Comments

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi TheLotter2017,

     

    It seems this is a known issue. The cause is in the SQL Server. The report ID is: CRI 28158195. I found the fixes here. Please try to install the cumulative updates for SQL Server. And you also can go to here for professional support.

     

    Best Regards,

    Dale

  • TheLotter2017's avatar
    TheLotter2017
    Frequent Visitor
    8 years ago

    Thank you very much! My mistake was that i used wrong cumulative uppdate (not sutable for my sql server version).

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Thank you for your feedback. I'm so glad you solved your issue.

     

    Best Regards,

    Dale

Completed Ideas