I have 3 metrics and 1 dimension:
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.
if I do as you told me I get this:
_________________|_________ X _______|_________ X _______|
Metric A label_______|____Metric A value___|____Metric A value___|
Metric B label_______|____Metric B value___|____Metric B value___|
Metric C label_______|____Metric C value___|____Metric C value___|
Is not the same thing.