About Using Extended Analytics

  To use Extended Analytics:

  1. Optional: Create a reference database.

    See Optional: Creating Reference Databases and Entities.

  2. Create an empty relational database.

  3. Create an Essbase external database connection.Connecting to External Databases.

  4. Configure the external Essbase database (Star Schema). see Creating Extended Analytics .

  5. Define the time periods, accounts, and general information for the export in the Extended Analytics rule set. See Creating Extended Analytics Rule Sets.

  6. Specify the entities to export. See Optional: Creating Reference Databases and Entities.

  7. Optional: Export from the relational database to Essbase.