This website is not affiliated with, sponsored by, or approved by SAP AG.

Customer Exit Variable in cell definition in BEx

Business Warehouse

Moderators: Snowy, thx4allthefish

Customer Exit Variable in cell definition in BEx

Postby kukku » Fri Nov 18, 2011 4:21 am

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". 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 have also defined cell definition to define each individual cell for key figrue "Quantity cumulative".

I would be helpful if you can give some hints.

Thanks
kukku
 
Posts: 26
Joined: Wed Mar 29, 2006 8:55 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 7 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.