Question Re: Fill data/zero instead of NULL with a data action - sap analytics cloud in Technology Q&A

Fill data/zero instead of NULL with a data action - sap analytics cloud

Deb_ — Tue, 08 Jun 2021 04:23:17 GMT

Hello

I want to fill a number (usually 0 or 1, in this case zero) in a range of unbooked data.
the script I wrote is'

IF RESULTLOOKUP([d/ACCOUNT] = "QUANTITY")=NULL
THEN
DATA([d/ACCOUNT] ="QUANTITY") = 0 
ENDIF

I have few IFs and Memberset that focus my data action of course, but this part of the formula just don't work.
I tried with "1" it didn't work either

is it possible to fill with a data action a NULL range???

thanks

Deb

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

hartmut_koerner — Tue, 08 Jun 2021 04:50:15 GMT

Hi Deb,

for me it worked with a "1", but not with the "0".

Best regards
Hartmut

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

Deb_ — Tue, 08 Jun 2021 05:50:35 GMT

but I need a zero..... in this case
can you help?

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

hartmut_koerner — Tue, 08 Jun 2021 06:12:08 GMT

Hi Deb,

at least with a workaround: For me, the following worked:

IF RESULTLOOKUP([d/ACCOUNT]="QUANTITY")= NULL THEN
  DATA([d/ACCOUNT]="QUANTITY") = 1 
  DATA([d/ACCOUNT]="QUANTITY") = RESULTLOOKUP([d/ACCOUNT]="QUANTITY") * 0 
ENDIF

Best regards
Hartmut

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

Deb_ — Tue, 08 Jun 2021 06:40:43 GMT

I'm gonna try and come back to you - thanks!

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

hartmut_koerner — Tue, 08 Jun 2021 08:51:07 GMT

Hi Deb,

in the meantime I have find out that this works as designed. Assigning 0 only works for booked data, not for unbooked.
There is a special handling for "0" in order to prevent the unnecessary creation of 0-records.

A simpler workaround might be the following, please try it out:

INTEGER @ZeroVariable
@ZeroVariable=0

IF RESULTLOOKUP([d/ACCOUNT]="QUANTITY")= NULL THEN
  DATA([d/ACCOUNT]="QUANTITY") = @ZeroVariable 
ENDIF

Best regards
Hartmut

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

Deb_ — Tue, 08 Jun 2021 08:53:41 GMT

Hey Hartmut
I've tried it on one item only, the DA works very slow, but it seems to work
thank you very much!!!!
you saved me 🙂
I'm taking it from here

have a nice day!

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

JefB — Tue, 08 Jun 2021 19:20:19 GMT

Might be more performant to use

MEMBERSET [d/ACCOUNT]="QUANTITY"
DATA.APPEND()=.00

Or perhaps you can set this config keyword to let RESULTLOOKUP() statements return zero values.

CONFIG.GENERATE_UNBOOKED_DATA = ON

Re: Fill data/zero instead of NULL with a data action - sap analytics cloud

former_member341535 — Mon, 14 Jun 2021 12:54:18 GMT

Hi,

Try

DATA([d/ACCOUNT] ="QUANTITY") = 1-1

For some reason we can't book 0 directly...