My Oracle Support Banner

Question About Use of STG_BANDS_MASTER and DIM_BANDS Tables in OFSAA 8.0.5 Model (Doc ID 2333488.1)

Last updated on FEBRUARY 03, 2019

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

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
References


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