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
Did you face any problems while creating reports? Name? Solutions?
how to create reports on screech?
What are the join problems comes appart from loop,chasm & fan Traps
Explain what are the steps to be taken to schedule the report?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain how to schedule the report in b.o?
What is a fantrap in business objects?
Explain about alerts in bos, under what situation we need to use alerts?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what three things do you consider to be the most important factors for a manager?
Explain about a time when you discovered a more efficient way to do a work task?
Explain when we use aggregate awareness function in designer?
Explain the data types present in bo and what happens if we implement view in the designer and report?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
How many universes can be created in a project?