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
- 9038 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 |
what is variable ?
Did you face any problems while creating reports? Name? Solutions?
I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
Can we Save (save as) WEBI Doc as DESKI?
what happens if cardinalities are not resolved?
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
Explain about a tricky situation for which you found a very simple solution?
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash
3 Answers iFlex, Maintec, TCS,
Tell me the difference between cmc and cms?
What is slicing and dicing in business objects?
Teradata 
