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 |
How will you port changes for dashboards,reports,rpd from development to production?
What is a table alias in obiee 11g? Where and how will you create it?
Explain the architecture of obiee and what each components do?
what is guided navigation?
How will you execute direct sql in obiee?
What is time series wizard? When and how do you use it?
Can you bypass siebel analytics server security ?if so how?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How to enable drills in a given column data?
What are the different log files in obiee?
What are global filter and how they differ from column filter?
Have you created hierarchy in obiee. If so where and how?