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
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
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Which versions are used in the bo dashboard work?
What is aggregate table and aggregate fact table ... Any examples of both?
what is universe null
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
explain in detail about type 3?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How to schedule the report in b.o?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What are the data types present in bo? What happens if we implement view in the designer and report?
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 business requirement document and use case document.
Explain what are the measure objects?