How To Create A View For Extended Analytics (EA) Fact Table To Get Actual Member Names From Dimension Tables Using Member Indexes (Doc ID 1147815.1)

Last updated on NOVEMBER 22, 2013

Applies to:

Hyperion Financial Management - Version 9.3.1.0.00 to 11.1.2.0.00 [Release 9.3 to 11.1]
Information in this document applies to any platform.

Goal

Extended Analytic (EA) "FACT" table will have the indexes of dimensions members and the data after creating star schema in Hyperion Financial Management (HFM). How to create a view to get the actual dimension member names with data from the "FACT" table (EA Prefix_Fact) by querying the dimension tables?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms