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
- 7902 Views
- I also Faced
- E-Mail Answers
Answer Posted / siri
by using FORMAT NUMBER function we can change the numeric format
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differences between business objects and web intelligence reports?
Explain what is the difference between slice and dice and cross tab report?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
can anybody tell me about complicated object you have created
Explain about a tricky situation for which you found a very simple solution?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how to create metric universe ?
What are the steps to be taken to schedule the report?
Explain is data mart?
What is the difference in creating filters in designer and business objects?
Can more than 1 metric be applied on an analytic in business objects?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain when we use aggregate awareness function in designer?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
