Data Options Supported for Essbase Ad Hoc

Table 26. Data Options Supported for Essbase Ad Hoc

OptionAd hoc
No Data/MissingYes
ZeroYes
No AccessNo
InvalidNo
Underscore CharactersNo
Repeated MembersYes
No Data / MissingNo
ZeroNo
No AccessNo
#NoData/Missing Label - #MissingNo
#NoData/Missing Label - #NumericZeroNo
#NoAccess Label - #No AccessNo
#NoAccess Label - #NumericZeroNo
#Invalid/Meaningless -#InvalidNo
#Invalid/Meaningless - #NumericZeroNo
Submit ZeroYes
Display Invalid DataNo
Enable Essbase Format StringYes
Cell DisplayNo
Navigate Without DataYes
Suppress Missing blocksNo