How to do Query filling in missing month

[former_member187713]

Hi

I want to build a BEx Query showing kilometer reading of cars for every month in the selected timeframe. Assuming I have the folling data for a car XY in my cube:

XY 01.2010 20'000

XY 03.2010 22'000

XY 04.2010 22'500

You can see, that there's no data for 02.2010 in the cube. The query should show all the month in the timeframe and if there is no data for one month, it should use the kilometer reading from the month before. The query output shold therefore be:

XY 01.2010 20'000

XY 02.2010 20'000

XY 03.2010 22'000

XY 04.2010 22'500

How can this be achieved?

thanks

[Former Member]

Hi,

This cannot be done in BEx. This is just a reporting tool based on data available. It can filter out the data from report, also you can create restricted keyfigures to get more out of report but you cannot create a new record in BEx.

If at all, you need to do this at ODS level by extracting data for all months.

[former_member187713]

Hi all

thanks for the reply. Guess will just create a structure for the months needed.

G

[Former Member]

Hi,

I'm sorry but with BEx Query is impossible. You can create an end routine in the DSO which calculate the kilometer of the month before.

Best Regards,

AleX