SAP Analytics Cloud for planning- Data Action Script - Write only on booked cells

[guenay]

Hi friends,

I do want to creat a data action which only writes on booked cells. I need this because otherwise the data action won't run because of too many cells.

I tried it with this one:

FOREACH.BOOKED [d/Material_Neu]

DATA([d/DBSCHEMA_COMA] = "COMA122") = 1


ENDFOR

But still it won't work somehow...

Does someone has experience in writing on only booked members?

Kind regards,

Ismail

[dskiendziel]

Hi Ismail,

What is the exact error message you are receiving? Also, are you defining the scope of the DA step with the MEMBERSET? If so, please share.

Dan

[suleirmak · Accepted solution]

Hi İsmail,

After defining memberset which only reads booked members, you can add resultlookup()/resultlookup() as below. With this trick you make a formula as transaction driven.

1*Resultlookup()/ Resultlookup() 

Regards

Sule

[guenay]

Hi friends,

as I tried out further I found out, that because of to many Dimensions the script did not work. After excluding some Dimensions (Instead of a separate Dimensions I used them as Attributes) the script worked fine.

Thanks a lot friends.