Is there a Previous() or Next() function in BOC?

[former_member308471]

Hi All,

Currently while implementing visualizations in BOC we needed the values of measures at previous or next rows relative to current row. This in Business Objects could be implemented using Previous() or Next(). is there a way to implement the same in BOC?

Regards,

Kiran Shenvi

[JohnL · Accepted solution]

Hi Kiran,

Time navigation syntax is not supported in stories at the moment. Vote up this enhancement request: https://ideas.sap.com/D38119 and provide any additional input.

We do have formula's (in the modeler) that support this syntax:

LOOKUP([Sales],[d/Time]=Next("Year",1).Current("Month"))
RESTRICT([Sales],[d/Time]=Next("Year",1).Last("Quarter",1).Last("Month",1))
LOOKUP([Sales],[d/Time]=Next("Year",1).LastPeriods("Month",2))