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 |
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
What are Alerter, Filters, Breaks and Conditions?
What is a Set?
how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?
If there is no common dimension? Is it possible to combine two different dataproviders?
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
what is performance tunning in BO in report level& designer level?
Analysis in business objects?
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
How to link one location universe to other location universe