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
- 3 Answers
- 7858 Views
- I also Faced
- E-Mail Answers
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 |
How do u Receive requiremnts from the client?
how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?
How do scheduling the report in BO XIR2? can you say what are they steps?
what are slowly changing dimensions, confirm dimensions?
Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..
What is a fantrap in business objects?
where are objects are stored ?
How would I achieve Traffic Lighting 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?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
Teradata 
