QAD BI v3 - Tech Level 2 Certification - Part 3 > Customizations of BI v3 > QAD BI 3 Customization Methodology
  PPT
QAD BI 3 Customization Methodology
 
For dimension tables, the only tables that should get modified are load tables and dimension tables. Load tables can have additional columns added and so can dimension tables, but the new column in a dimension should only be updated by an outside procedure that is run after the table is loaded, not the code built by the wizard.
QAD BI 3 Customization Methodology
 
For non-history fact tables, the only tables that should get modified are load tables, the stage table prior to a perm table, perm tables and the fact tables. Any new columns in the fact table should only be updated by an outside procedure that is run after the table is loaded, not the code built by the wizard.
QAD BI 3 Customization Methodology
 
For history fact tables, the only tables that should get modified are load tables, the stage table prior to a perm table, perm tables, the last stage table prior to the fact and the fact table. Any new columns in the fact table should only be updated by the prior staging table. The new column in the prior staging table should be updated by an outside procedure that is run after the table is loaded, not the code built by the wizard. The reason we allow this is that the logic involved in getting data right in the fact_om_order_history table is incredibly complex and by inserting it into the staging table prior, we can insure that the logic for the fact table does its thing as it should and people building customizations don’t have to attempt to emulate all that logic with an update procedure for a customization.
QAD BI 3 Customization Methodology