WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
- 4 Answers
- 10598 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 |
what is the difference between Ranking and sort-out in bo?
Explain what are the steps to do to use alerts in bo?
Can We customize the Business Object infoview in BO?
What are the steps to taken care to improve the Report performance?
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
when you have three fact table and there is no relationship between them. How you will tackle the issue.
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
what are the day to day activities of BO administrator ?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
What are the steps to do to use alerts in bo?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain is there any default username & pwd for bo designer & supervisor?
Teradata 
