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
Exclude null rows when "Show Total value for all measures on unrelated dimensions" is selected

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
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