My Oracle Support Banner

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

Last updated on JANUARY 28, 2020

Applies to:

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

Purpose

This document provides some general information regarding Hyperion Financial Management (HFM) Extended Analytics module for versions 9.3.1 through 11.1.1.3. 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.

Scope

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:

http://download.oracle.com/docs/cd/E10530_01/doc/epm.931/hfm_admin.pdf 

http://download.oracle.com/docs/cd/E12825_01/epm.111/hfm_admin.pdf

 

Details

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
Purpose
Scope
Details

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