Dss_fact_table
This pseudo dimension is used internally by the QAD Data Warehouse Designer generated procedures to assist in the updating of rollup fact tables. It provides a means of identifying which fact table contributed a particular row to a composite rollup fact table. See the section on rollup fact tables for an explanation of how the generated procedures operate.
This table can be renamed, or a new table created. The table identified as the 'dss_fact_table' must, however, conform to a number of standards if the generated code is to compile and work correctly.
The following columns must exist, where table_name is the new name of the table:
|
Column name
|
purpose
|
|
table_name_key
|
The artificial key for the table. Must be a numeric data type.
|
|
table_name_name
|
The name of the fact table. Must be at least a varchar2(64) data type.
|
|
table_name_type
|
The type of fact table. Must be at least a varchar2(24).
|
The generated procedures will automatically add rows to this table as required. As with the dss_source_system table the table type for this table should be set to "Mapping table" to prevent if from being seen as a dimension in the documentation.
DSS Tables
This option allows you to set the DSS Tables.
