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
Answers were Sorted based on User's Feedback
Answer / siri
by using FORMAT NUMBER function we can change the numeric format
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gowthami
Right click on the column and do date formatting.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is maximum number of promts we can give in a BO report?
working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
What are the different types of connections?Explain?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
Explain how we drill up week to month?
How many ways you can restrict data in business objects?
What is broad cast agent?
When we go for OLAP , and When we go for OLTP for generating the reports ?
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
What are the different types of Filters available in BUSINESS OBJECTS?
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?