Skip to Content
avatar image
Former Member

Date format in IDT


I have an universe based on Teradata. I created a filter in IDT and it's like this :

@Select(Sales\Calendar Day) =  @Prompt('Date:','D',,Mono,)

When I use this filter and execute a test query in IDT, the date format is shown different in these 2:

Enter a value : 10.Feb.2015

Date : 10.Feb .2015 00:00:00

I formatted the Calendar Day dimension and I can see it as 'mm/dd/yyyy' in the report result. That's fine.

However, I want to do the same for the prompt screen in IDT too. How can I do this?

The requirement is, I use the same filter for SAP Lumira and it does not provide a calendar component for date selection.

So, the format of date to pass to universe is not clear.

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 11, 2015 at 10:46 AM

    Hi Steve,

    As you are using Date object, BO will by default add the timestamp as soon as you will choose any date from default Webi calendar.

    In order to avoid timestamps on prompt window, you will have to edit ObjectFormat.xml file.

    Below forum link might help you:

    NOTE: editing XML will only fix the issue in BI Launchpad and not at client tool level.



    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16, 2015 at 09:35 PM


    Try to change the format Cal day using below options, and then check the filter date format is showing as per your requirement

    predefined function TO_CHAR

    Use the custom display format option.

    Please find the below link for more info

    BI4.1 Business Layer Enhancements - Create Display Format

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dasari,

      As far as I understand this is related to 'Date' part of the prompt.

      Because I created a new dimension (CharDate) as you've suggested, however it still appears with timestamp in IDT.

      @Select(CharDate) =  @Prompt('Date:','D',,Mono,)