Implementing SSAS Security

People Who Liked This Video Also Liked

Power BI Row Level Security
Power BI Row Level Security
Row Level Security
Row Level Security
Walkthrough: Analysis Services live report in Power BI
Walkthrough: Analysis Services live report in Power BI
Getting Started with Azure Analysis Services
Getting Started with Azure Analysis Services
SQL Server Training - Advanced SSAS
SQL Server Training - Advanced SSAS

Did this video help you?

CardiGun: Thank you a lot man! Awesome guid !

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

Robert James: Having the same problem. Yesterday I installed two drawers (36"W x 20"D, 7"H) both work well, but when putting in the 3rd drawer on top which is only 4 12" H, the nightmare started. A few ball bearings fell out, changed the slide, still no good, drawer goes in so far and then tightens, I've tried everything I know to fix it, to no avail. Just got finished trying again, no luck. I'll keep trying.
wrestlefest111: Perfecto!
Sheikh Mohammed Bilal Alam: Keya. Ye waterpruff hai ya nhi
waynechan1989: 草爸裤子是?
VinylReviews: Very cute! Wouldn't mind grabbing this guy and Atom Ant. I grabbed Magilla Gorilla and Mr Peebles for Xmas aha.
XtremeGamez: What did you score out of 10? SUBSCRIVE & LIKE you might win an iPhone 7!

Implementing SSAS Security