Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add filter to only show countries that user has access (SSAS) Expand / Collapse
Author
Message
Posted Monday, July 16, 2012 8:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, 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
Post #1330149
Posted Monday, July 16, 2012 9:52 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 347, Visits: 1,344
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
Post #1330225
Posted Monday, July 16, 2012 2:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, 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]
))
Post #1330397
Posted Monday, July 16, 2012 2:44 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, 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
Post #1330413
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse