Oracle Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Format Date doesn't display month as upper case

Received Response
671
Views
22
Comments
User_U66J8
User_U66J8 Rank 4 - Community Specialist
in Oracle Analytics

Summary

Format Date doesn't display month as upper case

Content

Hi All,

 

 

I'm using OTBI release 12 and I have a BI publisher predefined report.

I have a field where I want the date to be displayed with the following date mask : DD-MON-YYYY. It works almost correct, but the month is not uppercase(e.g. not APR but Apr). Any ideas?

 

Here is the source I use:

 

 

<?format-date:(xdoxslt:ora_format_date_offset(xdoxslt:sysdate('YYYY-MM-DD'),7,'+'));'DD-MON-YYYY'?>

 

 

Thanks in advance,

Aleks

Tagged:
«13

Answers

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    Might be some help

    https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2568

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    post ur sample xml and rtf template ur using can help u out.

  • User_U66J8
    User_U66J8 Rank 4 - Community Specialist

    Hi,

    Thanks for your answer, but  I checked this before and  I cannot see a solution or workaround.

    Regards,

    Aleks

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    which excel version ur using..

  • Swapna Kankipati
    Swapna Kankipati Rank 2 - Community Beginner

    I have the same issue can you help.

    In RTF template I added column to show fiscal period but in the excel output the month is not uppercase.

    xml tag :

             <START_DATE>2018-01-01T00:00:00.000-05:00</START_DATE>

             <FISCAL_PERIOD>JAN-18</FISCAL_PERIOD>

    whereas the excel output is formatting and showing : 

    18-Jan

    I have tried using below formatting in the item but nothing helps.

    <?xdofx:to_char(START_DATE,'MON-YY')?>

    <?format-date:START_DATE;'MMM-YY'?>

    <fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?FISCAL_PERIOD?></fo:bidi-override>

    I would like the fiscal period column output in excel to show as JAN-18 same as what Oracle is generating the xml file.

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    <?xml version="1.0" encoding="UTF-8"?>

    <DATA_DS>

    <G_1>

    <SYSDATE>2018-04-06T10:54:08.000-05:00</SYSDATE><FISICAL_PERIOD>APR-06</FISICAL_PERIOD>

    </G_1>

    </DATA_DS>

    If this one is upload in rtf and shown output in excel it shows me in all caps in .xlsx excel output

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    excel 2013 is ur excel output is in .xsl or .xslx

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics & AI Lead

    image

    image

  • Swapna Kankipati
    Swapna Kankipati Rank 2 - Community Beginner

    I have excel 2010, which version did you try in ?

  • Swapna Kankipati
    Swapna Kankipati Rank 2 - Community Beginner

    The excel being generated is in xls format.  Is because of the MS office version the format is giving issue ?  Which office version should I get for formatting to work ?

    Also my BI publisher is bit diff than yours,  we are on R12.1 so I'm using BI publisher version 10.1.3.3.0.

    image