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
Explain when to use local filter and when to use global filter?
Differences between business objects and web intelligence reports?
what will be the contents for a functional requirements specifications
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain difference between zabo and webi?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How to generate the report from excel sheet?
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
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
Explain is there any default username & pwd for bo designer & supervisor?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain in detail about type 2(scd),
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is data mart?
Explain in detail about type 1?