when to go for alias and when to go for contexts

Answer Posted / vams_gk

Alias,contexr these two we can used to resolve join
problems.whemn we found a loop in our scheema design we
will go for alias,when we are able to run two sql
statements as a single query we go for contexts.

we have option for these in our universe tool bar window

tools-->auto detection--.context or loop

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between union and group?

632


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

639


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1614


what is universe null

1991


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

999






What is the functional & architectural differences between business objects and web intelligence reports?

561


Explain the difference between detect alias and detect context?

629


What is the difference between the public object&schema object?

577


What is top business?

567


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

1910


What is the difference between datawarehousing and businessintelligence?

621


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1623


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 ?

5975


What is aggregate table and aggregate fact table ... Any examples of both?

614