Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smart View “No Data / Missing” Option Suppressing Zeroes

edited Nov 13, 2019 9:20PM in Planning 9 comments

Summary

The latest Windows version of Smart View incorrectly suppresses zeroes when “No Data / Missing” suppression is selected in the Smart View Data Options

Content

It appears that as of the May 2019 update (Version 11.1.2.5.900 Build 093), users can no longer leverage the “No Data / Missing” suppression options, instead they must use the “Suppress Missing Blocks” option when running Ad Hoc Analysis reports via the Smart View for Office Add-In (Microsoft Excel for Office 365 MSO, 64-bit) in order to suppress rows or columns that do not have data while retaining any rows or columns that have a zero value.

Has anyone else noticed this odd behaviour? If so, have you filed an SR with Oracle reporting the bug?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!