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.
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
What we need to discuss with designer before starting the universe designing.
What is the profile and package?
Explain difference between zabo and webi?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain in detail about type 1?
Did you face any problems while creating reports? Name? Solutions?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Is there any other repository domains rather than universe, security, document?
Explain what is the difference between slice and dice and cross tab report?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
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
Explain what are the steps to be taken to schedule the report?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain the difference between union and group?