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
What Is The Difference Between Oltp And Olap?
how to prepare the documentation in business objects and where to get the requirement?
What is report template in b.o?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is the difference in creating filters in designer and business objects?
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?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
what are the tables used in health care domain project and columns used in report?
how get the grand total in master-detail report?
Explain about alerts in bos, under what situation we need to use alerts?
Explain in detail about type 2(scd),
Can we configure two instances of CMS pointing to two different CMS system databases?
How many universes can be created in a project?