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
What would you consider as your biggest achievement and why?
how to create reports on screech?
Explain in detail about type 2(scd),
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to open a universe with out using the Designer ??
what is xcelsius architecture?
what will be the contents for a functional requirements specifications
can anybody tell me about complicated object you have created
When we use aggregate awareness function in designer?
What Is Snow Flake Schema?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain about alerts in bos, under what situation we need to use alerts?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?