Skip to Content
0
Dec 19, 2022 at 02:41 PM

SAC DataAction how to delete model data via range date as one parameter

316 Views

Hello SAC Experts!!

I'm struggling in SAC Data Action. who yo know how to solution?

want : Delete and insert data in planning model using 2 data actions in multi action .

I consider using "Advanced Formulas Step" in delete step.

"MEBMER SET" and "DELETE([DATE] = ####)" couldn't accept range parameter.

therefore now i use MEMBER SET %"parameter1"% to %"parameter2"%.

then next use action copy step for insert data.

copy step accept range parameter for DATE.

So now when using multi action (with above2 data action) i have to input total 3 parameters.

it could be less to 1 parameter?


thanks so much your reading and warm assist!!