Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one table called fact_budget and I link it to link table but entire data will come but when i select year then data not associate with budget table.
I think i haven't done link properly can anyone help me out.
I want Fact_Budget table will associate with all entire data model.
Please help.
Thanks
Hi,
Your master calendar and link table are connected using Posting date. But there is no association between posting date and %BudgetKey to link it to FACT_Budget.. So your selection is not associated with FACT_Budget table. If u can then add Posting date to key as well.
Thanks,
Partha K
Hi,
Try by creating Composite Keys.
Although they have the same name the combined fields are not the same so the new Key field has different values
LinkTable
AUTONUMBER(date([Posting Date],'DD/MM/YYYY') & '_' & BusSeg_Code & '_' & AccLoc_Code & '_' &Null()) AS %BudgetKey,
Fact_Budget
AUTONUMBER(date([Posting Date],'DD/MM/YYYY') & '_' & BusSeg_Code & '_' & AccLoc_Code & '_' & [Document No_]) AS %BudgetKey,
Hi,
I could observe that your master calendar is not linked to FACT_GL_Entry or value_entry.. I doubt on the key formation and its respective association.
Thanks,
Partha K
Hi Robert / Pertha,
Thanks for quick response.
I have corrected that all you said and add one more fact_budget table into linktable tab but i am getting synthetic table and my budget table is directly link to master calendar.
PFA
Hi,
My replies are getting moderated. If u can then can u share sample data of three tables? Your year is still not associated with FACT_GL_Entry,Value Entry and Budget. If u share sample data then can try it.
Thanks,
Partha K
Hi,
I guess by mistake you have given wrong fact_budget qvd. Its similar to that of FACT_GL_Entry.
Partha K