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 the difference between union and group?
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 ?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain what three things do you consider to be the most important factors for a manager?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
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?
how get the grand total in master-detail report?
What three things do you consider to be the most important factors for a manager?
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.
what is the difference b/w the refresh and buffered data?
What is report template in b.o?
Explain what is the difference between business requirement document and use case document.
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...
Explain what is the difference between slice and dice and cross tab report?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?