cancel
Showing results for 
Search instead for 
Did you mean: 

Planning DATE keyfigures

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

Soulsurfer
Advisor
Advisor
0 Kudos

You should use keyfigures of type DEC, not DATS.

Former Member
0 Kudos

Hi Andrei,

This is the type I've used. (DEC). I can't understand why the system says tha is using an aggregation.

Thanks for your interest.

Soulsurfer
Advisor
Advisor
0 Kudos

Please check that in the tab "Aggregation" of keyfigure are following selections:

Aggregation SUM

Excep.aggr. SUM

Former Member
0 Kudos

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!

Soulsurfer
Advisor
Advisor
0 Kudos

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>

Former Member
0 Kudos

Sorry, the link takes me to a main index on BPS.

I understand what you say, my question is if I develop a global variable of exit type than try to get the date from the cube, is there and standard API to do it or may I make the calculation in the exit program?

Thanks Andrei for your help.

Soulsurfer
Advisor
Advisor
0 Kudos

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.

Former Member
0 Kudos

Ok. Perfect!

Thanks a lot!

Answers (0)