cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member308471
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

JohnL
Product and Topic Expert
Product and Topic Expert

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))

Answers (1)

Answers (1)

former_member308471
Participant

Hi John,

It would be great if SAP channel can contributed a video tutorial with use of above functions including Next & Last.

Also, the relative functions needed may not be necessarily dependent on time, it can be relative to the current position in context to he list of dimensions already pulled.

Regards,

Kiran Shenvi

former_member308471
Participant

Hi Iver,

Sorry for being late... This is such an excellent working example from you... loved it! Thanks a ton!