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
- 6093 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can Bo generates the Report from the cubical data Explain?
Can we create universe with no cache??
What is the difference between condition & filter?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the difference between the public object&schema object?
How we drill up week to month?
What is package in BO
Explain about a time when you discovered a more efficient way to do a work task?
Give some information on report bursting?
In banking domain how many Fact tables,Dimension table are present?
Explain what task is 98% of the required work of a business analyst?
what is universe null
how many reports have u created ? explain a few.
Explain what is the difference between slice and dice and cross tab report?
