Entering Values with Dynamic Time Filters
In a table based on a planning model in SAP Analytics Cloud, you can enter data into cells calculated by dynamic time filters, including member functions such as YTD.
Entering values on member functions
When you enter data on a YTD, QTD, or MTD value, the change in value is assigned to the last booked member of the date dimension.
For example, consider a table that shows YTD values for 2018, with $1 million booked to both January and February 2018 and the rest of the months unbooked:
If you change the YTD value for April 2018 from $2 million to $3 million, the extra $1 million will be booked to February 2018:
Entering values for calculations with dynamic time filters
Inverse functions can be defined for calculated members based on restrictions that use dynamic time filters. This allows you to simulate planning scenarios by changing KPIs such as YOY growth, for example. For more information, see the Inverse formulas with dynamic time filters section of Inverse Formulas.