Skip to Content
author's profile photo Former Member
Former Member

Dynamic rendering of date intervals for a single query

Hi,

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)

Example

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 =)

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 05:43 PM

    this is a very normal requirement and is very much possible. Let me know if u need more details.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 10:25 PM

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.