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

Oracle Analytics Cloud and Server

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

Received Response
71
Views
3
Comments
Dimitris Karydis
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

Answers