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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the steps to be taken to schedule the report?

840


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

1827


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

814


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1155


Explain in detail about type 2(scd),

815


What is the profile and package?

2070


Explain how to schedule the report in b.o?

762


How to open a universe with out using the Designer ??

7045


Is there any other repository domains rather than universe, security, document?

807


What is a bo repository?

794


Explain in detail about type 1?

929


can anybody tell me about complicated object you have created

2974


how to create metric universe ?

2091


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

800


Explain is data mart?

760