Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9178 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 |
Can we take report on Excel in Business Objects?
6 Answers Business Intelligence Analytics, Oracle,
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
How many universes will run maximum in single project
1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
Can i merge two dataproviders if they do not have common column?
HOW TO HIDE Column in WEBI & DESKI?
How to get top 5 rows of a selected column?
Teradata 
