on 01-09-2017 6:32 AM
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
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))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kiran, already a start here: http://www.ivervandezand.com/single-post/2017/01/15/How-to-calculate-it-best-practice-Formulas-put-u...
Hi Iver,
Sorry for being late... This is such an excellent working example from you... loved it! Thanks a ton!
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.