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




Release Notes for Release 3.3.1
QAD Business Intelligence Version: 3.3.1
Date: November 2010
QAD BI 3.3.1 adds new information in the Inventory warehouse module and a few minor fixes for the BI Portal.
New Feature Summary
Modules
Inventory: The inventory schema has been extended to include the following new measures:
Average daily issued quantity and value historical: these columns contain the quantities of inventory issued during a period, and the value of that inventory based on standard costs for the items in the inventory being collected.
average_daily_issued_quantity_historical
average_daily_issued_value_historical
Days on hand historical: inventory projected days on hand based on historic usage information for the inventory. Period calculations for inventory usages are used to project the amount of available inventory.
days_on_hand_historical
Days on hand projected: projected amount of inventory on hand based on demand records recorded for that inventory. This value is recalculated daily to give accurate measures of inventory requirements.
days_on_hand_projected
Multi-measure cubes: Three new Multi-measure cubes have been added. These cubes cover Inventory, Purchasing and Sales. Each cube contains multiple fact tables from the module area, allowing the user to not only explore the fact tables themselves along many dimensions but to also relate the fact tables together inside an Excel pivot table.
Fixes
 
Component
QAD Issue
Customer Case
Description
Portal
QBI-527
 
Visual items were taking up slightly more space in 3.3 than the same visual item in 3.2, causing some dashboards to align incorrectly. This has been corrected.
 
QBI-526
 
In some instances, editing a query in advanced mode did not allow the user to press the “next” button. This kept the user from assigning types to the columns in the advanced query. This is now corrected and the wizard button is always available.
 
QBI-525
 
Using an advanced query that had multiple parameter values would cause a failure in the report designer when operating with that query.
Modules
QBI-475, QBI-476
 
The daily date roll stored procedure was not properly setting the YTD, MTD and QTD fields correctly. These calculations have all been updated to be correct.
 
QBI-536
 
Item standard costs were not always updating in daily loads. This has been corrected: an item’s cost is now always loaded in daily runs.
 
QBI-485, QBI-486
 
Problems during load could occur with very long holiday descriptions, or merged holiday name and description fields.
 
QBI-490
 
Indexes for all dimensional joins on fact tables have now been added in the data warehouse.
 
QBI-506
 
The default setting for an installations snapshot table summaries is now set to monthly (M) rather than weekly (W). This default setting is more appropriate for most customers, and uses far less disk space.
 
QBI-535
 
Unit costs on shipments are now correctly calculated on shipments when the item being shipped is a kit, not an individual item.
 
QBI-537
 
Some display names in AP Voucher History, AP Invoice Snapshot and OM Order History have been changed to reflect a consistent naming standard for the costs and the currency in which they have been represented.
 
QBI-495
 
An item’s weight (net_weight) and unit of measure for the weight (net_weight_um) has been added to the dim_item dimension.
 
QBI-509
 
The financial report generator tables would mistakenly enter many rows for line items in some cases. While this was often benign, the multiple rows were confusing and this behavior has been removed.
 
QBI-538
 
GL accounts that are handled with fiscal period accounting were not properly resetting to zero balances in a new fiscal accounting period. This is now corrected. Accounts can be reset if they are of specific types. See the parameter information in the data warehouse for more information.
 
QBI-545
 
AR and AP aging calculations would be off for records that did not change during a new period. This release fixes the problem, properly aging records even if they do not change in the source system.
Known Issues
The BI Portal application cannot run in the same instance of Tomcat as QXTend. (QBI174)
Model changes in RED are not picked up unless a custom model is opened in the Portal, saved and closed. (QBI-127)
fact_ar_invoice_history has the ‘entered date’ value stored as a degenerate dimension value rather than as a dimensional join. This will change to a full dimension join in future releases of the BI data warehouse. Doing so might cause some queries to need to change in the future. (QBI-26)
The server-config.xml file includes user and password information for connecting to the QAD BI Portal database. Please secure this file properly with file system permissions. (QBI-176)