Best way to implement particularly Bex query

[Former Member]

Hi all,

we are on Hana 7.31 and we have a particularly request about Bex.

We have a DSO with the monthly income, the key are the ID (User ID) and 0calmonth, as ex

ID   calmonth    income

A1   012014       10000

A1   022014       10000

A1   032014       11000

A1   042014       12000

A1   052014       13000

The end user needs a new report. This report must show the monthly income selected with a normal end-user variable on 0calmonth and to compare this value with the income of another calmonth selected also with a end-user variable, as es:

variable 1 = 05.2014

variable 2 = 02.2014

RESULT   

ID    Calmonth    Actual income     Past Income   Difference

A1     05.2014           13000             10000             3000

I can imagine this is possibile only with a virtual kay figure or there is another vay to do it? The particular think is that the want to see all the data with the calmont value 05.2014 (Variable 1) also if the past income is on 02.2014 (Variable 2). It's easy to create a standard bex report with the actual income (deined on variable 1) and past income (on variable 2) but when we insert the calmonth in detail the system split the result in two different rows.

regards

Luca

[Former Member]

We'd done some attempts, prob the only way is to define the calculated key figure 'Past Income' with a Constant selection on the calmonth variable (variable 2) so the system shows all data with calmonth 05.2014

Any other idea?

Tks

[former_member199945]

Hi,

variable 1 = 05.2014

variable 2 = 02.2014

Either these 2 variables are mandatory /optional and these 2 are referring form same Char/different

if it is mandatory then

This is possible by creating 2 selections and  restricting those 2 with user entered variables .

like below :

and then create formula for those 2 selections past - actual.

Thanks.