Skip to Content
0
Former Member
Nov 21, 2011 at 09:02 AM

Customer Exit Variable in cell definition in BEx

19 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 Single 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". Moreover I have also defined cell definition to define each individual cell for key figrue "Quantity cumulative" restricted by Customer Exit Variable.

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.

Thanks