Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 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
Divide 2 Columns in Union Report
Answers
-
Issue resolved by using SUM BY in result column. Thanks everyone.
0 -
And THAT is why you normally do things in the model and not with UNIONs. Unions should be the very last option you ever choose. OBI tries to aggregate according to models and when you override this - by unions for example - then this becomes dodgy and you need to write the SUM or AGGREGATE yourself.
0 -
Completely Agree Christian. This analysis pulls data with different filter on each union query and therefore it was not possible to fit in a single model.
0 -
Ebin Cherian wrote:This analysis pulls data with different filter on each union query
Bummer
0
