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 |
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
what is the difference between Ranking and sort-out in bo?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
What Is Snow Flake Schema?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
Explain the difference between union and group?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
any difficulitis have you phase while creating bo reports and how did u solve it
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
how u restrict the values?to display 5 values insted of 10 values?
how get the grand total in master-detail report?