1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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.

Question Posted / vams_gk

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


Please Help Members By Posting Answers For Below Questions

What are the steps to do to use alerts in bo?

635

8. How much supervision have you typically received in your previous job?

1836

Explain what task is 98% of the required work of a business analyst?

604

Explain the difference between detect alias and detect context?

629

How to open a universe with out using the Designer ??

6622




What is difference between webi and infoview?

619

Explain is data mart?

597

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

1433

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4326

Is there any other repository domains rather than universe, security, document?

602

can anybody tell me about complicated object you have created

2757

Which versions are used in the bo dashboard work?

603

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1830

Give some information on report bursting?

573

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

1404