My Oracle Support Banner

How to Load a Hierarchy Using Fn_drmDataLoader (Doc ID 1311002.1)

Last updated on AUGUST 15, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

How do you load a new Hierarchy using the OFSAA Hierarchy Loader program fn_drmDataLoader?

Note: You cannot use the Hierarchy Loader to make incremental changes to a Hierarchy.  For more information, see <Document 1475199.1> "Can Fn_drmDataLoader Hierarchy Loader Make Incremental Updates to a Hierarchy?".

Solution

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
Goal
Solution
 Step 1: Populate STG_HIERARCHIES_INTF
 Step 2: Populate the STG_<dimension>_HIER_INTF table with Hierarchy information
 Step 3: Populate STG_<dimension>_B_INTF and STG_<dimension>_TL_INTF
 Step 4: Verify Correct Data Exists in FSI_DIM_LOADER_SETUP_DETAILS
 Step 5: Execute fn_drmDataLoader
 Step 6: Run the Reverse Population program to populate OFSA_IDT_ROLLUP
References

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