Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & 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