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