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
any difficulitis have you phase while creating bo reports and how did u solve it
What is object stores?
What are the steps to be taken to schedule the report?
8. How much supervision have you typically received in your previous job?
how get the grand total in master-detail report?
Explain 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 is data mart?
What Is Snow Flake Schema?
How were the reports scheduled and how to resolve unexecuted documents?
Can anybody tell me what are the tuning problems?
What are the steps to do to use alerts in bo?
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 create metric universe ?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
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 ?