Define repository in terms of OBIEE?
Answer / madhu
Repository stores the Meta data information. The extension of the repository file is “.rpd”. With OBIEE Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business models. OBIEE Server can access multiple repositories
Repository is divided into three layer,
1. Physical – Represents the data Sources
2. Business – model the Data sources into Facts and Dimension and apply business logic
3. Presentation – Specifies the user’s view of the data rendered in OBIEE answers client
Is This Answer Correct ? | 0 Yes | 0 No |
What is connection pool and how many connection pools did you have in your last project?
How do you know which report is hitting which table, either the fact table or the aggregate table?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
What are the different types of variables in obiee 11g? Explain
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
What is complex join, and where it is used?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What are the different types of security you have worked in obiee?
Can you use outer join in BMM layer?
How will you create interactive dashboards ?
How do you implement security using External Tables and LDAP?
What is level based metrics.how will you create it?