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
- 7282 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 |
Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
What is top business?
What sort of existing documents should business analysts refer to when starting on a new project?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
what happens if cardinalities are not resolved?
If there is no common dimension? Is it possible to combine two different dataproviders?
explain in detail about type 3?
What is ment by For each For all function. In which case we use the option in BO?
I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.
How to implement LDAP authentication in BOE
Teradata 
