Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is maximum number of promts we can give in a BO report?

1 Answers   Patni,


working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.

1 Answers  


What are the different types of connections?Explain?

1 Answers   Wipro,


Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,


Explain how we drill up week to month?

0 Answers  


How many ways you can restrict data in business objects?

5 Answers   TCS,


What is broad cast agent?

5 Answers  


When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,


if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  


@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,


What are the different types of Filters available in BUSINESS OBJECTS?

3 Answers  


wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

3 Answers   Target,


Categories