Implementing SSAS Security

People Who Liked This Video Also Liked

Implementing SSAS Security
Implementing SSAS Security
SSAS Tabular Model-Security-Part-1-Role Based Security
SSAS Tabular Model-Security-Part-1-Role Based Security
Review DirectQuery in SSAS 2016. best practices and use cases
Review DirectQuery in SSAS 2016. best practices and use cases
24 Hours of PASS: SSAS Design and Performance Best Practices
24 Hours of PASS: SSAS Design and Performance Best Practices
See whats new in SQL Server Analysis Services 2016 Tabular Models
See whats new in SQL Server Analysis Services 2016 Tabular Models

Did this video help you?

Joseph Sargeant: Just wanted to say thank you, this helped me a lot and I was able to implement dynamic security after watching your video

Rohan Girotra: can we implement this
like mapping table has (Userid, Category id)
with user table primary table
and other dimensions lets say product dimension which has ProductId as primary key and categoryId as a foreign key of category Dimension.
so that user will able to see only see specific Product with category

I joined mapping table it with Category id of Product dimension
but it is not working

Pedram E: Audio is not clear

NorCalBully: This has overlapping audio--is there another copy of it anywhere?

Zakir Hussain: Very in trusting, help me in great deal

Francisco Laborda: Amazing!

Dadasaheb Kamble: Thank You for this great Video,it really helped me a lot...

Martin Gatto: Great videa, thanks. I have a question. Whats happen when u have a measures where some measures have to be available for one role, but not availab,e for another group.

what I mean is that I understand that from the role, I set the measure for this is not available (not measure current member is ....). But the problematic would make the measure does not see it in the list of Measures available when the user belonging to that role enter ssas (when do the browse cube). is this possible ?, muchabgente recommended lerspectvas, but the outlook may not be related to a role as I understand.

Kyle Reierson: Nice video, exactly what I was looking for and explained very clearly.

bhaskara gonegandla: You implemented SSAS security is very well. Here I am facing a problem like
if the user connect to cube using EXCEL, then able to read all the data.
Please can you give clarity on solving issue with EXCEL.

Daniel Montani: Nice job
and thanks for the final link

Don Reddy: Its really Great Work...Really Help-full to me Thanks a Lot

Aram Taieb: Thanks for a great tutorial! 
I think I've managed to reproduce all of your steps for the dynamic role. 

However when checking the following script in dynamic-role on the dimension data I get an error:

nonempty([Plant].[Plant Name].[Plant Name].members,
([measures].[Plant Admin Count],
StrToMember("[User].[Username].&[" +username()+"]") 

The error:
Check MDX script syntax failed because of the following error:

An error occurred in the MDX script for the dimension attribute permission's allowed member set: The dimension '[User]' was not found in the cube when the string, [User].[Username].&[XYZ\xyzxyz], was parsed.

For help, click:

Do you have any ideas? :)
Implementing SSAS Security 5 out of 5

Featured Video

Video How to Guide

Latest Comments

George Kershaw: @MrBMXNJ nope, just hold it. the camera has a pretty good image stabiliser :D
Mouna Maes: Hi Keisha, I am always lost when you say 3 custom highlighting powder? what is that and where can i find it? Ive been looking for it everywhere.
s27945: 田甄甄甄
InabaPrism: I've come to notice this XBOX "lead" is pretty meaningless, even in the UK. Why? Cause there are already far more PS4 consoles sold out there. With that "lead" in sales, the total sales for FIFA on XONE were barely above 610,000. You know how many copies were sold for the PS4? over 2.2 Million.
KidsPlanet: Have a nice day!
Itallo Arruda: Brasillllllllllllllllllllllllllllllll
Yasmim Esthaffany: eu amor Selena Gomez sou sua fã número 1

Implementing SSAS Security