在 SharePoint Server 中使用 Analysis Services EffectiveUserNameUse Analysis Services EffectiveUserName in SharePoint Server

摘要:使用 Analysis Services 資料來源中的 Excel Services 或每個使用者驗證的 PerformancePoint Services 的 EffectiveUserName 選項。Summary: Use the EffectiveUserName option in Excel Services or PerformancePoint Services for per-user authentication with Analysis Services data sources.

EffectiveUserName 是 SQL Server Analysis Services 連線字串屬性包含存取報告或儀表板之使用者的名稱。在 SharePoint Server 中可用於這個屬性一起使用與 Excel Services 或 PerformancePoint Services 檢視報告或儀表板以 SQL Server Analysis Services 之使用者的 identity 傳遞。這可讓個別使用者 identity 而不需要設定 Kerberos 委派。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, 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.

啟用 SharePoint Server 2013 中的 Excel Services 的 EffectiveUserNameEnable EffectiveUserName in Excel Services in SharePoint Server 2013

使用 Excel Services 的 EffectiveUserName 功能需要下列各項:Using the EffectiveUserName feature with Excel Services requires the following:

  • Excel Services 應用程式集區帳戶必須是 Analysis Services 管理員。The Excel Services application pool account must be an Analysis Services Administrator.

  • 您必須啟用 Excel Services 通用設定的 EffectiveUserName 選項。You must enable the EffectiveUserName option in Excel Services Global Settings.

  • 您必須在 Excel 中的 Excel Services 驗證設定選取 [使用驗證的使用者帳戶] 選項。You must select the Use the authenticated user's account option in the Excel Services Authentication Settings in Excel.

使用下列程序來啟用 Excel Services 的 EffectiveUserName 功能。Use the following procedure to enable the EffectiveUserName feature in Excel Services.

若要啟用 Excel Services 的 EffectiveUserNameTo enable EffectiveUserName in Excel Services

  1. 在管理中心中,按一下 [應用程式管理] 區段的 [管理服務應用程式]。In Central Administration, in the Application Management section, click Manage service applications.

  2. 按一下 [Excel Services] 服務應用程式。Click the Excel Services service application.

  3. 按一下 [通用設定Click Global Settings.

  4. 在 [Excel Services 應用程式設定] 頁面上,[外部資料] 區段中選取 [使用 EffectiveUserName 屬性] 核取方塊。On the Excel Services Application Settings page, in the External Data section, select the Use the EffectiveUserName property check box.

  5. 按一下 [ OK ]。Click OK.

如需更多詳細深入了解 Excel Services 中使用 EffectiveUserName,請參閱 < Use EffectiveUserName with Excel Services (SharePoint Server 2013)For a more detailed look at using EffectiveUserName in Excel Services, see Use EffectiveUserName with Excel Services (SharePoint Server 2013).

啟用 PerformancePoint Services 的 EffectiveUserNameEnable EffectiveUserName in PerformancePoint Services

使用 PerformancePoint Services 的 EffectiveUserName 功能需要下列各項:Using the EffectiveUserName feature with PerformancePoint Services requires the following:

  • PerformancePoint Services 應用程式集區帳戶必須是 Analysis Services 管理員。The PerformancePoint Services application pool account must be an Analysis Services Administrator.

  • 您必須啟用 PerformancePoint Service 應用程式設定的 EffectiveUserName 選項。You must enable the EffectiveUserName option in PerformancePoint Service Application Settings.

  • 您必須在 PerformancePoint 儀表板設計工具中建立的資料來源時選取 [每個使用者身分識別] 選項。You must select the Per-user Identity option when you create the data source in PerformancePoint Dashboard Designer.

注意

EffectiveUserName 功能無法與 Power Pivot 資料來源搭配運作。The EffectiveUserName feature does not work in conjunction with Power Pivot data sources.

注意

若使用連接字串建立資料連線,且連接字串包含有效的使用者欄位,則 EffectiveUserName 功能將以系統提供值覆寫使用者提供的有效使用者值。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.

使用下列程序來啟用 PerformancePoint Services 的 EffectiveUserName 功能。Use the following procedure to enable the EffectiveUserName feature in PerformancePoint Services.

若要啟用 PerformancePoint Services 的 EffectiveUserNameTo enable EffectiveUserName in PerformancePoint Services

  1. 在管理中心中,按一下 [應用程式管理] 區段的 [管理服務應用程式]。In Central Administration, in the Application Management section, click Manage service applications.

  2. 按一下 [PerformancePoint Services 服務應用程式。Click the PerformancePoint Services service application.

  3. 按一下 [ PerformancePoint Service 應用程式設定]。Click PerformancePoint Service Application Settings.

  4. 在 [PerformancePoint Service 應用程式設定] 頁面上選取 [使用 EffectiveUserName 連線字串屬性,而不是 Windows 委派] 核取方塊。On the PerformancePoint Service Application Settings page, select the Use the EffectiveUserName connection string property instead of Windows delegation check box.

  5. 按一下 [ OK ]。Click OK.

如需更多詳細深入了解 PerformancePoint Services 中使用 EffectiveUserName,請參閱 < Use EffectiveUserName in PerformancePoint ServicesFor a more detailed look at using EffectiveUserName in PerformancePoint Services, see Use EffectiveUserName in PerformancePoint Services.