Month range issue

[Former Member]

Hi Experts,

I need to get data between different intervals (like January 2010 to January 2011),for this am using filter in webi with the help of u201D betweenu201D operator. but am not getting original data .

Here am applying filter on cal year\month field.

Please do needful

[Former Member]

Hi,

First of all you bring all months data with out month filter. Then check for each month the data is correct with your original data.

Regards,

ArunKG

[Former Member]

Hi,

Create two objects at universe levelusing your Like From month :@Prompt('Enter From date','D',,mono,free)& To Month :@Prompt('Enter to date','D',,mono,free) and drag these two variables at query filter pane and use between operator select object From & To which u created at universe level..

In my project i did the same way its working for me .

let me know if am correct or not

[Former Member]

Hi

Did you checked that in query filter the months order like jan .feb ,march,...if it is like that order then you will get values corecty filtered in the report level by default it will show like apr,aug...in order instead of jan ,feb .

In query filter the list of values are not in order like jan2010,jan 2011 ..like that then you have to contact to universe designer to rearrange the order

Hope this helps u

Edited by: K.sunil on Nov 26, 2011 11:27 AM