SAC Data Action : send date value parameter

[former_member138894]

Hi Experts

Could anyone help me with the below code please.

simple code but not working. I need to pass dynamic values to my data action for that I am first trying it out with constants then I will replace with script variables in Javascript.

DA_1.setParameterValue("CC_P", "GB1"); => company code dimension

DA_1.setParameterValue("MY_P", "202304"); => DATE dimension format "YYYYMM"

DA_1.execute();

The code above does not produce any errors, but it also does not perform the desired action of storing a value in the planning model. I would greatly appreciate any help or insights you can provide.

Thank you in advance.

Best regards,

M

[former_member138894]

Hi Nikhil

Thanks for your quick reply.

my DA code: this will write a new record with the parameter combination assigns Rowcount=1 and also it will make sure always the company code has only one record.

VARIABLEMEMBER #period OF [d/Date]

VARIABLEMEMBER #compcode OF [d/Comp_code]

DELETE([d/Comp_code] = %CC_P%)

DATA([d/Measures] = "RowCount", [d/Comp_code] = %CC_P%, [d/Date] = %MY_P%) = 1

when I execute the above java code: the DataAction monitor gives this error:

It is not able to assign the parameters. if I execute Data action directly, it executes perfectly. but not through the Javascirpt.

Thanks

M