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 […]
Category Archives: obiee
OBIEE â Aggregates Aggregations are used to implement query performance optimization while running the reports. This eliminates the time taken by query to run the calculations and delivers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table. How Aggregation Works in OBIEE? When you execute a […]
OBIEE â Calculation Measures Calculated measures is used to perform calculation of facts in logical tables. It defines Aggregation functions in Aggregation tab of logical column in the repository. Create New Measure Measures are defined in logical fact tables in repository. Any column with an aggregation function applied on it is called a measure. Common […]