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.