My Oracle Support Banner

Extended Analytics Setup, General Information and Troubleshooting Ideas (Doc ID 1073295.1)

Last updated on APRIL 09, 2023

Applies to:

Hyperion Financial Management - Version to [Release 9.3 to 11.1]
Information in this document applies to any platform.
checked 2-15-2016


This document provides some general information regarding Hyperion Financial Management (HFM) Extended Analytics module for versions 9.3.1 through Applicable notes and screenshots will be provided if there are any differences between the two releases. It will also provide a list of items that you can check if you encounter any issues when using Extended Analytics.


Extended Analytics (EA) allows you to export HFM data and metadata into a relational database in a star schema format. A data source name (DSN) is used to specify the relational database destination that will be used to export the data using EA. The DSN is created in the Configuration Utility. When setting up the DSN, please be advised that you should not use the same relational database and UDL file for Extended Analytics that you use for your Financial Management applications. They should be kept separate. To store star schemas in multiple databases you can create a DSN for each database. Different formats and schemas are used to export the data. The schema tables begin with a prefix that you specify.

Extended Analytics gives you more flexibility with data extracts because it allows you to extract data for any Value dimension member, export data for parent accounts, and select any custom members to be included in the extract. Based on the POV that you select, these extracts are then exported into the relational database where reports and queries can be run to review the information.

Extended Analytics is accessed from HFM web via Administration>Extended Analytics. The default page of EA contains the following information:

There are 3 schema options that you can select when exporting the data

There are different types of Star Schema Formats:

For each schema format, the system creates a <PREFIX>_FACT table that contains keys to the 13 dimension tables and one data field. The system also creates <PREFIX>_DIMENSION tables, an HFM_EA_EXTRACT table to track extract timestamps for metadata, and a <PREFIX>_LOCK_ACCESS table to track writer and reader locks. Depending on the schema you selected, some or all of the tables may not always be updated.

Please refer to the HFM Admin guide regarding detailed instructions on setting up and using Extended Analytics. The chapter is called, "Using Extended Analytics." The links for 931 and 11 are located below:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.