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

Answer Posted / vasanth

alias is used when two dim tables and one fact table are there in the loop ,alias is used for one dim table which has less outer joins.

Context are used when there are 2 fact tables and one dim table in the loop,we create context for one join between one fact and dim in the loop.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is there any other repository domains rather than universe, security, document?

572


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1485


How we drill up week to month?

609


What is a fantrap in business objects?

570


What are all difference between business objects 6.5 and xi r2?

589






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

2589


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1527


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1467


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

655


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

496


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1768


what will be the contents for a functional requirements specifications

1774


how many reports have u created ? explain a few.

1648


Explain difference between zabo and webi?

638


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)?

532