when to go for alias and when to go for contexts
Answers were Sorted based on User's Feedback
Answer / saloni
We use alias or context wenever we encounter a loop .If
there are more than one fact table use a context or if only
one fact table use alias
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / yandapalli.prasad
When you have multiple fact tables then we have to go for
Contexts, there is no othergo. In the other situations we
can use aliases.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / 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 |
Answer / manasa
Alias,Contexts are used to resolve join path problems.
| Is This Answer Correct ? | 0 Yes | 0 No |
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
What is shortcut join?could give any one example?
why measure objects are semantically dynamic?
how to test reports in businessobjects?
What is the link option in the reporting Environment?
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
how to connect one to one report? Explain with example?
What is package in BO
Draw the architecture of traps?
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,