Skip to Content
0
Aug 26, 2020 at 12:10 PM

Dynamic Time Navigation Functions with Variable in SAP Analytics Cloud

48 Views

Hello,

I'm trying to create different restricted measures in the modeler with the RESTRICT function all based on the same variable ('ZVI_CALYEAR') in order to choose the year to restrict.

I've one measure for Year N which is working well : RESTRICT([Amount],[d/Year]=['ZVI_CALYEAR'])

But I want to restrict also for N+1, N+2 regarding the variable chosen. I've tried to use dynamic time navigation functions (https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/2784376d431e4a7da9564880dadb084d.html#loio2784376d431e4a7da9564880dadb084d__section_how) but it's not working with variable : RESTRICT([Amount],[d/Year]=Next(['ZVI_CALYEAR'],1)) or RESTRICT([Amount],[d/Year]=Next("Year",1).['ZVI_CALYEAR'])

Can you help me,

Thanks, Etienne