SAC Planning Data actions Advanced formulas not working anymore

[Christian_Szabo]

Hello SAP Community,

4 to 5 months ago I created some data actions with advanced formulas and currently none of them works anymore. It seems like it is not possible to change any data within planning versions of a model with any data actions (clicking on a cell and typing e.g. +10 still works...). I even tried to use some standard data action from the business content which should only clear version data, but even that one did no changes to any planning data except for actuals.

Have there been some changes which I missed to implement? Am I missing something? I already tried to create a new story, new model and new data action but nothing seems to work. There are no errors when validating the formulas. Neither visual or scripts work.

This is for example one sample I tried but did not work (gl account has values in the planning version I executed it)

DATA([d/SAP_FI_BPL_GLACCOUNT] = "1211000") = RESULTLOOKUP([d/SAP_FI_BPL_GLACCOUNT] = "1210000") / 2

Thanks and Regards

Christian

[SeerOfSig]

If I understood you correctly, the data action executes successfully and changes data if run on your Actual version, but not for your planning version?

When you run against the planning version, does the data action fail with an error? Does it execute successfully but not generate any data? Or does it generate data but the publish action fails? Depending on where the issue is will help determine the likely cause. Have you checked for instance if you have enabled data locking since the last time you executed the data action? Is it possible that the planning version is locked for data changes or that the user executing the data action does not have write rights on a dimension with Data Access Control enabled?

Remember that the user who created the model and any use with Admin role will be able to write data regardless of data locking or data access control rights, but other users will be impacted by rights, so the issue could be with missing rights on the planning version.

[Christian_Szabo]

Hi,

I just tried some other data action and they do not work with actual or planning version. It was just a by sap delivered data action with the delete() formula which was able to delete data from the actual version but not the planning version.

So the problem is -> It does execute successfully but does not generate any data

The data action does not fail with an error, just says "The data action 'Test' finished running on 'FIPLNS'. " There are no changes shown in the data. I can see a * next to the column where the name of the version is shown, so it seems like there should be some changes, but no fields are yellow highlighted as if I were making changes by hand.

There is no fail with publishing it, there are no data locks or data access control active and I have all admin priviliges on the SAC as well as created all the stories and models.

[SeerOfSig]

Based on your last update, I cannot suggest why they are not working at this time. There was a Quarterly release update a few weeks ago, but I am not aware of any substantial changes to the Data Action or advanced scripting and have not heard of any generalized issues with data actions at other customers.

I think you will have to create a support incident with SAP so that we can investigate your issues directly.

Regards,

Peter