OBIEE â Dimension Hierarchies Hierarchies is a series of many-to-one relationships and can be of different levels. A Region hierarchy consists of: Region → Country → State → City → Street. Hierarchies follow top-down or bottom-up approach. Logical dimensions or dimension hierarchies are created in BMM layer. There are two types of dimensional hierarchies that […]
Author Archives: user
OBIEE â Multiple Logical Table Sources When you drag and drop a column from a physical table that is not currently being used in your logical table in BMM layer, the physical table containing such column gets added as a new Logical Table Source (LTS). When in BMM layer, you use more than one table […]
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, […]