How to execute data action from Jan of Current year always?

[azm_azm]

Hi,

I want a syntax/memberset definition for date dimension in data action where no matter whatever the start date or end date of version is configured, data action should always be executed forJan of CY.

For ex, Actual : Start Date is 202401 End Date is 202412

In this case, I can use, MEMBERSET = VERSION.STARTDATE TO VERSION.ENDDATE. This is serving my purpose.

But when the Start Date changes to 202402. It will execute from 202402 but I want it to be executing from 202401 always.

Anyone who has faced this similar kind of issue and knows the workaround in this case. Their comments would be deeply appreciated.

Thanks.

[William_Yu]

If the data action is to be triggered from story by user, you maybe can try to get the current year in story via JavaScript coding and pass the year value as parameter to data action via trigger API, in the advance formula you can simply use normal MEMBERSET expression like below: MEMBERSET [d/Date] = BASEMEMBER([d/Date].[h/YQM] , %Period% )

[N1kh1l]

@azm_azm 

Unfortunately you would need another attribute in version with value set to YYYY.01. The issue is FIRST() cannot be used in MEMBERSET(). 

Nikhil