Hierachical Level Measures

Question

Hello All,

We have one hierarchy with levels :- OPTY(Higher) and ITEM(Lower).

Customer wants to display the measure "Quantity", where in OPTY level we need to display Max(Quantity) and in Item level we need to show Sum(Quantity).

So how will we proceed with that. Please guide me.

Thanks

Saroj

Martin van Donselaar · Answer

You can use Aggregation based on Dimensions:

Aggregation Based on Dimensions - ClearPeaks Blog ClearPeaks Blog http://www.wegobeyond.co.uk/blog/entry/aggregation-based-on-dimensions-in-obiee.html

Robert Angel · Answer

Not sure if we are talking about Essbase or relational, presuming the latter.

Copy your existing Fact measure in the rpd.

Paste the copy onto the appropriate level of the hierarchy. Set the aggregation rule. Rename as appropriate.