SSAS - restricting/masking access to a dimensionDimension Security in SSAS & SSRSWays to set different security permissions for SSAS from SSRS?How to make my SSAS cube production readySSAS large dimensionSSAS Changing Dimension Security Requires Processing Cubes?Dimension attributes in SSAS browser windowSSAS Dimension Data Permissions not applied to measures when the dimension is not selected when querying the cubeSSAS cube restrict data source by roleSSRS - Creating distinct parameter values from SSAS OLAP cubeRestrict access to cube based on role in SSAS
My Project Manager does not accept carry-over in Scrum, Is that normal?
Align all symbols in a LaTeX equation
Received a package but didn't order it
How can this Stack Exchange site have an animated favicon?
Need Improvement on Script Which Continuously Tests Website
Character Transformation
Why does C++ have 'Undefined Behaviour' and other languages like C# or Java don't?
I transpose the source code, you transpose the input!
Beyond Futuristic Technology for an Alien Warship?
Why was it decided in 1956 to abolish the spelling чорт (devil) in favor of чёрт?
Would you write key signatures for non-conventional scales?
A food item only made possible by time-freezing storage?
Is the iPhone's eSim for the home or roaming carrier?
Diminutive -ula
Why is volatility skew/smile for long term options flatter compare to short term options?
What is the difference between an astronaut in the ISS and a freediver in perfect neutral buoyancy?
Which lens has the same capability of lens mounted in Nikon P1000?
What does it mean by "my days-of-the-week underwear only go to Thursday" in this context?
Can my former employer sue me if I don't give them the photos I took (taking pictures was not part of my job description)?
How can I indicate the first and the last reference number written in a page of the bibliography in the header of the page?
Whaling ship logistics
Why isn't there armor to protect from spells in the Potterverse?
I am not a pleasant sight
Number of list elements less than a given integer
SSAS - restricting/masking access to a dimension
Dimension Security in SSAS & SSRSWays to set different security permissions for SSAS from SSRS?How to make my SSAS cube production readySSAS large dimensionSSAS Changing Dimension Security Requires Processing Cubes?Dimension attributes in SSAS browser windowSSAS Dimension Data Permissions not applied to measures when the dimension is not selected when querying the cubeSSAS cube restrict data source by roleSSRS - Creating distinct parameter values from SSAS OLAP cubeRestrict access to cube based on role in SSAS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have SSRS reporting set up from an SSAS cube. Reporting contains various dimension data including certain confidential items. I want to set up a role that doesn't have permissions to view the confidential data, but I want those users to be able to run the report and view it, just without those items. I've tried restricting access to the relevant dimension data but then the whole report is blank.
Example - Full report shows -
Name: John Smith
ID: 123456
Gender: Male
City: London
I want to configure the role so they can run the report and see everything except the name
Is this possible?
security permissions ssas olap-cube
asked Mar 28 at 18:38
RooRoo
11 bronze badge
add a comment
|
I have SSRS reporting set up from an SSAS cube. Reporting contains various dimension data including certain confidential items. I want to set up a role that doesn't have permissions to view the confidential data, but I want those users to be able to run the report and view it, just without those items. I've tried restricting access to the relevant dimension data but then the whole report is blank.
Example - Full report shows -
Name: John Smith
ID: 123456
Gender: Male
City: London
I want to configure the role so they can run the report and see everything except the name
Is this possible?
security permissions ssas olap-cube
asked Mar 28 at 18:38
RooRoo
11 bronze badge
add a comment
|
I have SSRS reporting set up from an SSAS cube. Reporting contains various dimension data including certain confidential items. I want to set up a role that doesn't have permissions to view the confidential data, but I want those users to be able to run the report and view it, just without those items. I've tried restricting access to the relevant dimension data but then the whole report is blank.
Example - Full report shows -
Name: John Smith
ID: 123456
Gender: Male
City: London
I want to configure the role so they can run the report and see everything except the name
Is this possible?
security permissions ssas olap-cube
asked Mar 28 at 18:38
RooRoo
11 bronze badge
I have SSRS reporting set up from an SSAS cube. Reporting contains various dimension data including certain confidential items. I want to set up a role that doesn't have permissions to view the confidential data, but I want those users to be able to run the report and view it, just without those items. I've tried restricting access to the relevant dimension data but then the whole report is blank.
Example - Full report shows -
Name: John Smith
ID: 123456
Gender: Male
City: London
I want to configure the role so they can run the report and see everything except the name
Is this possible?
security permissions ssas olap-cube
security permissions ssas olap-cube
asked Mar 28 at 18:38
RooRoo
11 bronze badge
asked Mar 28 at 18:38
RooRoo
11 bronze badge
asked Mar 28 at 18:38
RooRoo
11 bronze badge
asked Mar 28 at 18:38
RooRoo
11 bronze badge
asked Mar 28 at 18:38
RooRoo
11 bronze badge
11 bronze badge
add a comment
|
add a comment
|
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55404721%2fssas-restricting-masking-access-to-a-dimension%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55404721%2fssas-restricting-masking-access-to-a-dimension%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
