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

[hajime78]

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!!

[William_Yu]

Hi hajime78，

Why don't just put the delete step and insert step into the same data action?

Best regards, William

[hajime78]

Dear William san,

thanks soonest your reply!

which step you means?

1.delete step and insert step in copy step

2.delete step and insert step in Advanced Formulas Step

i don't know how to set option 1. my understanding copy step could update or add.

now i use cross model copy step so if you means option2, need to use link function?

[William_Yu]

Hi hajime78,

I mean you can have at least two steps in one data action. Step 1 to delete with advance formula, Step 2 to insert with copy action step or advance formula. If you use advance formula to insert data of course you may even merge step 1 and 2 into one step.

Either way, I guess you only need one set of date parameter as there is only one data action.

Best regards, William

[hajime78]

Dear William san,

Thanks

sorry I'm still not clear. I'd like to select Date range from to or Hierarchy.

my understanding as below

Formulas Step could accept leaf member therefore need 2 parameters if i need select range date.

Copy Step accept leaf or hierarchy member but it could accept 1 by 1.(dimemtion v.s. parameter)

so conflict between both action.

B.Regards

[William_Yu]

Hi hajime78,

It's depending on how flexible you would like your data action to be and what user would like to choose in parameter. Anyway I think 1 parameter is not enough.

For copy step, user always need to specify 'From' and 'To' for example, from 2022 Q1 to 2023 Q1 . Then you can also use '2023 Q1' to delete data.

It might be easier for you to provide an example.

Best regards, William

[N1kh1l]

hajime78, william.yu

Hello Hajime and William

Both Copy step and Cross Model copy step have a Data Write mode option with 1) Overwrite and 2 ) Append. If the delete step is to just ensure data is being deleted before its copied, will the overwrite option not work ? Unless the deletion context is wider than what's being copied.

Nikhil

[hajime78]

Dear nikhil_1486 san,

thanks your reply.

William san is right.I have to provide an example.

yes, If the model have only same dimentions data, it can. but in my case it is difference.

in below case, Write Mode "Overwrite" cannot delete Category=vegetable. but I'd like to delete it.

[hajime78]

Dear william.yu san,

thanks your support as always.

well noted. i guess i need to use 2 parameters "From" and "To". and change from copy step to advance formula.

B.Regards