Where Are the Seeded Data Transformation (DT) to Populate the DIM_DATE Table (Doc ID 2139243.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics

Goal

From the Oracle Financial Services Data Model Utilities User Guide Release 8 Part No. E57634-01 on the Oracle Technical Network:

In page number 4-106, “Dim Dates Population DIM_DATES_POPULATION is a seeded Data Transformation which is installed as part of the OFSAA BI applications installers.
Time dimension population transformation is used to populate the dim_dates table with values between two dates specified by the user.”

It says that a seeded data transformation that comes as part of OFSAA BI applications will populate dim_dates table.  If not using OFSAA BI installer (eg. using Microsoft BI), please provide seeded Data Transformation (DT) will populate dim_dates table.

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