Skip to Content
0
Former Member
Nov 18, 2011 at 08:17 AM

CKF in BEx

13 Views

Hi,

I have defined a query with a Structure in Row and Key Figures in column.

The result of query should look like this:

Fiscal/Year Period | Quantity per month | Quantity cumulative

011.2010 (Variable Offset Value -3) | 5 | 5

012.2010 (Variable Offset Value -2) | 6 | 11

001.2011 (Variable Offset Value -1) | 7 | 7

002.2011 (Variable Singel Value, Manual Input) | 8 | 15

"Quantity cumulative" is defined as follows:

Quantity cumulative (002.2011) = Quantity 001.2011 + Quantity 002.2011

Quantity cumulative (001.2011) = Quantity 001.2011

Quantity cumulative (012.2010) = Quantity 011.2010 + Quantity 012.2010

Quantity cumulative (011.2010) = Quantity 011.2010

"Fiscal/Year Period" and "Quantity per month" are OK. But I have problem to define the key figrue "Quantity cumulative".

I have defined a Customer Exit Variable on Reference Characteristic "Fiscal/Year Period". The Quantity cumulative (002.2011)

and Quantity cumulative (001.2011) are calculated correct. But it doesn't work for 012.2010 and 011.2010 (because of previous year).

I would be helpful if you can give some hints.