This discussion is archived
3 Replies Latest reply: Apr 18, 2013 10:48 AM by JasonBaer RSS

Transpose columns in OBIEE

FF Newbie
Currently Being Moderated
Hello All,

I have 3 metrics and 1 dimension:

Metric A
Metric B
Metric C [ = (Metric B / Metric A) * 100 ]
Dimension [value: X, Y]


Is there a way in OBIEE to create the following table:

_________________|_________________ X __________________|___________________ Y ______________|
Metric A label_______|____Metric A value___|_____ null __________|______Metric A value__|______ null ______|
Metric B label_______|____Metric B value___|__Metric C value______|______Metric B value___|__Metric C value__|


If I put the Measure Labels box on the left, also the Measure C is put in row below to Measure A and Measure B.

I should convert a BO report with this structure, but I don't think that it is possible in OBIEE.

Thanks,
Federico

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points