Exclude null rows when "Show Total value for all measures on unrelated dimensions" is selected

Question

Hi,

I have created an analysis in OBIEE 12c with a pivot table using the feature " Show Total value for all measures on unrelated dimensions" 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 " Show Total value for all measures on unrelated dimensions" , rows are excluded again fine.

Is there any way that I can make both these features work at the same time?

Thanks

[Deleted User] · Answer

Your welcome. Always easy when I can just copy+paste from my own presentations

Dimitris Karydis · Answer

Thanks a lot for the answer!

[Deleted User] · Answer

No what you're asking for is mutually exclusive.

This

Becoming this

Is how it works. Because it basically creates a cartesian product.