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
- 7891 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
What would you consider as your biggest achievement and why?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
When we use aggregate awareness function in designer?
What is difference between custom hierarchy and report based hierarchy?
What is thumbnail?
Is there any other repository domains rather than universe, security, document?
How many universes can be created in a project?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
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?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
U r project in which stage in implementation?
Explain what would you consider as your biggest achievement and why?
what is document design in boxi,have u participate in that
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
