Working with Dynamic Time Navigation Functions in Sap Analytics Cloud
This document is a step by step guide on how to work with Dynamic Time Navigation Functions. Please read this in conjunction with SAP Help Documentation.
When working with Calculated Measure, there might be use cases that require Lookup along with various time functions. Some of the examples like Year Total values, Rolling sum totals etc. We can achieve these type of calculations with the use of LOOKUP or RESTRICT along with Dynamic Time Navigation Functions.
I will try to outline the steps in creating such measures using calculations to get total value in a year using Lookup function.
New Calculated Measure in Model
Create a new Calculated Measure in the model. The formula has Time function -- Current("Year") that refers to current year. Please refer to SAP Help documentation for more functions like previous, next etc...