2.What is loop? How resolve the loop?explain it?
Answer Posted / vidya
Loop is a Multiple paths between the tables selected in
queries. Or you can say loop is a closed path structure.
Loops can be resolved by…
ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you
are using 2 different tables.
CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose
in a loop.
•BO prompts the user to indicate the correct perspective
(relevant path) for the query.
When to Alias
A loop with a single lookup table should be resolved by an
alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to
it
| Is This Answer Correct ? | 66 Yes | 4 No |
Post New Answer View All Answers
Explain what are the measure objects?
Give some information on report bursting?
Explain when we use aggregate awareness function in designer?
What is the difference in creating filters in designer and business objects?
Explain what is the difference between slice and dice and cross tab report?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
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 are the steps to do to use alerts in bo?
Did you face any problems while creating reports? Name? Solutions?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What are the join problems comes appart from loop,chasm & fan Traps
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?
Explain about a time when you discovered a more efficient way to do a work task?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?