Need Help in Query Design!!!!

[Former Member]

Hello Guys,

We are developing a BI 7 report. the requirement is such that the customer during query execution is providing the number of days. With this input in consideration, we need to bring in data which falls in the range (current date - number of days). Would be great if you can share your ideas on it.

[Former Member]

Hi,

You can use variables where it will prompt you to enter the calendar year and based on that the query will be displayed...

Check out the link below:

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a56a7e09411d2acb90000e829fbfe/frameset.htm

Regards,

Kishore