Sap analytics cloud - deleting version data using data action

[Eliram_Lugassi]

hi all,

i need to allow my planning users to delete records from the planning budget version, this sometimes a neccessity because the budget changes and new budget is being uploaded,

i created a data action using the advanced forumla editor and i came across a problem, i'm unable to select a version to run this data action on, it's not even showing in the filters on the visual editor. What can i do? 

[N1kh1l]

@Eliram_Lugassi 

First all of do not use DATA()=0 for deletion, This can lead to significant explosion in 0 records and will affect your performance going forward.

If the purpose is to delete the records in Data Action advanced formula, Put the filters using MEMBERSET and then finally use DELETE() statement.

Now coming to the version part. You do not have to scope the version in DA formula as every DA advanced formula has an implicit TargetVersion parameter. So just scope other dimensions and version will be automatically asked when you run any DA. You can select the version for which you want to delete during execution of the DA.

Hope this helps !!

Nikhil

[Eliram_Lugassi]

thank you, i wasn't sure about TargetVersion.

i changed it to DELETE()

[N1kh1l]

@Eliram_Lugassi , I hope it worked for you. Please close the thread if the solution worked.