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

What is thumbnail?

580


Can you please send me the migration related issues .

1644


What is Indexing? how did u implement indexing?

1817


any difficulitis have you phase while creating bo reports and how did u solve it

2993


Differences between business objects and web intelligence reports?

651






Can we create universe with no cache??

1956


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

550


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


What Is The Difference Between Oltp And Olap?

676


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598


Explain how to execute the plsql procedure from the report by clicking with mouse?

598


Explain what are the measure objects?

549


Explain in detail about type 1?

654


What is the profile and package?

1767


What are all difference between business objects 6.5 and xi r2?

600