Monday, August 30, 2010

OBIEE Admin Tool

OBIEE Administration tool is where all the back end process of reporting is done. This is the place where business logic, security etc is implemented on physical data. RPD is a file containing all the metadata of the logic/security etc is stored. It basically has 3 layers.

1) Physical Layer: This is where connection pools are created and physical tables are imported in to rpd from datawarehouse.

2) BMM layer: Here actual business logic is implemented on logical tables and it is the best practice to join tables using complex join in BMM layer.

3) Presentation layer: This layer is the visible to the user in the front end to create reports/requests. Security is implemented in this layer.

The flow is Physical>BMM>Presentation. We will discuss each layer in the coming posts.

No comments:

Post a Comment