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 |
what is variable ?
Can we get the data from two different databasess in reporting level?
Can anybody tell me about issues faced while creating universe. thanks in advance
Can Bo generates the Report from the cubical data Explain?
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
What is top business?
What type of schemas did you use in your project?Andwhy did you use that schema
which is the best way to resolve loop context r alias why?
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
What sort of existing documents should business analysts refer to when starting on a new project?
How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?
I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process