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 |
How will you do different types of narrative reports in obiee?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What is the difference between Data Level Security and Object Level Security?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What are the different log files in obiee?
How will change port of obiee answers?
How do you define the relationship between facts and dimensions in BMM layer?
What is star schema and snowflake schema?
What are the challenges you faced while making of reports?
How do you work in a multi user environment? What are the steps?
What is level based metrics.how will you create it?
How will you create report from two subject areas