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 what task is 98% of the required work of a business analyst?
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)?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is Indexing? how did u implement indexing?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain how many universes can be created in a project?
What is difference between custom hierarchy and report based hierarchy?
Explain which versions are used in the bo dashboard work?
In banking domain how many Fact tables,Dimension table are present?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what would you consider as your biggest achievement and why?
Can more than 1 metric be applied on an analytic in business objects?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain what is the difference between slice and dice and cross tab report?