varience

[johny.cbi]

source : Cube, Data Base: Oracle

I've a cross tab, there are couple of measures(Sales, Invoice, Inquiries etc) in the column

and some dimensions in the rows (Fiber glass,wire cloth etc..), beside that there is one more row YTD

under this one more row PYTD and same measures and dimensions


I want to caluclate  YTD dimension  -  PYTD dimesnion  ( Varience)

Thanks for any ideas

[rockytopmark]

Lookup tuple() in the documentation or on-line help.  This is the dimensional function that will allow you to perform your task.

Value(tuple([YTD],[measure])) - Value(tuple([PYTD],[measure]))

where YTD and PYTD are members from the SAME time Hierarchy