I have problem in Webi 6.1b.
I have two prompts(Year Prompts) like
Year from
Year to
and another two prompts for Month for month range ( from mOnth and To month)
If i select the years from prompts 2003 to 2004 and Month range from April to Mar
i want to get the data in months like from 2003 april to 2004 Mar
ex:
Apr 03 May 03 June 03 July 03 Aug 03… Dec 03 Jan 04 Feb 04 Mar 04
Seems like you will need to build matching objects in your universe to correspond with whatever prompts you are building.
And/Or build some mighty fancy query conditions that cover all possible combos of year and month.
My suggestion is to use MM - 01 to 12 instead of MMM - Jan to Dec and concatenate this with YYYY so you can select YYYYMM in ranges.
Of course, the usual disclaimer, this may play havoc with your database by circumventing any indexes.