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?
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 |
Define repository in terms of OBIEE?
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?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What is logging level? Where can you set logging levels?
What is clusterservices in obiee ? Why its used?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
How will you execute direct sql in obiee?
What are the different types of variables in obiee? Explain
How will you enable or disable caching in the system level and table level?
How we are going to decide which schema we are going to implement in the data warehouse?
What is write-back in obiee ?
How do implement event polling table?