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
- 8473 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is a fantrap in business objects?
Can anybody tell me what are the tuning problems?
What is package in BO
what is the difference b/w the refresh and buffered data?
What is the difference between the public object&schema object?
Explain when to use local filter and when to use global filter?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain about alerts in bos, under what situation we need to use alerts?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Can we configure two instances of CMS pointing to two different CMS system databases?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is the profile and package?
how get the grand total in master-detail report?
