ESSBASE: Report Script in 11.1.2.4 Returns Incorrect Output When Using Two Sequential Double-Quotes in {MISSINGTEXT ""} (Doc ID 2162093.1)

Last updated on AUGUST 08, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.2.100 and later
Information in this document applies to any platform.

Symptoms

Using a report script to extract data, if the report script uses the {MISSINGTEXT ""} command to replace #MISSING with a blank space, instead of a space, it returns OUTMBRNAMES.  For example, using  the following Report Script:

 

In 11.1.2.0, the above report script returns a blank space if there is no data in data columns:

Jul_Forecast    Customer    Co 11    Account    SBU 106    B 111    Apr    R000     99.99   [blank space]
Jul_Forecast    Customer    Co 11    Account    SBU 106    B 111    May    R000    99.99  [blank space]


In 11.1.2.4 it is showing as OUTMBRNAMES instead of a blank space when returning #Missing data.

Jul_Forecast    Customer    Co 11    Account    SBU 106    B 111    Apr    R000    99.99     OUTMBRNAMES
Jul_Forecast    Customer    Co 11    Account    SBU 106    B 111    May    R000    99.99     OUTMBRNAMES

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms