cancel
Showing results for 
Search instead for 
Did you mean: 

KF calculation

Former Member
0 Kudos

Hi All,

I have one KF 0Amount in my Infocube. Data is as below in this KF:

FiscalYP      0Amount

2001000         0
2001001       100
2001002       200
2001003       -100
2001004        500
..
...

2001012       100
2002000       0
2002001       300
2002002       200
...

I need to calculate one KF that will represent the 0Amount for current month - 0Amout for previous month as below

FiscalYP         CALKF
2001001           100  ( 100-0)
2001002            100 ( 200-100)
2001003           -300 ( -100-200)
2001004           600 ( 500-(-100))
...
..

2002000          0 
2002001         300 ( 300-0)
..
..

Problem is users want to report on all the years and fiscal period dynamically. He can either select one year or 5 years or 10 years. Initially I thought i can achieve with the help of customer exits, but I am find hard to make the logic.

Please guide me.

Aman

Edited by: AmanSharma123 on Jun 10, 2011 9:08 AM

Edited by: AmanSharma123 on Jun 10, 2011 9:17 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I am waiting for guidance!

Former Member
0 Kudos

Hi Aman,

Didnt we already discuss this?

Former Member
0 Kudos

Thanks for your reply Parth.

No both are different problems. This one is the difference between KF for current fiscal year period and previous fiscal year period.

Waiting for your reply!

Regards

Amandeep Sharma

Former Member
0 Kudos

Hi Aman,

This too again is not possible at BEx. You would need to go for calculations during data load.

OR you can try Virtual Key Figures

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60e34f63-f44c-2c10-488e-c89b04e0c...

But such ABAP run during query runtime is very performance intensive. So coding in transformations is faar better option.

Answers (0)