table is not link properly

[prma7799]

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

[parthakk]

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

[krishna20]

Hi,

Try by creating Composite Keys.

[robert_mika]

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,

[parthakk]

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

[prma7799]

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

[parthakk]

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

[prma7799]

Hi parthakk‌

PFA...

I am very thankful to you...

[parthakk]

Hi,

I guess by mistake you have given wrong fact_budget qvd. Its similar to that of FACT_GL_Entry.

Partha K