i am facing date format issue in webi report in BI4.0
environment.
i have unx based on Mysql connection.
date is coming in 10 digits numeric format like(2345623456).
I want to change it in dd.mm.yyyy format.
Please suggest

Answer Posted / siri

by using FORMAT NUMBER function we can change the numeric format

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

933


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4520


How we drill up week to month?

841


What are the steps to do to use alerts in bo?

883


Difference between b.o 5.1 and 6.1b?

914


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

776


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6475


What is a bo repository?

813


Can anybody tell me what are the tuning problems?

1815


What is the difference in creating filters in designer and business objects?

829


Did you face any problems while creating reports? Name? Solutions?

3497


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1832


What is thumbnail?

767


What would you consider as your biggest achievement and why?

820


Explain the data types present in bo and what happens if we implement view in the designer and report?

809