Materialized Queries
- Add – New refresh option Use Temporary Table during update. End Users can continue using the existing data while the temporary Table is being updated. This avoids reporting on incomplete data if a report is running during the data refresh event. A temporary Table is used during the update and when complete it is renamed. This process improves data availability and integrity because the previous data is available during the update. If this option is not used and a report is running during the update process, it may be accessing an incomplete dataset. Consider using the option when updates take a long time to complete and reports are accessing the data at the same time.
- Fix – When refreshing a MQ table the stats on the Start and End times would fail to update if the refresh was done after 22:00 hours GMT due to the time causing a SQL int overflow error.
Foundry
- Fix – Data Type Created Date did not work correctly. Always shored 1900-01-01.
Web Channel
- Fix – Data Entry Form did not always display labels in correct position when using two fields per row display mode. &fieldsPerLine=2
- Fix – Drill links where filter values used operators like not equal != VALUE did not pass correctly to target report. Where appearing as = VALUE.