SAC Data Action - Date Copy - model at Day granularity

[JGEN]

Dear Community

I m currently working on a data model with a Day Granularity and i was wondering if there was a simple way to copy Actual Data ( at day granularity) to my planning version

In the data action i would like to set up a Year Reference and then automatically the data action will copy these data to the Target year

I currently facing some difficulties because idealy i would like to mention only the year as a reference and as target

Does someone has a nice solution ?

For exemple this kind of script is working where %Annee_reference% is in fact a day but i do not find a smart way to mention the target year 

Best regards 

Julien

IF [d/Date].[p/YEAR]="2025" AND YEAR(%Annee_Reference%)=2025 THEN
DATA()=RESULTLOOKUP([d/Version]="public.Actual")
ENDIF

IF [d/Date].[p/YEAR]="2025" AND YEAR(%Annee_Reference%)=2026 THEN
DATA()=RESULTLOOKUP([d/Version]="public.Actual",[d/Date]=NEXT(1,"YEAR",[d/Date]))
ENDIF

[William_Yu1]

Hi Nono, 

   I'm wondering why aren't you using the copy step to achieve this? 

Best regards, William 

[JGEN]

Hello William yes it can also work with a copy step