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
- 4528 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
What is write-back in obiee ?
How will you create interactive dashboards ?
Can you run multiple rpd’s in a single obiee instance?
How the users created differs from rpd/answers/dashboards level?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How to startup obiee in linux?
How we are going to decide which schema we are going to implement in the data warehouse?
What is clusterservices in obiee ? Why its used?
Have you created hierarchy in obiee. If so where and how?
What are global filter and how they differ from column filter?
can you change the location of the obiee repository?
What are the different types of variables in obiee 11g? Explain
How will you do different types of narrative reports in obiee?
What you will do when your report is not fetching right data?
How will you do sort in reports in obiee.
