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
explain in detail about type 3?
Explain how to execute the plsql procedure from the report by clicking with mouse?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What are the join problems comes appart from loop,chasm & fan Traps
Difference between b.o 5.1 and 6.1b?
Explain the difference between detect alias and detect context?
Is there any other repository domains rather than universe, security, document?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the difference between user and versatile user?
What Is The Difference Between Oltp And Olap?
What is the dense rank?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is object stores?
What is Indexing? how did u implement indexing?