In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • Use Track Back Diagram to Check Tables
    1
    First do a track back diagram of the fact_ or dim_ table that the custom column is to be added to.
    2
    Click the Diagram icon to the left of the Scheduler icon in the QAD BI Data Warehouse Developer (DWD).
    3
    If the Diagrammatical View tab was not already open, click the icon a second time.
    4
    Pick the fact table you want to track back on and click OK. You can start to type in the name of the table to find it in the drop-down selection list faster, but if you type the whole name in, you still have to select the item from the drop-down list otherwise nothing appears when you hit OK.
    5
    For this example, we use the fact_om_invoice table and we look to add a custom column pulling data idh_prodline from the idh_hist table.
    6
    A track back diagram appears displaying all the tables that feed the fact_ table.
    7
    Identify here if the source table of the new data is already being referenced by the fact_ table.
    8
    If the source table is included in the diagram, note its data path, taking down the names of any load_, stage_, perm_, extract_, and other tables that might contain that information.
    9
    The list should contain:
    load_idh_hist
    stage_om_invoice_line
    perm_om_invoice_line
    permsup_om_invoice_line. The permsup_om_invoice_line table is used to store parallel date data about the perm_om_invoice_line table based on the primary business key. No custom work should be necessary here unless the business key is changing for some reason.
    work_om_change_list1-3 and hist. The work tables that you can see in the first of the two dataflow diagrams above are for determining new data based on dates, so they were not included in the list to be modified.
    extract_om_invoice_line
    stage_om_invoice1
    stage_om_invoice2
    stage_om_invoice3
    stage_om_invoice
    fact_om_invoice
    As a matter of practice, it is helpful to type this list into notepad or some other text editor for reference purposes as you work through the customization.