How to use Date Functions with Calculated Fields?
I saw the wiki article about how to set up a date hierarchy using date functions: http://wiki.yellowfin.bi/display/USER74/Creating+a+View#CreatingaView-DateHierarchyFields but this assumes that you have a date formatted field in your database to use.
In our database the dates are stored as integers in the format yyyymmdd. I have created a calculated field that converts this integer to a date, but I can't seem to use the date function to generate a date hierarchy using a calculated field.
Is there a way to leverage this functionality without having to change our database schema?