Interested to Buy Any Domain ? << Click Here >> for more details...
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
- 1 Answers
- 4282 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu
Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to hide certain columns from a user?
What is a bridge table ?
How we are going to decide which schema we are going to implement in the data warehouse?
How will you do sort in reports in obiee.
Can you run multiple rpd’s in a single obiee instance?
What is a table alias in obiee 11g? Where and how will you create it?
What are global filter and how they differ from column filter?
What are different types of joins that are possible in obiee rpd?
What are the different types of security you have worked in obiee?
How will you create report from two subject areas
can you change the location of the obiee repository?
How many bi services node can be clustered together?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
what is guided navigation?
Explain the architecture of obiee and what each components do?
