SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Add filter to only show countries that user has access (SSAS)


Add filter to only show countries that user has access (SSAS)

Author
Message
DaveDB
DaveDB
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 215
Hello,

I am new to performance point. I am using Performance Point as a reporting tool accessing an SSAS cube. I implemented data level security (by country), in the cube which works perfectly. The issue that I am having is that when a user logs into Performance Point they can see all of the countries BUT can only see data/measures that they have access to. So basically the data level security is working on the SSAS side, but Perforamnce Point is still showing all countries. I saw an area where I can place an MDX query in Performance Point. Is there an MDX query that I can use that will only display the countries the current user has access to?

Thanks,

Dave
denglishbi
denglishbi
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2225 Visits: 1364
What version of PerformancePoint are you using? If you are using 2010, then take a look at the data source you have defined for SSAS and verify that it is using Per User security versus the Unattended Account. If you have that in place you should be good to go. Depending on your configuration this could also require Kerberos to work properly and there is a SharePoint 2010 Kerberos white paper that you can download from Microsoft to go through the steps to get that setup.

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
DaveDB
DaveDB
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 215
Thank you for your quick response. I am using Share Point 2010. Here is the MDX query that is defined in the SQL Role in the SSAS cube. I am not sure how to answer your questions, but maybe this query will...


NonEmpty
(
[Dim Local Drilldown Cube].[Fact Key].Members,
(
STRTOMEMBER("[Security Users].[User Name].[" + CustomData() + "]"),
[Measures].[CUBE SECURITY Count]
))
DaveDB
DaveDB
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 215
One more question about how the security is defined in the data source:

In the data source designer, under Impersonal Information, I selected to use the service account. Is this the correct selection?

Thanks again for your help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search