Answer Posted / chinna
A Cartesian product tends to generat a large number of
rows, and the result is rarely useful.You should always
include a valid join condition in a where clause,unless you
have a specific need to combine all rows from all tables.
| Is This Answer Correct ? | 12 Yes | 10 No |
Post New Answer View All Answers
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!!!
Differences between business objects and web intelligence reports?
what is universe null
what is document design in boxi,have u participate in that
Explain when to use local filter and when to use global filter?
Can anybody tell me what are the tuning problems?
how get the grand total in master-detail report?
What is the dense rank?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain how to execute the plsql procedure from the report by clicking with mouse?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain about a task that really tested your analytical abilities?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
what will be the contents for a functional requirements specifications
what is the difference b/w the refresh and buffered data?
