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 ?||1 Yes||0 No|
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
What are different types of variables?
How do i disable cache for only 2 particular tables?
Can you have multiple data sources in OBIEE?
How do you define the relationship between facts and dimensions in BMM layer?
Why do we have multiple LTS in BMM layer? What is the purpose?
Can you bypass siebel analytics server security ?if so how?
What is connection pool and how many connection pools did you have in your last project?
Can you use physical join in BMM layer?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?