Implementing SSAS Security

People Who Liked This Video Also Liked

Implementing SSAS Security
Implementing SSAS Security
Row Level Security
Row Level Security
BISM Tabular Model Role-Based Security
BISM Tabular Model Role-Based Security
SSAS: Defining and Deploying a Cube
SSAS: Defining and Deploying a Cube
Microsoft BI training - Common Analysis Services Design Mistakes and How to Avoid Them
Microsoft BI training - Common Analysis Services Design Mistakes and How to Avoid Them

Did this video help you?

KEDR: 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

Heather Wilson: you're always beautiful, with or without makeup
SamTheCameronStan: Michelle's first game was actually 2006
Noppadon Noppadon: สนใจพันธุ์กุ้ง ส่งทั่วไทย line. I'd. 0984787450
ClimbFitFast: No idea how popular you are my friend and that's not being mean this is just the first of your videos I've seen but I can tell you right away your camera mount idea is absolutely genius. I'm a huge fan.
Christian Rios: So you’re telling me we cannot build anything in this game so what is the whole point of making this
Digiko豹子娘娘: Elf眼線沒有water proof..一下水整個暈開
Lee Hansen: love going back and watching these old mc videos

Implementing SSAS Security