Skip to Content
0
Jul 20, 2016 at 08:15 PM

Webi Query Filter Date displaying incorrect date format (MM/DD/YYYY) even though object displays MON-YYYY format

279 Views

Hi,

FYI, I am using BO 4.1 SP7. My backend database is Oracle 12C

I created a object in IDT to display date in MON-YYYY format. Please see Picture below.

To get the display in MON-YYYY format, I even changed Display format as below.

but when I add this object to the Query Filters in Report Query in WEBI, instead of getting values in the format of JAN-2016 I am getting it in the format of 10/1/2016 12:00:00 AM. Please see picture below

But when I run the report I am getting the data in the format I intended.

My Main issue is, how do I get the Query Filter List Of Values to display in MON-YYYY format?

I also tried just using to_char function to create object i.e., to_char(DW.PRCDNG."Institution Decisions Due Date",'MON-YYYY') but if I use this I would get incorrect results if use this in query filter since its a string. Ex: If I say I need Data >= JAN-2015, it ignores the "Greater than or equal to" and it brings all values to report.

Please help me here.

Thanks & Appreciate your help.

Attachments

Dimension.jpg (46.9 kB)
Report.jpg (20.6 kB)
Query.jpg (102.3 kB)