Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

KF calculation

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

Former Member
replied

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-c89b04e0ca7c?QuickLink=index&overridelayout=true

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question