I had a quite challenging requirement from my client. Any inputs would be Appreciable.
There are 8 different reports, The client want to see in a single report or dashboard If the First report Grand total value = Second report grand total , First report Grand total = Third report total, So on to all...... he want to compare all the reports & for some reports he want to apply filters in comparing.
Its like comparing values of different reports in a single report.
I would like to know whether this functionality can be implemented in OBIEE , if so how can this be achieved. Any inputs in this would be Appreciable.
1) Create a report by placing all your dimension columns to exlcude section/remove it -- report 1 to show only grand totals (intermediate report
2) Create another report by placing all your dimension columns to exlcude section/remove it -- report 2 to show only grand totals
-------- (report 3 ,4,5,6 and compare with report 1 column by column )
2.a) open report1(intermediate) first column and Filter-->filter based on another request and equals to 1st colunm of report 2 do the same for all columns
3) Use conditions in dashobard if above intermediate report retrives results (true) then show section or hide it
Thanks for your quick reply,
I am also trying in the same way as you said, where i got stuck is at 2(a) , how to bring values of two different reports in to single report & compare them, it would be helpful if you elaborate the comparison of of two values from different reports.
I used filter based on other analysis. but cannot bring other value in to this report.