3 Replies Latest reply: Apr 18, 2013 12:48 PM by JasonBaer RSS

    Transpose columns in OBIEE

    FF
      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