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 |
Can we link the oracle and excel universess?
Draw the architecture of traps?
What is the use of BO SDK?
How to make alternative rows red and green in WebI Report?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
what is the use of merge option in webi reports? explain with example?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
normally we get many contexts when resolving loops or traps,how do u take them to reports.
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
What is Array bind size in universe? Plz
Explain how we drill up week to month?
when you have three fact table and there is no relationship between them. How you will tackle the issue.