Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 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