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 |
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
What is Array bind size in universe? Plz
How can you access your repository with different user profiles?
What is meant by data federator and what is the use of it?
How you get the requirement from client?
is there any limit for rows and columns in cross tab
Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?
What is the difference b/w the simple Universe and Complex Universe?
what are the complex reports you have created. Tell me with example?
What are the differences between webi and deski of XI R2 not the earlier versions
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
What are the join problems comes appart from loop,chasm & fan Traps