Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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 we need to discuss with designer before starting the universe designing.

2245


What is the profile and package?

2288


Explain difference between zabo and webi?

1095


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2425


Explain in detail about type 1?

1587


Did you face any problems while creating reports? Name? Solutions?

3686


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

2047


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)?

1168


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

1044


Explain what is the difference between slice and dice and cross tab report?

1071


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1034


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

1870


Explain what are the steps to be taken to schedule the report?

1103


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2320


Explain the difference between union and group?

1094