Specifying Database Information for Extended Analytics

The Extended Analytics feature enables you to use Essbase to analyze data and produce reports. You use a data source name (DSN) to specify the relational database destination for Extended Analytics. You must specify the data source name and path. You can add, remove, or modify data source names as needed.

Note:

This tab is only available if you installed the Financial Management Server components during the installation process.

Note:

When you use multiple servers with the Extended Analytics feature, you must enable multiple server support on each application server, and you must set up each application server so that these elements are the same on all servers: Clock setting, Data source, and UDL file.

For information on using Extended Analytics, see Using Extended Analytics.

  To add a data source name:

  1. From the Financial Management Configuration Utility, select the Extended Analytics DSNs tab.

    Note:

    This tab is available only if you installed the Financial Management Server components during the installation process.

  2. Click Add DSN.

  3. In DSN Name, enter the data source name.

  4. In DSN Path, enter or browse for the data source path.

  5. Optional: To specify the database tablespaces in which the Financial Management data tables and indexes are created:

    1. Click Browse button (next to the Data Tablespace field), and select the data table location.

    2. Click OK.

    3. Click Browse button (next to the Index Tablespace field), and select the index location.

      Note:

      For Oracle and IBM DB2 SMS, you can specify only a data tablespace; index tablespaces are not used.

    4. Click OK.

  6. Click OK.

  To modify a data source name:

  1. From the Financial Management Configuration Utility, select Extended Analytics DSNs.

  2. In DSN Info, select the DSN.

  3. Click Modify DSN and change the name.

  4. Click OK.

  To remove a data source name:

  1. From the Financial Management Configuration Utility, select Extended Analytics DSNs.

  2. In DSN Info, select the DSN.

  3. Click Remove DSN and click OK.