Optimize 10.11 | webMethods Optimize Documentation | Administering webMethods Optimize | Optimize Schema | Dimension Tables (BAM_DIM_<Dimension Name>_V1)
 
Dimension Tables (BAM_DIM_<Dimension Name>_V1)
Dimension tables are linked to Fact tables through a foreign key in the Fact table. The specific column that connects the Fact table to the dimension is named after the Dimension table name. For example, a dimension called Region would have a Dimension table called BAM_DIM_REGION_V1. Any Fact table that uses this dimension would have a column named REGIOIN_DIM that contained a value relating back to the Dimension table.