please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
1 4312please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
2 4917If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
1617Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
1 3191Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?
7 9837what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
IBM,
2 6348solve the following loops? dimension table fact table fact table dimension table link will be there between tables?
4 5892Post New Business Objects Questions
What is a bo repository?
Did you face any problems while creating reports? Name? Solutions?
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.
How to generate the report from excel sheet?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain when we use aggregate awareness function in designer?
Explain the data types present in bo and what happens if we implement view in the designer and report?
what is the difference b/w the refresh and buffered data?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain how to execute the plsql procedure from the report by clicking with mouse?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Can we create universe with no cache??