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
  •   |  
    Next Page

    Release Notes for Release 3.2.1
    QAD Business Intelligence Version: 3.2.1
    Date: June 6, 2010
    Overview
    This document contains information about the specific changes in the QAD BI 3.2.2 release. Most changes in this release impact the BI metadata that is used to build the data warehouse. Some changes to standardize names and fields used by the QAD BI Portal are also included.
    Defect (metadata)
    Order for two different customers that share the same order number caused problem creating fact_om_order_history and fact_om_order_performance.
    dim_customer_sold_to.region_description had wrong datatype, causing problems in cube creation.
    stage_om_booking_transaction not considering item_number when building fact table, causing failure.
    stage_financial_date displays wrong month at end of financial year.
    fact_om_booking: Unit cost base, corp and trans were not showing up as measures in the portal query builder. Same was true for list price base, corp and trans.
    Unit_costs properly handled in base and trans values.
    Checks with null status in fact_ap_check were not showing as OPEN.
    fact_om_invoice: Unit Cost, List Price, Net Price Base, Corp, Trans were not showing up as measures in the portal query builder.
    Some fact tables do not have proper Business Display Names (End User Labels).
    Some dimension tables do not have proper Business Display Names (End User Labels).
    fact_om_order_history: Unit Cost, List Price, Net Price Base, Corp, Trans were not showing up as measures in the portal query builder.
    fact_om_shipment: Unit Cost, List Price, Net Price Base, Corp, Trans were not showing up as measures in the portal query builder.
    Bookings reversals have wrong effective date.
    AR invoice aging logic is only showing positive amounts, not credits.
    fact_ap_invoice_snapshot, fact_ar_invoice_history, fact_ar_invoice_snapshot - Credit Term Split Sequence should not be a measure in the portal query builder.
    fact_ap_voucher_history: several Amount Open bucket measures not showing up properly as measures in the portal query builder.
    fact_ar_invoice_history: Account Base not showing up properly as a measure in the portal query builder.
    work_ap_check_list has erroneous data source listed, causing data to load improperly.
    fact_om_order_history was not considering transactions that changed before the SALES_ORDER_HISTORY_DATE parameter value, even if they were back changed.
    fact_ap_voucher_history never receives closed vouchers (where the base amount is zero).
    fact_ar_invoice - open_amount_base was calculated incorrectly.
    Address field sizes were expanded to hold large address lengths, throughout the warehouse.
    fact_ap_check contained some checks that were really vouchers.
    Defect (portal)
    Dashboard: dashboard view was incorrectly showing multiple scroll bars when the height of the dashboard was set to a smaller size than the items placed on it required.
    Report: Refreshing a query used by a report was not properly refreshing the queries parameters.
    Dashboard: Problems with multiple visual items using parameter bars would periodically cause. incorrect refresh behavior when the parameter bar changed, resulting in no data to display messages.
    Query Designer: use display names for fact tables in the drop down, rather than table names.
    Enhancements
    Metadata: Fact table labels (Business Display Names, or EULs) made consistent across fact tables.
    Metadata: added cube creation job.
     



      |  
    Next Page