on 06-10-2011 8:08 AM
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
I am waiting for guidance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
But such ABAP run during query runtime is very performance intensive. So coding in transformations is faar better option.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.