This content has been marked as final. Show 3 replies
I m stuck in one scenario please help me out !
I have one fact table one budget table and one actual table.Budget is changing for every financial year but actual will remain same.Now i have to link my fact to these table as such I get the union result of both actual and budget table and budget should be change accordingly as per the financial year.
Note : I can't concate my fact with these two table i only can link by the composite key which is
org_Id&Item_code&F.Y (Key between fact and budget)
ord_Id_Item_Code&Component_Item (Key between actual and budget)
Any kind of help is appreciated.
Thanks in advance