WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
Answer Posted / 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 |
Post New Answer View All Answers
Can we Save (save as) WEBI Doc as DESKI?
What is the difference in creating filters in designer and business objects?
What is the difference between slice and dice and cross tab report?
What is the difference between the public object&schema object?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How we drill up week to month?
Explain is there any other repository domains rather than universe, security, document?
What is difference between custom hierarchy and report based hierarchy?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to restrict password to a user while sending a document in .pdf format
Differences between business objects and web intelligence reports?
U r project in which stage in implementation?