Export (0) Print
Expand All

Create a connection from Dashboard Designer to an Analysis Services data cube by using PerformancePoint Services

 

Applies to: SharePoint Server 2013

Topic Last Modified: 2013-12-18

Summary: Learn how to set up a data connection from Dashboard Designer to an Analysis Services data cube.

In PerformancePoint Services, the security settings for data sources are stored in each data source. For Analysis Services, you have the choice of three authentication options: using the Unattended Service Account, using credentials stored in a Secure Store target application, using Per-User Identity (which requires either the Kerberos protocol or setting the EffectiveUserName property in PerformancePoint Application Settings in Central Administration.)

NoteNote:
PerformancePoint Services accesses external data sources by using a delegated Windows identity. Consequently, external data sources must reside within the same domain as the SharePoint Server 2013 farm. If external data sources do not reside within the same domain, authentication to the external data sources fails. For more information, see Planning considerations for services that access external data sources.

Create an Analysis Services data source either by entering the name of the Analysis Services server, database, and cube name, or by typing a connection string and the cube name in Dashboard Designer.

TipTip:
We recommend that you select your authentication method before you specify your server connection.
To Create an Analysis Services data source
  1. Click the Create tab, and then click Data Source.

  2. In the Category pane of the Select a Data Source Template dialog box, click Multidimensional and then click Analysis Services. Click OK.

  3. In the left navigation pane (workspace browser), type the name of your data source.

  4. In the Data Source Settings section, select the method by which to authenticate to the data source.

  5. In the Formatting Dimension drop-down list, select desired dimension formatting needed for the report.

  6. In the Cache Lifetime drop-down box, type the refresh rate (in minutes) for the cache. Data from this data source will update at this interval.

  7. In the center pane, click the Editor tab. In the Connection Settings section, select the method by which to connect to the data source.

    To use a standard connection:

    1. Select Use standard connection

    2. Type the full path for the server to which you want to connect. This populates the options in the database list.

    3. In the Database box, select a database name.

    4. (Optional) In the Roles box, type the name of the role, such as an administrator or database role. To specify multiple roles, type the names of the roles and separate them with commas.

    To use a specific connection string:

    1. Select Use the following connection.

    2. Type the connection string to the server, including the cube name to which you want to connect.

    3. From the Cube drop-down list, select the specific cube that you want to use as the data source in the database.

  8. Click Test Connection to confirm that the connection is configured correctly.

  9. From the Data Source Settings box, select one of the following Authentication methods:

    • Unattended Service Account   If you select this method, all users connect by using the Unattended Service Account that was defined for the PerformancePoint shared service when they access the data source.

    • Use a stored account   Enter the Application ID of a secure store target application. If you select this method, all users connect by using the credentials from the specified Secure Store target application when they access the data source.

    • Per-user identity   If you select this option, the current user's identity is used to access the data source. Per-User Identity requires either the Kerberos protocol or setting the EffectiveUserName property in PerformancePoint Application Settings in Central Administration.

  10. Click Test Data Source to confirm your connection is configured correctly.

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