Export (0) Print
Expand All

Use Analysis Services EffectiveUserName in SharePoint Server 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013 Enterprise

Topic Last Modified: 2013-12-18

Summary: Use the EffectiveUserName option in Excel Services or PerformancePoint Services for per-user authentication with Analysis Services data sources.

EffectiveUserName is a SQL Server Analysis Services connection string property that contains the name of the user who is accessing a report or dashboard. In SharePoint Server 2013, you can use this property in conjunction with Excel Services or PerformancePoint Services to pass the identity of the user who is viewing the report or dashboard to SQL Server Analysis Services. This allows per-user identity without the need to configure Kerberos delegation.

Using the EffectiveUserName feature with Excel Services requires the following:

  • The Excel Services application pool account must be an Analysis Services Administrator.

  • You must enable the EffectiveUserName option in Excel Services Global Settings.

  • You must select the Use the authenticated user’s account option in the Excel Services Authentication Settings in Excel.

Use the following procedure to enable the EffectiveUserName feature in Excel Services.

To enable EffectiveUserName in Excel Services
  1. In Central Administration, in the Application Management section, click Manage service applications.

  2. Click the Excel Services service application.

  3. Click Global Settings.

  4. On the Excel Services Application Settings page, in the External Data section, select the Use the EffectiveUserName property check box.

  5. Click OK.

For a more detailed look at using EffectiveUserName in Excel Services, see Use EffectiveUserName with Excel Services (SharePoint Server 2013).

Using the EffectiveUserName feature with PerformancePoint Services requires the following:

  • The PerformancePoint Services application pool account must be an Analysis Services Administrator.

  • You must enable the EffectiveUserName option in PerformancePoint Service Application Settings.

  • You must select the Per-user Identity option when you create the data source in PerformancePoint Dashboard Designer.

NoteNote:
The EffectiveUserName feature does not work in conjunction with Power Pivot data sources.
NoteNote:
If you use a connection string to create the data connection, and the connection string contains an effective user field, the EffectiveUserName feature will override the user-supplied effective user value with the system-supplied value.

Use the following procedure to enable the EffectiveUserName feature in PerformancePoint Services.

To enable EffectiveUserName in PerformancePoint Services
  1. In Central Administration, in the Application Management section, click Manage service applications.

  2. Click the PerformancePoint Services service application.

  3. Click PerformancePoint Service Application Settings.

  4. On the PerformancePoint Service Application Settings page, select the Use the EffectiveUserName connection string property instead of Windows delegation check box.

  5. Click OK.

For a more detailed look at using EffectiveUserName in PerformancePoint Services, see Use EffectiveUserName in PerformancePoint Services (SharePoint Server 2013).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft