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
Answers were Sorted based on User's Feedback
Answer / siri
by using FORMAT NUMBER function we can change the numeric format
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gowthami
Right click on the column and do date formatting.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?
Can we do the slice and dice in webintellegence?
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports
Approximatly how many enduser can use the each bo project?
How do scheduling the report in BO XIR2? can you say what are they steps?
what is a Micro cube?
is there any limit for rows and columns in cross tab
When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??
How would I achieve Traffic Lighting in Business Objects
Explain how to execute the plsql procedure from the report by clicking with mouse?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?