We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

#missing appearing in report even though data replacement is #NumericZero

Received Response
9
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

#missing appearing in report even though data replacement is #NumericZero

Content

Hi,

we are using smart view version 710.  Our users recently notice something with the function report when refresh.

Even though they have selected smart view options > Data options > Replacement > @NoData/Missing label as #Numericzero, upon the first refresh of the report, #missing will still appear.  They need to refresh a second time again to get back 0 instead of #missing.  If they open the file for a while like 15 min long, #missing will pop up again and they need to refresh the report all over again.

Does anyone know how to get around this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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