Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7317 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 |
what is prompt? Cascading prompt? Syntax
What is meant by ZABO and FC(full-client)?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
how to make a report avilable to other users?
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
what is Scope of Analysis
what r the disadvanges in boxir2
what is the difference b/w the refresh and buffered data?
Explain about alerts in bos, under what situation we need to use alerts?
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
How to link two different universes ?
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
Teradata 
