What are the things you can do in the BMM layer?
Answer / madhu
We apply the business login in the BMM layer like creating new logical columns, Aggregation navigation, level based metrics, time series wizard, complex join.
| Is This Answer Correct ? | 2 Yes | 0 No |
How do you implement security using External Tables and LDAP?
How will you execute direct sql in obiee?
How we are going to decide which schema we are going to implement in the data warehouse?
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 you will do when your report is not fetching right data?
How will you do different types of narrative reports in obiee?
How online/offline mode impact development and delpoyment?
Define pipeline. Did you use it in your projects?
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?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What is connection pool and how many connection pools did you have in your last project?
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?