What are the different types of variables in obiee 11g? Explain
Why do we have multiple LTS in BMM layer? What is the purpose?
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?
How we are going to decide which schema we are going to implement in the data warehouse?
What are global filter and how they differ from column filter?
How will you create report from two subject areas
How will change port of obiee answers?
Can you use outer join in BMM layer?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
If you want to create new logical column where will you create (in repository or dashboard) why?
What are the different layers of obiee repository?
How do implement event polling table?
How will you enable or disable caching in the system level and table level?