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 are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
Explain how many universes can be created in a project?
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,
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Can we have multiple domains?
If there is no common dimension? Is it possible to combine two different dataproviders?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
5.what is slowly changing dimension ?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is the difference between user and versatile user?