cancel
Showing results for 
Search instead for 
Did you mean: 

Null Handling in SAP Analytics Cloud with Live Connection

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

View Entire Topic
former_member841886
Discoverer

Hi Benedikt

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

Kind regards,

Yaxi