Analysis for Office: Changing text of # "Not assigned" to SPACE

[yj]

Hello,

I have an issue in Analysis for Office: The text of a member is shown as "#" although I defined the text in the master data of the infoobject with a blank value.
This is how it looks in AO with setting "show key and text":

And this is how it is defined in the infoobject:

In BEx Analyzer a blank text is shown, but in AO the text "#" is shown. What can I do to get no text in my crosstab?

Thanks in advance.

Regards,
Yvonne

[yj]

Therefore it is not possible to get the following in AO (showing key in the first column, text in the second column)?

As mentioned, the text of the master data for # is maintained with SPACE.

Regards,
Yvonne

[yj]

With the RSADMIN parameter BICS_INFOOBJECT_TEXT_DISPLAY it was able to change the behaviour. Now no text is shown.

[sgassem]

In AfO, # means no text or text field in blank.

If you need to show “no text” rather than a #, you meed to populate the master data with “no text.”