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

Answer Posted / siri

by using FORMAT NUMBER function we can change the numeric format

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain when to use local filter and when to use global filter?

595


Differences between business objects and web intelligence reports?

651


what will be the contents for a functional requirements specifications

1778


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2400


Explain difference between zabo and webi?

645






Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2596


How to generate the report from excel sheet?

578


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4438


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1569


Explain is there any default username & pwd for bo designer & supervisor?

592


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1688


Explain in detail about type 2(scd),

588


Explain the data types present in bo and what happens if we implement view in the designer and report?

556


Explain is data mart?

584


Explain in detail about type 1?

648