Skip to Content
0
Jul 06, 2010 at 07:00 AM

How to do Query filling in missing month

13 Views

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