Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Suppress measure against dimensions in analysis

Hi,
I want to make a report listing vehicles and salary of vehicles.
When i add Agent Name, Vehicle Name, and Salary, it repeats salary against vehicles as one agent has more than vehicles.
You can see the total is also incorrect.
How can i get following output?
Thanks.
Answers
-
Not sure this is even conceptually possible since "value suppression" means dimensional attribute value suppression and not measure suppression. It's a level-based measure in your case and will always be repeated. Because it's a measure.
0 -
What you are struggling with is 'query grain' ... really to show the correct information is to split out the agent from the vehicle (via the method @Christian Berg has mentioned):
Agent Name | level based measure at Agent | Vehicle | base measure
-----------------------------------------------------------------------------------------------------------------
Agent 1 5000 Honda 1500
Agent 1 5000 Toyota 3500
-----------------------------------------------------------------------------------------------------------------
Agent 2 15000 Suzuki 500
Agent 2 15000 Audi 10500
Agent 2 15000 Nissan 4000
-----------------------------------------------------------------------------------------------------------------
TOTAL 20000 20000
With the proper logical constructs you can then have a master-detail table; master shows the agent and total; click the agent and detail shows you the vehicles and their contribution to total.
0 -
I understand that it was a wishful thinking but it was a requirement. I've handled this at DB end. Thank you for your valuable input.
Regards,
ARK
0 -
A requirement is an agreed upon item to be worked ... when an ask isn't inline with functionality of the tool it should ever become a requirement.
0 -
I agree. Thank you very much for your help.
Regards,
ARK
0