What is complex join, and where it is used?
Answer / madhu
To join a dimension table and fact table in BMM layer we use a complex join.
Is This Answer Correct ? | 1 Yes | 0 No |
Have you created hierarchy in obiee. If so where and how?
Explain the architecture of obiee and what each components do?
Do you know about Initialization Blocks? Can you give me an example where you used them?
How will you do different types of narrative reports in obiee?
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?
How many bi services node can be clustered together?
How do you know which report is hitting which table, either the fact table or the aggregate table?
What is clusterservices in obiee ? Why its used?
How the users created differs from rpd/answers/dashboards level?
Can you migrate the presentation layer to a different server.
can you change the location of the obiee repository?
What is the end to end life cycle of OBIEE?