Skip to Content
0

Analysis for Excel 2.3 - blank/null handling

Oct 20, 2016 at 12:29 PM

406

avatar image
Former Member

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

avatar image
Former Member Feb 07, 2017 at 09:42 AM
0

Hi,

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)
Share
10 |10000 characters needed characters left characters exceeded