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
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