WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
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 |
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
How many built-in objects are created in Business Objects repository?
What is the use of BO SDK?
What are the Users and User groups?
how do u implement dense rank in bo reports?
What is the difference between datawarehousing and businessintelligence?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is BOMain.Key?
Explain what are the steps to do to use alerts in bo?