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
- 6620 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
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is a bo repository?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
When we use aggregate awareness function in designer?
What is object stores?
in sap bi we have wad, then why we go for sap bo
What is the difference between business requirement document and use case document.
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
how to prepare the documentation in business objects and where to get the requirement?
Can more than 1 metric be applied on an analytic in business objects?
What is the dense rank?
Explain what are the steps to do to use alerts in bo?
Explain the difference between union and group?
how many reports have u created ? explain a few.
Explain what sort of existing documents should business analysts refer to when starting on a new project?
