OBIEE - Mini-Dimensions

Mini-Dimensions :

1. Mini-dimension tables include combinations of the most queried attributes of their parent dimensions.
2. They must be small compared to the parent dimension,so they can include only columns that have a relatively small number of distinct values.
   

Note : Mini-dimensions are joined both to main fact table and to

aggregate tables.

Used to : 

• They improve query performance because BI Server will often use this small table instead of the big parent dimension.

• They increase the usage of aggregate tables. Due to the level of aggregation, aggregate tables cannot be joined to the parent dimension. But they can be joined to the mini-dimension instead. It allows reports to use the aggregate table even if they use some columns from the corresponding dimension.

NeXt Time ..