Skip to Content
0
May 04, 2009 at 09:20 AM

strange behavior in Webi : No data returned

12 Views

Hi,

I am experiencing a strange behavior.

I have created a condition object in universe.

Start Date : DATE_DIM_TBL.DAY >= UPPER(to_char(to_date(@prompt('Enter start date','D',,mono,free),'dd/mm/yyyy HH24:MI:SS'),'dd-mon-yy'))

End Date : DATE_DIM_TBL.DAY <= UPPER(to_char(to_date(@prompt('Enter end date','D',,mono,free),'dd/mm/yyyy HH24:MI:SS'),'dd-mon-yy'))

Now when I create report to display years between 01-05-2005 and 04-05-2009. Report does not return any data.

Where as when I execute the generated query from SQL prompt it return correct data.

SELECT

DATE_DIM_TBL.CALENDAR_YEAR_NAME

FROM

DATE_DIM_TBL

WHERE

(

( DATE_DIM_TBL.DAY >= UPPER(to_char(to_date('01-05-2005 00:00:00','dd/mm/yyyy HH24:MI:SS'),'dd-mon-yy')) )

AND

( DATE_DIM_TBL.DAY <= UPPER(to_char(to_date('04-05-2009 00:00:00','dd/mm/yyyy HH24:MI:SS'),'dd-mon-yy')) )

)

can somebody please give any pointers about what has gone wrong in WebI.

--Kuldeep