Skip to Content
0
Feb 18, 2009 at 12:17 PM

Cumulated amounts in the Query

33 Views

Hi Sap Developers,

I need some hints to create a query. I haven't found any solutions until now.

I've got an infocube with amounts grouped by day, which are gonna be displayed in the query using the cumulated format as follows:

1/jan 2/jan 3/jan 4/jan

Cube Cumulated Cube Cumulated Cube Cumulated Cube Cumulated

10 10 11 21 12 33 13 46

The cumulative period starts on the first day of the month. Only the cumulated values above will be displayed in the query.

When the user selects 3/Jan - 4/Jan, for example, the query should display only the two columns related to these days, regarding that the cumulated amount of 3/Jan and 4/Jan has to be 33 and 46 respectively.

Through Bex, I have to select the whole month to get the expected result. If I input 3/Jan - 4/Jan, for example, the query shows 12 and 25, that is, it starts the cumulative period on the first day displayed in the query.

I've created a customer exit variable tied to a restricted key figure in order to get the cumulated amount from the first day of the month until the day before the date entered by the user. It's worked as far the amounts is concerned, but all the columns are displayed.

I've tried others alternatives, but without success.

Before modifying the infocube structure, I would like to confirm with you if there is any solution for this scenario. Suggestions are welcome.

Regards,

Tiago