Forum Stats

  • 3,836,791 Users
  • 2,262,192 Discussions
  • 7,900,112 Comments

Discussions

Presentation Variable Formatting in Report Title

I have populated 3 presentation variables via a dashboard prompt. I also display their values in the report subtitle, but I did not expect the following format in the display:

from TIMESTAMP '2009-10-19 00:00:00' to TIMESTAMP '2009-10-25 00:00:00' for Abilene

The dates appear formatted as 10/19/2009 and 10/25/2009 in the dashboard prompt which is how I want them formatted in the title. Where is this subtitle formatting originating? So, I can reformat it.

Edited by: Bob from Austin on Oct 26, 2009 11:28 AM
Tagged:

Best Answer

  • 710389
    710389 Member Posts: 193
    Answer ✓
    Hey Bob,

    change the format of your date prompt by using for example cast(year(date) as char(4))||cast(month(date) as char(2)....to the format you want to show in your title.

    Hopefully this can help you.

    Kr,
    A

Answers

  • 710389
    710389 Member Posts: 193
    Answer ✓
    Hey Bob,

    change the format of your date prompt by using for example cast(year(date) as char(4))||cast(month(date) as char(2)....to the format you want to show in your title.

    Hopefully this can help you.

    Kr,
    A
  • Goran Ocko
    Goran Ocko Member Posts: 554
    edited Oct 26, 2009 2:35PM
    Hi.

    I suggest you to read this first:
    How to change date format mask in date dashboard prompts - drop-down list and calendar
    http://108obiee.blogspot.com/2009/03/how-to-change-date-format-mask-in-date.html

    On the end of this post is a explanation of date format and presentation variable in the title:

    And you can find a complete example here:
    Date between in filter and title when using presentation variable from calendar dashboard prompt or drop-down list in OBIEE
    http://108obiee.blogspot.com/2009/03/date-between-in-filter-and-title-when.html

    Before everything customize instanceconfig.xml, change datatype of TABLE.COLUMN in the physical layer to DATE and keep on eye if you are using repository variables as default values to dashboard prompt, which datatype they have, character, date or timestamp, this can cause problems. That's explained in the posts above.

    Regards
    Goran
    http://108obiee.blogspot.com
    Goran Ocko
This discussion has been closed.