Question About Use of STG_BANDS_MASTER and DIM_BANDS Tables in OFSAA 8.0.5 Model

(Doc ID 2333488.1)

Last updated on DECEMBER 11, 2017

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Data Foundation (FSDF)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

Question 1: The table STG_BANDS_MASTER, which was previously used for feeding DIM_BANDS dimension and existed in the 7.3.5 version model, no longer exists in 8.0.5 version.
Has the table been removed in 8.0.5? If yes, why and what is the suggested procedure for DIM_BANDS loading?
 
Question 2: Would like to load DIM_BANDS from the external dictionary.
In order to stay aligned with OFSAA DIM management principles, should STG_BANDS_(B, _HIE, _TL, _ATTR )_INTF tables be created (as they are not existing in the out-of-the-box model), or there is some other recommended method to load DIM_BANDS?

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