WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
- 4 Answers
- 11216 Views
- Ericsson, Nokia, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hemanth
The situation leads to data inconsistency in reports so
there have to a lot of work round to resolve issues with
data. It leads to TRAPS, which might demands contexts,
specify data fetch tables and more based on business
requirement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / dipti
If your universe has multiple star schema, having more than
1 fact table is natural. The issue, however, is when we
have more than 1 fact table in one star schema formation.
This is because, that would lead to fact to fact join -
which is normally manay to many cardinality join. For more
details and to understand the concepts, read this:
http://www.dwbiconcepts.com/reporting-a-analysis/25-
business-objects/114-top-businessobjects-interview-
questions.html
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / hemanth
The situation leads to data inconsistency in reports so
there have to a lot of work round to resolve issues with
data. It leads to TRAPS, which might demands contexts,
specify data fetch tables and more based on business
requirement.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / guru
If your universe has multiple star schema, having more than
1 fact table is natural. The issue, however, is when we
have more than 1 fact table in one star schema formation
| Is This Answer Correct ? | 0 Yes | 0 No |
can we create aliases for every table beforehand? if yes whar are the disadvantages?
normally we get many contexts when resolving loops or traps,how do u take them to reports.
How can we use multiple data providers in a single report in business objects?
What are the advantages of Xcelsius & Crystal reports over Infoview?
What are steps to be taken care to create a good Universe?
Can we use unconnected lookup as dynamic lookup?
9.what are the multidimensional analyses
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
What are the major problems will occur while migrating to the one version to another version?
Difference between zabo and webi?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Teradata 
