My Oracle Support Banner

Question About Dim_w_mcal_day_d_fiscal_day.Row_wid = Fact_w_gl_other_f.Acct_period_end_dt_wid (Doc ID 1426494.1)

Last updated on OCTOBER 01, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.2 [AA 1830] and later
Information in this document applies to any platform.

Goal


The Out of the box .rpd has this join:

Dim_W_MCAL_DAY_D_Fiscal_Day.ROW_WID = Fact_W_GL_OTHER_F.ACCT_PERIOD_END_DT_WID.

what is the design intent for this if there are implications for changing this join to Posted on Date. All other Fact tables joined to Dim_W_MCAL_DAY_D_Fiscal_Day use a transaction day type of join. It is only W_GL_OTHER_F that uses the ACCT_PERIOD_END_DT_WID.


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


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