SAP Analytics Cloud for planning - Dynamic Time Selection

[guenay]

Hi freinds,

I want to dynamically filter the next year. My idea was like following:

MEMBERSET [d/Date]=NEXT(1,"YEAR",TODAY()) TO NEXT(1,"YEAR",TODAY())

However, this only affects a single month (currently just March 2026).

My goal is to select the entire year 2026.

Does anyone have a good idea on how to achieve this?

Best regards,
Ismail

[N1kh1l · Accepted solution]

@guenay 

Just maintain 2 attributes in version dimension and use that. Its always easier and more flexible that way. Some keywords have restrictions to be used in MEMBERSETS like First period etc.

You can maintain start date as 2026.01 and end date as 2026.12 in version dimension

MEMBERSET [d/Date] = [d/Version].[p/START_DATE] TO [d/Version].[p/END_DATE]

Hope this helps !!

Nikhil

[guenay · Accepted solution]

Thanks for your answer. But how would you do it with "FIRST" and "LAST". That would be far more dynamic. Thanks in advance.