Interested to Buy Any Domain ? << Click Here >> for more details...
What is a loop? How can we overcome?
- 5 Answers
- 9853 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nareshkumar
A loop is a set of joins that defines a closed path through
a set of tables in a schema. Loops occur when joins form
multiple paths between lookup tables.
Loops can be solved by using aliases or contexts.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srikanth
Loop is one of the join path problem that arise when
designing the universe.While setting up joins between
tables,a closed path may occur between set of joins.This
scenario is called Loop.Because of this you will get
incorrect results in report.
You can avoid this problem by creating alias table or
Centext(define path for set of joins to follow)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / subhash
Loop is nothing but a closed circular flow; it can be
overcome by making use of Alias and Context.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vams_gk
loop is a closed path between end to end.continuous floe of
data.creation of alias table is solution to resolve loops
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venukrishina
loops an exist when joins between tables forms continous paths.
loops are produce a cartesign product result(less number).
in bo we have 3 methods for resolve loops.
1.aliase
2.context
3.short cut joins
aliase:an aliose is exact duplicate of the orginal table with new name of the both table
context:context is a set of joins to satisfies to one business requiremt
short cut joins : is an alernative path between two table
| Is This Answer Correct ? | 0 Yes | 0 No |
how u restrict the values?to display 5 values insted of 10 values?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
Explain when to use local filter and when to use global filter?
generally how do we get information for creating universes and reports
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
how to do scheduling in desktop intelligence in BO XI R2
1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Teradata 
