Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 11, 2017 at 08:44 PM

    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))
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 15, 2017 at 01:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded