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 the difference between union and group?

834


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1780


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

2852


Explain what three things do you consider to be the most important factors for a manager?

761


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2188


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

774


how get the grand total in master-detail report?

2012


What three things do you consider to be the most important factors for a manager?

836


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3237


what is the difference b/w the refresh and buffered data?

2025


What is report template in b.o?

768


Explain what is the difference between business requirement document and use case document.

781


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1935


Explain what is the difference between slice and dice and cross tab report?

829


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

923