OBIEE – Level-Based Measures Level-based measures are created to perform calculation at a specific level of aggregation. They allow to return data at multiple levels of aggregation with one single query. It also allows to create share measures. Example Let us say there is a company XYZ Electronics which sells its products in many regions, […]

OBIEE – Testing Repository You can check the repository for errors by using the consistency checking option. Once it is done, next step is to load the repository into Oracle BI Server. Then test the repository by running an Oracle BI analysis and verifying the results. Go to File → click on Check Global Consistency […]

OBIEE – Business Layer Business Layer defines the business or logical model of objects and their mapping between business model and Schema in the physical layer. It simplifies the Physical Schema and maps the user business requirement to physical tables. The business model and mapping layer of OBIEE system administration tool can contain one or […]