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
any difficulitis have you phase while creating bo reports and how did u solve it
What is the difference between absolute and relative div positioning?
What are the steps to do to use alerts in bo?
(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.
Which versions are used in the bo dashboard work?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is difference between custom hierarchy and report based hierarchy?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain what three things do you consider to be the most important factors for a manager?
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
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
When we use aggregate awareness function in designer?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is a bo repository?
What is top business?