I am new to BW so I am not sure if this is even possible, or if there is a better way to do this.
I am trying to build a query in the Query Designer to basically display sales data for a Business Partner where a user is able to select a date range (max of 12 months) .
The tricky part is to show the sales data broken down by month.
In addition the number of months to be displayed is based on the number of months in the date range inputed by the user. (Basically dynamically displaying the number of months)
1. A user inputs a start date and end date, via a date interval variable. Assuming the inputs are Feb 1 2006 to June 1 2006
2. Based on the dates, when the query is run, the results should display sales data for Business Partner ABC Corp for 5 months beginning Feb 1 2006.
3. The end result of the report should look something like this.
======== Feb March April May June
ABC Corp 11.00 22.00 33.00 15.00 77.00
4. Now the same user inputs a different set of dates , say Mar 1 2006 to May 1 2006.
The result should display this.
======== March April May
ABC Corp 22.00 33.00 15.00
If this is not possible, please let me know. Thanks for your help =)