✍ Kashif M
Trends

Sunday, 17 November 2013


Use of BMM Layer in OBIEE 11g


By on November 17, 2013



1. Use to create new logical Columns.

2. Can create complex joins, outer joins, and inner joins.

3. Can create Time series functions, aggregate functions of measures.

4. Can create Level Based Measures (LBM).

5. Can create dimensional hierarchy.

6. Aggregate persistence wizard can be done in BMM layer.

7. Can create new logical table sources (LTS).

8. Minimize the use of Snow-Flakes

9. Whenever you do Consistency Check, Right Click the Changed Business Model Object and go for Check Consistency rather than using the Global Consistency Check. This will minimize the time needed for Consistency Check

10. Minimize the use of Conditional Checks and ‘CASE WHEN’ usage in the formula of Logical Columns. This will affect performance. Instead make proper use of the where clause Content filter of the LTS if the condition applies to all the columns/measures in the logical table

Kashif
mkashu: Use of BMM Layer in OBIEE 11g
Review : Kashif | Kashif
Update: November 17, 2013 | Rating: 4.5

Comment for "Use of BMM Layer in OBIEE 11g"

0 comments

Post a Comment