Condividi tramite

Create an Analysis Services data connection (PerformancePoint Services)

  • Articolo

 

Si applica a: SharePoint Server 2010 Enterprise

Ultima modifica dell'argomento: 2017-01-18

In PerformancePoint Services, the security settings for data sources are stored in each data source. For Analysis Services, you have the choice of having all users connect by using the Unattended Service Account, the Unattended User Account and add authenticated user in connection string, or you can authenticate using Per-User Identity. Per-User Identity requires Kerberos protocol.

Importante

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 2010 farm. If external data sources do not reside within the same domain, authentication to the external data sources will fail. For more information, see Considerazioni per la pianificazione dei servizi che accedono a origini dati esterne.

Create an Analysis Services data source

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

Suggerimento

It is recommended 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 by 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.