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 |
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
Explain what are the measure objects?
how do we apply sql query on selected variables?
How to get top 5 rows of a selected column?
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
Explain how many universes can be created in a project?
what is fantrap and chasmtrap ?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
limitaions of cross tab ?