Skip to Content
0
Former Member
May 06, 2010 at 01:16 PM

Get result in Query by MAX date

202 Views

Hello.

In My InfoCube I got planning data (planning amount P_AMOUNT) for every calendar date (0DATE) by planning level (P_LEVEL) and planning date (P_DATE). So every P_LEVEL/0DATE combination has many P_DATE values with different P_AMOUNT.

In my report I need only those amounts which correspond to LAST P_DATE. How can I do it in BEx query?

Example. I got values in InfoCube:

P_LEVEL 0DATE P_DATE P_AMOUNT

111 2011.01.01 2010.05.01 101

111 2011.01.01 2010.05.02 102

111 2011.01.01 2010.05.04 140

222 2011.01.01 2010.04.01 100

222 2011.01.01 2010.04.05 500

222 2011.01.01 2010.04.15 150

In my query I need such result:

P_LEVEL 0DATE P_DATE P_AMOUNT

111 2011.01.01 2010.05.04 140

222 2011.01.01 2010.04.15 150

The main issue with that I need to get MAX P_DATE by P_LEVEL and 0DATE. I have no idea how to do it in BEX Designer.