Null Handling in SAP Analytics Cloud with Live Connection

[former_member796277]

Hi SAP Community,

We access our HANA Cloud using a live connection/model from SAP Analytics Cloud. In Business Application Studio we build the required data models.

We want all null values of a column to be translated to e.g. not defined. We have already tried different approaches for this:

Initial situation:

Our first approach was to calculate a new field in SAC that works with ISNULL(). We also tried with = "NULL" in all variations.

In the second attempt we activated the null handling in the semantic settings of the view (i.e. in BAS) and then calculated the same field, only this time with ="".

In the last attempt, we introduced a default value in addition to the null handling, which replaces all nulls.

Unfortunately, all these approaches do not lead to the desired result. The output is unfortunately always the same:

Can someone please help us?

Many thanks and best regards,

Benedikt

[former_member841886]

Hi Benedikt

I have the same issue to handle Null. Do you get a solution now?

Kind regards,

Yaxi

[avsalynin]

benedik_lueth

try in your formula after the ISNULL([d/"MISSION_OVERVIEW":Difficulty].) put a dot and ctrl+space and select ID or Description in list.

Or do you get nothing or the same?

[former_member796277]

Hi Aleksey,

thank you very much for the answer! I think I do not understand you correctly. I should make a dot after the IFNULL(...) and then press CTRL+SPACE, correct? In this case I don't get any ID or Description suggested:

[avsalynin]

benedik_lueth

dot after *_RATING].

not after ")"

[former_member796277]

In this case, I also get no ID or description suggested. Only what can be seen on the screenshot. When I select this suggestion, however, "(Null)" is still displayed instead of "Not defined".