Problem in new query creation

[Former Member]

Hi Experts,

In a report there are two InfoObjects posting date and Expiry Date. User will enter the posting date at the run time. Now user wants to see the sales values for the conditions as below:-

0<=|(Expiry Date-Billing Date)/30|<6

6<|(Expiry Date-Billing Date)/30|<=12

12<|(Expiry Date-Billing Date)/30|<=18

18<|(Expiry Date-Billing Date)/30|<=24

24<|(Expiry Date-Billing Date)/30|<=36

36<|(Expiry Date-Billing Date)/30|<=48

48<|(Expiry Date-Billing Date)/30|<=60

Now question is when restricting the Expiry Date how to use value of Billing date. For example, say user gives Billing date=x. Now how to give restriction on Expiry date as x <(Expiry date)< x + 30*6.

Any input will be highly appreciated.

Thanks in advance.

Regards,

Prakash

[shanthi_bhaskar · Accepted solution]

1st thing you need do is convert the Expiry Date, Billing Date into Key figures for that fallow below approach..

http://www.sd-solutions.com/SAP-HCM-BW-Replacement-Path-Variables.html

then create a formula for Expiry Date-Billing Date , then you can include this formula in your conditions

[Former Member · Accepted solution]

Thanks a lot Shanthi for quick reply. Your input is very helpfull.

Again my problem is that Expiry date is navigational attribute of InfoObject Batch Number. Is it possible to make navigational attribute Expiry date as key figure using Replacement-Path-Variable?

Any input will be highly appreciated.

Thanks in advance.

Regards,

Prakash

[Former Member · Accepted solution]

You should be able to do this as nav attributes behave like a normal characteristics.

[shanthi_bhaskar · Accepted solution]

yes you can make use of navigational attribute also

[Former Member · Accepted solution]

Thanks for your reply.

Now problem is how to implement 6<|(Expiry Date-Billing Date)/30|<=12? We can restrict an InfoObject between an interval. Fow Example Material Number[122100;122400]. But how in implement it in case of calculated key figure or formula?

Any input will be highly appreciated.

Thanks in advance.

Regards,

Prakash