Name - Name of the dimension
Type - supports three types of dimensions:
SQL Panel - will be visible when "User Defined Query" is selected
Table Alias - Table Alias to be used for SQL
Partition Column - can be used to improve performance of a ROLAP report when fact data are partitioned into multiple fact tables. The partition table will be used ONLY when there is no aggregation that can be used.
For example, "Foodmart 2000" database has sales data partitioned into two physical tables: sales_fact_1997 and sales_fact_1998. Although, the fact query can be build to union both tables that would not be efficient and slow. The partition column can specify which table needs to be accessed when a time filter is applied. The partition query in the case of Foodmart example could be expressed as the following query:
For this example, part_col can be selected as the Partition Column.
Join Columns - Columns that should be used to join fact to the dimension
Slowly Changing Dimension - This information is used by report filter to limit the members for the selected day. In case no date is selected in another filter all members will show up.
