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


The Out of the box .rpd has this join:


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

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