3 Replies Latest reply: Sep 18, 2017 11:17 AM by Pankaj Thakur RSS

    Union of two fields without concatenation

    sanjay gupta

      Hello all,


      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