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 22.214.171.124 [AA 1830] and later
Information in this document applies to any platform.
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.
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