How do you define the relationship between facts and dimensions in BMM layer?
Answer / madhu
Using complex join we can define relationship between facts and dimensions in BMM layer.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the architecture of obiee and what each components do?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How will you do different types of narrative reports in obiee?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is logging level? Where can you set logging levels?
Define repository in terms of 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 is clusterservices in obiee ? Why its used?
How to get sql from obiee for reports?
What are the different types of variables in obiee? Explain