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.
- 3 Answers
- 6108 Views
- I also Faced
- E-Mail Answers
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 |
how can we build one report from two data bases
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
what is data cubes??
Explain what is the difference between business requirement document and use case document.
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
How to Implement the the Built-in Strategy Script in BO Designer?
How to hide the table s in webi?can any one tell me plzzzzzzzz
How to get top 5 rows of a selected column?
If there is no common dimension? Is it possible to combine two different dataproviders?
What is BOMain.Key?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
Teradata 
