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
- 4418 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 are different types of joins that are possible in obiee rpd?
What is write-back in obiee ?
How the users created differs from rpd/answers/dashboards level?
What are the different log files in obiee?
How will you do sort in reports in obiee.
What is authentication? How many types of authentication.
What you will do when your report is not fetching right data?
What is scd type 1 and 2.
How will you execute direct sql in obiee?
How to startup obiee in linux?
How will you enable or disable caching in the system level and table level?
From where u get the logical query of your request?
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?
Can you run multiple rpd’s in a single obiee instance?
How will you port changes for dashboards,reports,rpd from development to production?
