Aliases and Contexts Which once will give the better
performence when resolve the loops?

Answer Posted / narender reddy

Join path: a join path is a series of joins that a query can use to access data in the tables linked by the joints. Join path problems can arise from the limited way that lookup and fact tables are related in a relational data base. The three major join problems that you encounter when designing a schematic are the following:
1. Loops
2. Chasm traps
3. Fan traps

Queries can return incorrect results due to the limitations in tha way that joins are performed in relational databases.

Loops: joins between tables form a continues path
Solved by: shortcut join(3 tables), aliases( more than 3 tables with one fact table), context( more than 3tables with more than one fact table),

Chasm traps: many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called as a chasm trap.
Solved by: context, creating multiple SQL statements for each measure, creating multiple universes( webi only),

Fan traps: a one to many join links a table which is in turn linked by a one to many join. This type of serial many to one joins can lead to a join path problem called a fan trap.
Solved by: alias, using multiple SQL statements for each measure, creating the context using the alias.

Aliases: An alias is a table that is a exact duplicate of the original table, with a different name. The data in the table is exactly the same as the original table. Using aliases resolve loops and fan traps.

Context: context is a collection of joins which provide a valid query path for user to generate SQL. Using contexts we can resolve loops and chasm traps and assisting in some solutions of fan traps.

-------- when we use alias to resolve the loop we are using extra duplicate table, if we have more tables in schema it will decrease the performance so alias always decrease the performance compair to context.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1559


what are the tables used in health care domain project and columns used in report?

4014


What would you consider as your biggest achievement and why?

583


Explain which versions are used in the bo dashboard work?

614


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

975






What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

581


How were the reports scheduled and how to resolve unexecuted documents?

2176


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

667


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

554


What three things do you consider to be the most important factors for a manager?

569


Explain difference between zabo and webi?

628


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3109


can anybody tell me about complicated object you have created

2727


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3820


How would you format some text using css to be verdana and bold?

638