Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 21 Oracle Analytics Lounge
- 252 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 93 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Hierachical Level Measures
iam_saroj
Rank 1 - Community Starter
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
0
Answers
-
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.
0 -
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
0