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 / avijit paul

create a variables to get the individual digits and then
concat the extracted digits. you can change it to date
format also using todate().

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain in detail about type 3?

631


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

600


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1537


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1815


What are the join problems comes appart from loop,chasm & fan Traps

1556






Difference between b.o 5.1 and 6.1b?

653


Explain the difference between detect alias and detect context?

629


Is there any other repository domains rather than universe, security, document?

600


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1623


What is the difference between user and versatile user?

585


What Is The Difference Between Oltp And Olap?

680


What is the dense rank?

679


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

593


What is object stores?

583


What is Indexing? how did u implement indexing?

1820