Using Extended Analytics

In This Section:

Creating a Data Link (UDL) File for Extended Analytics

Extended Analytics Registry Settings

Star Schema

Creating and Exporting Data to a Star Schema

Updating a Star Schema

Deleting a Star Schema

Creating a Star Schema Template

Deleting a Star Schema Template

An Extended Analytics star schema enables you to use Essbase to analyze data and produce reports. To do so, you use the star schema to send data to an Oracle Essbase database.

Note:

You create the database after you export to the star schema. See the Database Administrator’s Guide for your release.

You can also use a star schema with third-party products.

To use the Extended Analytics module, you must set up an OLAP data source name (DSN) for the database that will store star schemas, then configure the DSN with the Financial Management configuration utility. For instructions, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

Note:

To store star schemas in multiple databases, you can create a DSN for each database.

To use Extended Analytics, you must be assigned the security role of Administrator or Extended Analytics.