General OBIEE

Get Involved. Join the Conversation.

Topic

    Matthew McGuirk
    Date Formatting - Excel ExportAnswered
    Topic posted April 20, 2017 by Matthew McGuirk, last edited April 21, 2017, tagged Analyses, BI Publisher, Discussion Forums, OBI Answers, OBIEE Answers, OTBI, Report Output, Reports 
    127 Views, 4 Comments
    Title:
    Date Formatting - Excel Export
    Summary:
    Can't filter by year and month on OTBI export
    Content:

    When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day as shown in the attached screenshot comparison.  Does anyone have a solution or workaround?

    Thanks!

    Matt

    Best Comment

    Reena Trangri

    This is a very old known issue and expected to be fixed in next OBI version upgrade. There have been earlier many related posts on the same providing the workarounds to have this resolved at our end.

    Pls. find below some posts discussing the same issue

    https://cloudcustomerconnect.oracle.com/posts/41852cf1ad

    https://cloudcustomerconnect.oracle.com/posts/f61de2937e

    Regards,

    Reena Trangri

    Comment

     

    • Prudence Kruchten

      Hi Matt - the easiest way that I have found (without seeing your screenshot - doesn't look like it was attached?) is to highlight the column with the dates and then replace / with /  Not sure why that matters, but then it works as a date column. 

      • Matthew McGuirk

        Thanks!  That worked!  I would still be interested if anyone has a solution for correcting at the source.  Seems like there should be a format setting.

    • Reena Trangri

      This is a very old known issue and expected to be fixed in next OBI version upgrade. There have been earlier many related posts on the same providing the workarounds to have this resolved at our end.

      Pls. find below some posts discussing the same issue

      https://cloudcustomerconnect.oracle.com/posts/41852cf1ad

      https://cloudcustomerconnect.oracle.com/posts/f61de2937e

      Regards,

      Reena Trangri

    • Matthew McGuirk

      Thanks!