1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

2.What is loop? How resolve the loop?explain it?

Question Posted / vidya

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

can anybody tell me about complicated object you have created

2754

What Is Snow Flake Schema?

666

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!!!

1754

What sort of existing documents should business analysts refer to when starting on a new project?

622

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

603




What is Indexing? how did u implement indexing?

1819

How can you first report in Business Objects by using broadcast agent?

2596

how to create reports on screech?

2078

How to restrict password to a user while sending a document in .pdf format

1861

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

681

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

623

Explain what are the steps to do to use alerts in bo?

615

Explain what are the steps to be taken to schedule the report?

639

Explain what would you consider as your biggest achievement and why?

578

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

510