BI4.1 Business Layer Enhancements - Create Display Format

[former_member4998]

Hello All,

In the this document, am explaining how to create custom display formats for business layer objects using create display format option, within information design tool. You can create, edit, or delete the display format for multiple business objects at once.

Go to Universe Designer & open the universe --> click the Business layer --> (1)Select the object -->Click on the Advanced tab --> Click on the Show Values button, Its displays the Planned Prod Date default display format (M/D/YYYY HH:MM:SS AM).

     

But user would like to see the date format as “DD/MM/YYYY”.  To concert date format to from “M/D/YYYY HH:MM:SS AM” to “DD/MM/YYYY”,

Method 1: Use the predefined function TO_CHAR

Add the To_Char (object name, required format) [To_Char (PLANNED_PROD_DATE,'DD/MM/YYYY']) in the SQL Definition Tab --> Save and select show values button for observation of required display format values appears.

   

Method 2: Use the custom display format option.

Select the object --> Click on Advance tab --> Click on Create Display Format button --> Select the Date-Time --> click on custom Format --> Select Day/Month/Year Formats according to the requirements --> OK, OK --> Click on the Show Values button for Observation of the correct data           appears, Save your universe and export it

   

       Same process follow for numeric values custom format. I hope this will be useful for create custom date and numeric required format in IDT.