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

Explain what are the measure objects?

0 Answers  


Can We customize the Business Object infoview in BO?

2 Answers  


I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps

17 Answers   IBM,


How many built-in objects are created in Business Objects repository?

2 Answers  


WHAT IS CARDINALITIES OF JOIN?

3 Answers  






HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,


U r project in which stage in implementation?

0 Answers   Accenture,


what is crystal reports?how to migrate them?

2 Answers   IBM,


i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,


How can you first report in Business Objects by using broadcast agent?

0 Answers   Ness Technologies, Wipro,


what is the source for metrics?

2 Answers  


what is isolated joins in check integrity

2 Answers   Accenture, Polaris,


Categories