After a very long time, its time for me to post something which i thought would be useful to the OBIEE world.
Our stakeholders, wanted to see the data to be seen incremental after every quarter.
for ex-
13Q2 = 1000
13Q3 = 1000 + 2000
13Q4 = 1000 + 2000 + 3000
and so on...
I built a union report to meet the request. And plotted the data into a stacked vertical bar chart.
But remember, my request was to show the report for last 5 quarters (including the current quarter). So you can opt for this option when there are limited set of time dimension values.
Our stakeholders, wanted to see the data to be seen incremental after every quarter.
for ex-
13Q2 = 1000
13Q3 = 1000 + 2000
13Q4 = 1000 + 2000 + 3000
and so on...
I built a union report to meet the request. And plotted the data into a stacked vertical bar chart.
But remember, my request was to show the report for last 5 quarters (including the current quarter). So you can opt for this option when there are limited set of time dimension values.