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


Please Help Members By Posting Answers For Below Questions

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

1636


What is the difference between datawarehousing and businessintelligence?

864


What is the difference between slice and dice and cross tab report?

844


Explain the difference between union and group?

833


in sap bi we have wad, then why we go for sap bo

3054


How to create Index to the table in the universe designer and how it improves the Query performence

2341


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4178


what is universe null

2197


What is the difference between the public object&schema object?

772


What Is Snow Flake Schema?

890


Can we create universe with no cache??

2177


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1854


How many universes can be created in a project?

789


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

839


What is difference between custom hierarchy and report based hierarchy?

792