Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 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
Exclude null rows when "Show Total value for all measures on unrelated dimensions" is selected
Dimitris Karydis
Rank 4 - Community Specialist
Hi,
I have created an analysis in OBIEE 12c with a pivot table using the feature " in the Advanced tab.
Unfortunately, when I have this option checked, rows with null values are being included in the table even if I don't have the "include null values" option enabled in the table settings. When I un-check " , rows are excluded again fine.
Is there any way that I can make both these features work at the same time?
Thanks
0
Answers
-
No what you're asking for is mutually exclusive.
This
Becoming this
Is how it works. Because it basically creates a cartesian product.
0 -
Thanks a lot for the answer!
0 -
Your welcome. Always easy when I can just copy+paste from my own presentations
0