I have an interesting issue. When I first built my Insight dashboard I was able to pull in a slider, which recognized the YearMonth field I am using in my chart and list widgets. The dashboard has become increasingly complex (multiple widgets) and now when I go in to edit the slider, the list of values will only display a range of numbers, comma and all! I've searched through all of my widgets and they are all pulling the same field, which is a to_char(xyz.yearmo,'YYYYMM'). How can I get BI to recognize that this is a date (again) instead of a number?
Thanks!
Devon
I was able to fix the issue. BI was being very picky about the format of the data item. I ended up having to put a 'YYYYMM' char in the database and pull it through to BI. Once all widgets had the exact same format, the date slider recognized it as a date.