2 Replies Latest reply on Sep 1, 2015 4:08 PM by jepva

    Issue with date/month sorting in BI Publisher when using Period and Year Dimensions


      My query is pulling period and year dimensions, for example "Jan" and "2010" from a Essbase planning application, the problem is since these are seen as VARCHAR by OBIEE, BI Publisher sorts the month alphabetically and not as a date.  I can convert the months to numbers, say 01-14, 02-14, etc. but the requirement is to have month abbreviations.  Since no real date exists, I am having trouble trying to convert this into a date format.  Any use of the to_datetime function results in aggregation errors.  Any known work-around for this, to get BI Publisher to sort correctly?