Design Access control in SSAS Tabular Model

Manikant Mahovia 41 Reputation points
2023-02-07T17:42:26.6033333+00:00

Hi Everyone,

I need some help to design the dynamic access control in SSAS tabular model.

Below is the requirement:

  1. Row level security but access aggregate level data
  2. Using AD groups (AD groups contain the employee email address - UserId)

Note: I have design the tabular model as pure Star Schema. All Employee connect to Department

See below model:

User's image

Please feel free to ask any question for any clarification.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
304 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
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,244 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alexei Stoyanovsky 3,411 Reputation points
    2023-02-08T06:24:32.19+00:00
    1. will require a separate table with aggregate data. Secured detailed table will not allow the engine to calculate totals including secured data.
    2. will require importing AD group membership data into the model
    0 comments