Planning DATE keyfigures
Is it possible to plan DATE keyfigures?, I need to plan some dates every month when we evaluate a cashflow forecast using this dates. The dates are such as Final Project, Initial Works date, Initial Sales Period, etc. (They don't come from PS R/3 module, we prefer they plan this dates in IP system)
The problem is that when I create the date keyfigure I can't enter planning data, the system says that there is a MAX aggregation but I'm using a unique record selection.
If this is not possible I'm thinking on use an Integer keyfigure that acts as an offset from an starting date that can be an attribute of the main characteristic (0PROJECT). In this scenario I will plan just the offsets from this date, but then the problem will be how to define a Variable that gets the date from a calculation obtaining the diference between one variable (type 0CALDAY) and the offset obtained from he infocube.
I hope to be understood, it's a little complex to explain.
Please check that in the tab "Aggregation" of keyfigure are following selections: