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
- 4415 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 clusterservices in obiee ? Why its used?
How will you do different types of narrative reports in obiee?
How will change port of obiee answers?
How many bi services node can be clustered together?
What is time series wizard? When and how do you use it?
What is level based metrics.how will you create it?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
From where u get the logical query of your request?
What you will do when your report is not fetching right data?
What is a table alias in obiee 11g? Where and how will you create it?
What is star schema and snowflake schema?
How to get sql from obiee for reports?
How will you go about adding additional column to the repository in the presentation layer?
How to hide certain columns from a user?
what is guided navigation?
