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 |
Do you know about Initialization Blocks? Can you give me an example where you used them?
What is a bridge table ?
Can you run multiple rpd’s in a single obiee instance?
Explain the architecture of obiee and what each components do?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What is scd type 1 and 2.
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 is guided navigation?
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 complex join, and where it is used?
How to hide certain columns from a user?
What are the things you can do in the BMM layer?