can any one say me exactly when and where alias and context
are used in resolving a loop.
If possible try to give me a scenario also.
Answers were Sorted based on User's Feedback
Answer / vams_gk
when a schema contains a loop u should create alias
table..alias concept not only for loops.we can also use
in fantraps.
coming to context :when u run two sql statements as a
singlestatemnt we will go for context detection process.
in traps we can choose contexts.
traps are two types chasam trap and fan trap.
these traps are situvation oriented
relation betwen muliple tables like this:
--------------------------------------0-
chasam trap :1:M:1
fan trap :1:M 1:M
really if u want o see the context how to look
tools->automatic detection----.detect contexts in BO XIr2
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiran
small correction with chasm traps..its two one ends to
single table so that would be M:1:M relation between 3
tables..
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sivakumar
Resolving loop: Alias is the best method
Fan trap: Alias.
Chasm Trap: Context.
Is This Answer Correct ? | 0 Yes | 1 No |
What are the Input and Output Context Operators.
how can u find the granularity in fact table
What are the differences between webi and deski of XI R2 not the earlier versions
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
What is sdlc in bo?
What is the difference in creating filters in designer and business objects?
how get the grand total in master-detail report?
What is the dense rank?
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
How to delete the duplicate colums in a sql table ?
what is maximum scope of analysis --> can we define more than 3 levels?