Wednesday, April 24, 2013

OBIEE creating variances the easy way using $ sign



CREATE VARIANCES THE EASY WAY

Create a table or Pivot table

A way to do this dynamically, without hard coding the years seem to be possible by using $1-$2.
Use $x to reference the columns where x=1,2,3…etc.
This will avoid you to re-write these reports, which is what happens when values are hardcoded