If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Slider Won't Recognize Dates

Started by uidancer1, 30 Apr 2012 03:32:54 PM

Previous topic - Next topic

uidancer1

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

uidancer1

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.