BIEE dimension table

(1) Create aliases (table-new Object-alias) in the physical layer for the table

(1) Create dimensions in the Business layer (table-Create logical dimension--"dimension based on level hierarchy")

Drillthrough is the function of the dimension itself

General information in the name: department

Keyword action: Determining unique values and determining what to display

Aggregation method: Select a table of the field, double-click, select Aggregation, the aggregation rules in accordance with their own needs to choose

Aggregation: is a generic term for conversions

(3) In the presentation layer to change the table name to Chinese, and add "Dim" better to indicate that the table is a dimension table, labeled "FO" is the fact table

(4) Login BIEE background address biee not drilled in

BIEE dimension table