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



i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql conn..

Answer / siri

by using FORMAT NUMBER function we can change the numeric format

Is This Answer Correct ?    2 Yes 0 No

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql conn..

Answer / gowthami

Right click on the column and do date formatting.

Is This Answer Correct ?    0 Yes 0 No

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql conn..

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

Post New Answer

More Business Objects Interview Questions

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

2 Answers   Hexaware,


what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,


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?

2 Answers  


What Is Snow Flake Schema?

0 Answers   Informatica,


what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,


Explain the difference between union and group?

0 Answers  


IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?

2 Answers   Clover, Rolta,


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

1 Answers   TCS,


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

0 Answers  


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.

1 Answers  


how u restrict the values?to display 5 values insted of 10 values?

4 Answers  


how get the grand total in master-detail report?

0 Answers   Patni,


Categories