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 […]
Category Archives: obiee
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 […]
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 […]