Hi all,
ive a cross-tab with the measures on the rows and a dimension in the columns with 3 values.
what i need is to store just the 3rd value of one measure in a data item so i can put it in a chart?
how can i store this?
would i be able to do this using a simple case?
please help!!
Thanks in advance.
Hi,
Is your package a relational or a dimensional one? If it's a dimensional package, then a query calculation using a tuple() function would be the way to go.
For a relational package, either a case or if-then-else may suffice, or alternatively an extra query filtered on the third value and joined back to the main query.
Regards,
MF.