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
- 4337 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to sort columns in rpd and web?
What is time series wizard? When and how do you use it?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
What is level based metrics?
What is the end to end life cycle of OBIEE?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What is data level security?
How will you enable or disable caching in the system level and table level?
What is write-back in obiee ?
What are different types of variables?
Can you have multiple data sources in OBIEE?
Teradata 
