Question on Dimension Security in SSAS cubes

Prema Prabhu 0 Reputation points
2024-02-08T16:43:40.5433333+00:00

Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For example for Adventure Works cube: I have two roles

  1. DL-Users-Role1 Here user do not have any restriction on dimensional data. this is accessible to all from the Distribution List
  • DL-Users-Role1
  1. DL-Users-Role2 - For this Role Here specific dimensions like: Sales Channel, Sales Reason Sales Summary Order Details Sales Territory Should not be accessible to the users from Distribution List - DL-Users-Role2. Rest of the dimensions they can access it. Can you help me, how can I achieve this? I also would like to have MDX for this, where can I update? Thanks in Advance
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,231 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 38,861 Reputation points
    2024-02-08T19:55:55.2566667+00:00

    Dear Team,

    No "team" here, Question&Answer is community forum with volunteers. And the rest of your your post ist every unclear, mostly hypotetically, where no one can work on. You have to to provide clear, detailed informations.

    0 comments No comments