6 Replies Latest reply on May 14, 2015 5:59 AM by airwolf86

    How to pass the value of a column to a variable to be used in another analysis



      I am on OBIEE


      I have the following issue.

      I have an analysis called OVERDRAFT. It has just one column with the result. Simple. Let's assume the answer is 2500


      I have another analysis which has two more columns, namely GOLD and LOANS. I want to calculate the total of OVERDRAFT + GOLD + LOANS.


      Hence i need to pass the value of 2500 from the first analysis to the second analysis through a variable.


      I cannot add all three of them in the same analysis as there are different filters for OVERDRAFT, and applying those filters on the GOLD and LOANS doesn't give the desired output. I tried to add filters within the column of the overdraft, but that didn't seem to work.


      Any help will be greatly appreciated.