i have 2 fact and 2 dimension tables in my universe . my
question is how get the data with two fact tables in a report?
Answers were Sorted based on User's Feedback
Answer / sivakumar
Two Fact tables can be Joied through an confirmed dimension.
So any of the dimension should have the feature of
confirmed dimension.
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / sreedhar
There should be a dimension that will connect those two
fact tables which we call it as "Confirmed Dimension"
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / pradeep
Create a Short cut join between the two fact tables in the
universe.
Is This Answer Correct ? | 2 Yes | 8 No |
When we use aggregate awareness function in designer?
when we go for snow flake schema rather than star schema ?
There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?
What are the join problems comes appart from loop,chasm & fan Traps
How to get two dimension objects in a same block which are comming from two different contexts ?
what is isolated joins in check integrity
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
How to create an popup in the WEBI report if the report is showing partial result?
difference between web intelligence,crystal reports and desktop intelligents
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
define universe parameters?
what is confirm dimension ?