Defining External Data Sources

Note:

If you are defining a connection to an Essbase database that does not exist on the selected Essbase server, ignore the warning that displays, and select the new application, cube, and alias table.

For information about pointing to an Essbase database in a target environment to which you have promoted, see Chapter 5.

  To define external data sources:

  1. To use anEssbase database as an external source, start the Essbase server before the application server.

  2. In Performance Scorecard, select Administration, and then Data Source List.

    The Data Source List is displayed.

  3. Click Add, or select an existing connection and click Edit.

    The Data Source tab is displayed.

  4. Under Data Source Type Specification, select the data source to use and click Next.

    The General Attributes tab is displayed, showing the Data Source General page.

  5. In Name, enter unique name. This name is used when you select the external data source on the Measure Template Setup page.

  6. In Description, enter a brief explanation of the contents or purpose of this external data source.

  7. In Server, enter the name of the computer that is hosting the server.

  8. In Port, enter the port number of the Essbase server.

  9. In User Name, enter the user ID that is used to log on to the database.

  10. In Password, enter the password used to log on to the database.

  11. In Application, select the Essbase application that contains the multidimensional database.

  12. In Essbase Database, select the database that contains the data to use.

  13. In Alias Table, select the table that contains the alternate names for dimensions, if available. There may be more than one for each database.

  14. Optional: Click Test Connection to ensure that you can connect.

  15. Click Next or select the Measure Dimensions tab, and see Selecting Required Dimensions and Values.