Dimensions
>
Manually adding previous value columns
Manually adding previous value columns
If a 'Previous value' type of dimension is chosen, or in fact if the dimension is converted to this type, it is possible to manually add any required columns that were not defined as part of the create. The steps are:
1 Add a new column by dragging in the column that is to have a previous value stored.
2 Change the name to a unique name. Typically by adding the prefix 'prev_' to the column name.
3 Change the source table, to be that of the dimension we are building.
4 Set the Key Type to 4.
Having performed these actions QAD Data Warehouse Designer will detect the column and build the appropriate code during the procedure generation phase.