on 11-16-2007 6:05 PM
Hi all,
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.
Best regards,
You should use keyfigures of type DEC, not DATS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrei,
Thank you very much!, now is working!, sorry, when I put DATE ratio it appears by default MAX aggregation and I didn't think it was a bad idea.
Let me ask you something about it please, the system will manage this dates internally as numbers, I'll need a global variable that gets the date from the infocube, due to the fact that inside the cube we have some delta records that sums the final date, is there any standard function to get de date or may I do some calculations to obtain it?
Thanks again!
For example the date 01.01.2008 would be 733043. If you, for example, will change it to 31.12.2008 in cube will appear record with value 365 and the same key.
And when you will retrieve value for this key you'll receive value 733408 (aggregation SUM) which is equal to 31.12.2008.
I hope this link will be helpful <a href="http://help.sap.com/saphelp_nw04s/helpdata/en/05/242537cedf2056e10000009b38f936/frameset.htm">http://help.sap.com/saphelp_nw04s/helpdata/en/05/242537cedf2056e10000009b38f936/frameset.htm</a>
Sorry, the link should be this one <a href="http://help.sap.com/saphelp_nw04s/helpdata/en/0e/8007d983d011d3b72e0000e82debc6/frameset.htm">http://help.sap.com/saphelp_nw04s/helpdata/en/0e/8007d983d011d3b72e0000e82debc6/frameset.htm</a>
In ABAP exit an automatic conversion will happen if you assign to variable of type DATS value of type DEC.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.