Skip to Content

Analysis for Excel 2.3 - blank/null handling

Oct 20, 2016 at 12:29 PM


avatar image

Hi Team,

We are getting a issue while handling Null/Blank values in Analysis office 2.3.

When a Key value has Null - its displaying as # and the text is displayed as "NOT_ASSIGNED"

When a key value has Blank - its displayed as ##.

Screen shot from AO 2.3

Screen shot from HANA View

Is there a way we can suppress?

chigo.png (1.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Carlos Ayuso Feb 07, 2017 at 09:42 AM


I know this topic is a bit aged, but I would like to continue this thread because I am facing a similar issue.

In the Bex version of planning I could paste a complete line, once the date was saved all empty characteristics were shown with a "#".

However in the Analysis Office side, when I create a new member I am forced to put manually the "#" in those cells I don't have a default value. Did anybody struggled with this issue. For a single line there is Ok, but when the user needs to created several lines is a pain. I could build a kind of VBA code to complete this information, but I would preffer this option as final scenario.

Thanks in advance.

captura.png (8.3 kB)
10 |10000 characters needed characters left characters exceeded