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

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


Please Help Members By Posting Answers For Below Questions

(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.

1276


What is a fantrap in business objects?

844


Can anybody tell me what are the tuning problems?

1813


What is package in BO

2958


what is the difference b/w the refresh and buffered data?

2034


What is the difference between the public object&schema object?

786


Explain when to use local filter and when to use global filter?

1162


any difficulitis have you phase while creating bo reports and how did u solve it

3189


Explain about alerts in bos, under what situation we need to use alerts?

775


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?

3359


Can we configure two instances of CMS pointing to two different CMS system databases?

1744


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

769


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1168


What is the profile and package?

2089


how get the grand total in master-detail report?

2021