SAC Advanced Formula - Copy month value to all months of specific year

[mfrieser]

Hello,

the requirement is rather simple, but i am not yet very experience in advanced formulas.

I want to select a month of a specific year (defined as dynamic parameter) and then select a year (or year as the node of a date hierarchy). 

Then this monthly value should be copied to every month of the selected year. 

How is this possible with advanced formula?

Thank you!

[mfrieser]

I just figured it out myself, this is the code:

MEMBERSET [d/Measures] = "VALUE_PROJECT"

MEMBERSET [d/Date] = BASEMEMBER([d/Date].[h/YM], %TARGET_YEAR%)

DATA()=RESULTLOOKUP ( [d/Date] = %SOURCE_MONTH%)

[N1kh1l]

mfrieser, Thats perfect.