IBM(R) DataQuant for Multiplatforms, Version 1 Release 1, Fix Pack 3 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 DATAQUANT FOR WORKSTATION 1.1 FIX PACK 3 3.0 DataQuant for WebSphere 1.1 Fix Pack 3 1.0 ABOUT THIS README FILE Welcome to IBM DataQuant for Multiplatforms, Version 1 Release 1, Fix Pack 3 README file. This README file contains descriptions of fixes for IBM DataQuant for Workstation and DataQuant for WebSphere. 2.0 DATAQUANT for WORKSTATION FIX PACK 3 QMFDQ-32 Unable to run a stored procedure that is launched from the Search in Repository dialog. QMFDQ-50 In some instances, unable to change selection in a combo box using keyboard navigation. QMFDQ-58 Improved the display of the hierarchy layout objects OrganizationalChart, TreeChart, and ClusterGraph in a visual dashboard. QMFDQ-122 Grab and Pan tools have been added and are available to use when designing visual dashboards. QMFDQ-210 A timer object has been added that can be used to automate the occurrence of events in a visual dashboard based on time intervals. QMFDQ-214 Enhancement to display in the Output view all SQL queries that are run to obtain data for a visual dashboard. QMFDQ-312 Printing of objects is allowed even though the resource limit 'Allow printing' is not checked. QMFDQ-329 Some users without administrator privileges are able to update resource limits. QMFDQ-382 Enhanced forward and backward scene navigation within a visual dashboard. QMFDQ-394 Error can occur opening a table when connected to a MS SQL Server 2005 database. QMFDQ-517 Incorrect formatting can occur for labels in a visual report PDF. QMFDQ-556 The 'Refresh display on completion' option of the 'Execute SQL statement' action, does not correctly refresh the contents of a scene upon navigation back to that scene. QMFDQ-597 In design mode, zooming in on a visual report can alter the width of a section. QMFDQ-598 Opening a visual report multiple times from the QMF Catalog will create multiple copies of the report. QMFDQ-617 Error will occur if an incorrect file extension is specified when importing a table. QMFDQ-674 For data sources that have the resource limits saved in the repository, any changes to those resource limits will not be applied until the application is restarted. QMFDQ-696 Table editor functionality was enhanced to allow a noncontiguous select of rows using the CTRL key. QMFDQ-807 Embedded scene objects can be incorrectly offset in a rendered dashboard. QMFDQ-818 In some cases, the conditional formatting applied to a column of query results data is not preserved in a visual report. QMFDQ-844 Canceling a query can cause an exception. QMFDQ-881 Decreasing the zoom level before a visual dashboard is closed can effect the contents of a scene when the visual dashboard is reopened. QMFDQ-889 Implemented ability to copy data from grid layout in visual dashboards that are rendered using Rich Client display mode. QMFDQ-923 Added object tracking reports that use statistics stored in repository. QMFDQ-924 Unable to paste a table row that has been copied to the clipboard from a table object in a visual dashboard back into a cell of that table. QMFDQ-934 Multiple objects in a visual report are not selected upon release of the mouse button after drawing a rectangle around the objects with the mouse button depressed. QMFDQ-942 The 'MinVisibleScaling' and 'MaxVisibleScaling' properties are ignored when specified for cluster, tree and organization chart layout objects. QMFDQ-944 For repository-based resource limits, the default value for 'Maximum Rows to Fetch/Warning' and 'Limits/Maximum Rows to Fetch/Cancel' are interchanged and incorrectly displayed. QMFDQ-946 After an object has been moved in a visual report section, the 'Undo' edit command does not move it back to its original position. QMFDQ-971 Unable to open a visual report from the 'Open from QMF Catalog' dialog. QMFDQ-976 Unable to save a query in the QMF Catalog using the 'Save At Repository' menu item. QMFDQ-981 Exception can occur when expanding the references node for a query that is run against a data source that does not contain a table that is referenced in the query. QMFDQ-982 Exception can occur when running a query saved in the QMF catalog that references a non-existent column. QMFDQ-984 Incorrect error message is displayed when pasting a query directly into the 'QMF Catalog Queries' node of a repository. QMFDQ-986 Incorrect syntax error message may be issued when switching from Diagram to Prompted view if the generated query contains an expression. QMFDQ-990 Status of visual dashboard is not flagged as modified in the Project Explorer, when a change is made to the dashboard in edit mode after the dashboard was opened in run mode. QMFDQ-993 Added the ability to append and remove additional SELECT statements to an existing query from the Diagram or Prompted Query views. QMFDQ-994 In a Linux environment, an exception can occur when joining tables using the Diagram Query view. QMFDQ-995 The 'Collection ID' field in the 'Edit Repository Storage' dialog is incorrectly updated after using the 'Delete' button to delete a collection. QMFDQ-996 Error can occur when trying to assign a user to a group using the 'Properties Group Membership' dialog. QMFDQ-998 A message asking whether a modified query should be saved is not issued when a visual dashboard is closed. QMFDQ-1000 Exception can occur when you try to delete or save an object from the Project Explorer view after this object has already been deleted from repository. QMFDQ-1001 When multiple copies of the user application are accessing a single repository, and a user of one copy of the application deletes and then restores a visual dashboard, an exception will occur when the users of the other copies of the application try to open the dashboard. QMFDQ-1002 The command 'Change Query' is missing from the context menu that is opened when you right click on the 'MainPage' node for a visual report in the Project Explorer. QMFDQ-1012 Error can occur when expanding references node for a query that includes a 'Delete' statement. QMFDQ-1017 In the Project Explorer view, an exception can occur if you right-click on a layout object's data template node in a visual dashboard scene and select 'Cut' from the context menu. QMFDQ-1019 When using the wizard to create a MultiVariateChart layout object in a visual dashboard, fields that are assigned to the 'Axes to be created' list are not cleared from the 'Available fields' list. QMFDQ-1022 The CandleStick and PriceIntervalBar layout objects are incorrectly rendered when the 'HighPrice' property value is set to less than the 'LowPrice' property value. QMFDQ-1023 Unable to synchronize an offline repository object entry from the Repositories view when there is no connection to the repository. QMFDQ-1024 Inadequate feedback is given when an attempt is made to connect elements in a visual report that cannot be connected using an object from the 'Connectors' palette. QMFDQ-1027 Unable to locate a picture when the 'ImageSource' property for the picture object has been set to a query column. QMFDQ-1039 An exception can occur when you open the 'Select Items for Saving' dialog using the 'Save All' icon in the Project Explorer and you do not select to save any items. QMFDQ-1042 Editor area is not refreshed when a picture object's image is removed. QMFDQ-1047 For visual dashboard chart layout objects (those that contain axes), setting the 'Visible' property to false causes the chart layout object to disappear from the 'Design" page of the Visual Designer editor. QMFDQ-1070 From the Workspaces view, an exception can occur when you select 'Rename' or 'Refresh' from the 'File' menu and you are not connected to a repository. QMFDQ-1055 Line objects may be incorrectly rendered in visual reports. QMFDQ-1057 Non-existent columns may be listed as references for a query that runs against an Oracle data source. QMFDQ-1058 Some tables may be incorrectly listed in the references node for queries that run against an Oracle data source. QMFDQ-1064 Switching to prompted view may corruct SQL text. QMFDQ-1076 When creating queries using the Diagram view, the display of the property table is corrupted for Linux and UNIX operating systems. QMFDQ-1082 The command 'File->Open From->QMF Catalog' is disabled after one or more data sources are added to a file-based repository. QMFDQ-1095 The CONFIRM resource limit is not being considered when the CONFIRM option of a procedure command is not specified or is specified with the value of 'NO'. QMFDQ-1096 Error can occur when using the EXECUTE command in a procedure. QMFDQ-1097 Translation errors can occur when the 'LANGUAGE=SESSION' option of the 'EXPORT FORM' command is used. QMFDQ-1100 Error can occur when exporting to IXF format a table that includes LOB data. QMFDQ-1104 When exporting a classic report to HTML format, the last row of data is omitted. QMFDQ-1108 Translation of some Workspaces view resources and several tooltips does not occur immediately after switching preference setting between languages. QMFDQ-1109 Exception can occur when double-clicking on a Oracle database table and the default action for double-clicking on an object in the repository is set to 'Run Object'. QMFDQ-1110 Dashboard connectivity tool displays broken dotted line when the canvas is scrolled while connecting objects. QMFDQ-1111 Dashboard connectivity tool may generate SQL that exceeds the maximum line length supported by QMF catalogs. QMFDQ-1112 Dashboard and visual report data source connections cannot be renamed or deleted if copied from a prior connection. QMFDQ-1116 The ability to add multiple palette objects to reports or dashboards by holding down the CTRL key is now extended to custom palette objects. QMFDQ-1117 Connecting to secure repositories is disabled unless the DataQuant for Workstation Administration component is installed. QMFDQ-1488 Introduces a new IsSecurityLevel() dashboard and report function which allows authors to tailor content to the security level of the end user. QMFDQ-1494 Enhances the chart layout wizard with ability to automatically chart multiple data series derived from one or more columns in a selected query. QMFDQ-1495 Visual reports ignore global variable values listed under the 'globals' section of the report project. QMFDQ-1499 Visual report properties dialog displays the 'object type' using an internal name rather than the translated type name. QMFDQ-1500 An exception may occur when attempting to drag and drop a palette item under an inappropriate parent item in the Project Explorer. QMFDQ-1505 Amendments to workspace permissions are not propagated to child items, despite checking the 'Apply to child folders…' checkbox option. QMFDQ-1508 It is not possible to drag and drop files from the 'Recently Used' folder in the Repository Explorer to a location elsewhere in the Repository Explorer. QMFDQ-1512 Repository objects cannot be dragged between the 'Repositories' and 'Repository Explorer' views. QMFDQ-1514 Exporting a visual report to HTML format does not export any corresponding images contained within the report. QMFDQ-1520 The dashboard and visual report layout wizard may select incorrect query columns when they are added to the layout one at a time. QMFDQ-1523 The name of an open dashboard in the Project Explorer is not updated when the dashboard name is changed via the Repository Explorer. QMFDQ-1524 Dashboard and visual reports generate errors if their name includes an '!' character. QMFDQ-1525 Objects may fail to be saved if their parent folder is renamed in the Repository Explorer while the project is still under edit in the Project Explorer QMFDQ-1528 Changes to the default properties for dashboard and visual report arrow objects are also applied to line and double-arrow objects. QMFDQ-1549 Pressing the delete button in the 'Repositories' view prompts the user to confirm the deletion of the entire repository rather than the selected item within it. QMFDQ-1550 Changes to the default measurement unit are not applied to dashboards and visual reports. QMFDQ-1554 Renaming a query within the Project Explorer does not update the name in the query tab when the query is already open. QMFDQ-1560 Literal date values assigned to date and time properties may be incorrectly interpreted at runtime. QMFDQ-1563 Amendments to the SQL text of a dashboard or visual report query may not be reflected in the layout wizard until the user clicks on the 'Refresh Columns' button. QMFDQ-1575 When switching a dashboard or visual report connection to a new data source, resource limits associated with the prior data source remain in effect until the dashboard or report is re-opened. QMFDQ-1581 Stored procedures are not supported when working with DB2 VSE/VM databases. QMFDQ-1748 The dashboard and visual report layout wizard does not display calculated query columns. QMFDQ-1750 After attempting to save a multi-statement query as a prompted query object type, it is not possible to save it as a query object type. QMFDQ-2583 Repository tables cannot be created within a DB2 for iSeries database when using the Toolbox JDBC driver. QMFDQ-2588 'Jump To' option in the dashboard runtime settings does not update scene list after a jump action. QMFDQ-2594 When generating a classic report from a query, report columns associated with query calculated columns may be set to an insufficient width. QMFDQ-2595 'Spin' buttons in the classic report designer do not alter the associated data field. QMFDQ-2603 Exception can occur when expanding references node for queries with complex SQL syntax. QMFDQ-2609 Grouping information is lost when converting a query to a classic report which, in turn, is converted into a visual report. QMFDQ-2611 Sending OLAP query results to Microsoft Excel produces incomplete Excel worksheets. QMFDQ-2655 Multiple chart y-axes are displayed on the same side of the chart. QMFDQ-2659 Double-clicking on column headers in a grid layout in visual dashboard does not auto-format the column to fit the cell contents. QMFDQ-2661 Visual dashboard grid layout content may display incorrectly when scrolling the grid using its scrollbars. QMFDQ-2665 Query diagram view does not automatically apply existing joins when adding additional copies of the same tables. QMFDQ-2674 The design-time labels within bar charts display their dimension value rather than the expression that defines their runtime value. QMFDQ-2677 Added support for high contrast color schemas. QMFDQ-2684 Entering an incomplete term while conducting a repository search may result in an application error message. QMFDQ-2688 The data grid ignores its visible property setting when running within HTML-based dashboards and visual reports. QMFDQ-2689 Dashboard and visual report projects erroneously allow the author to insert OLAP queries and attach them to relational data sources. Such an action subsequently results in an error condition. QMFDQ-2692 Dashboard ExecuteSQL event action may truncate the SQL query text at the last character. QMFDQ-2693 It is not possible to select an item on a dashboard that resides within the bounding rectangle of a line object. QMFDQ-2702 Repository search results erroneously includes objects for which the user does not have browse permissions. QMFDQ-2705 Enhancement adds a new millisToDate() function which returns a date corresponding to the supplied number of milliseconds measured from January 1, 1970 UTC. QMFDQ-2710 After automatically generating a visual report from a given query, closing the project using the 'close all' button in the Project Explorer may result in an application error. QMFDQ-2714 It is not possible to delete repository storage that has been created within an MS SQL Server data source. QMFDQ-2718 A dashboard table layout may be corrupted when query results are formatted. QMFDQ-2721 After deleting a stock image referenced by a picture object, it is no longer possible to resize the 'empty' picture object. QMFDQ-2726 An application error may occur when double-clicking on a dashboard object in the Project Explorer that does not belong to the scene in the current tab. QMFDQ-2743 An application error occurs when attempting to insert a connection into a dashboard or visual report while disconnected from a repository. 3.0 DataQuant for WebSphere 1.1 Fix Pack 3 QMFDQ-32 Unable to run a stored procedure that is launched from the Search in Repository dialog. QMFDQ-617 Error will occur if an incorrect file extension is specified when importing a table. QMFDQ-674 For data sources that have the resource limits saved in the repository, any changes to the resource limits will not be applied until the application is restarted. QMFDQ-805 Enhancement to run a DataQuant object independent of the DataQuant for WebSphere user interface. QMFDQ-807 Embedded scene objects can be incorrectly offset in a rendered dashboard. QMFDQ-844 Canceling a query that is running on a remote server can cause an exception. QMFDQ-854 Enhancement to add the 'Shell execute' functionality which allows dashboards to launch specified URLS in a new browser window. QMFDQ-942 The 'MinVisibleScaling' and 'MaxVisibleScaling' properties are being ignored when specified for cluster, tree and organization chart layout objects. QMFDQ-1078 User information dialog may not appear after creating a repository with LDAP security. QMFDQ-1106 Error can occur when searching a repository for all (% for object name) stored procedures. QMFDQ-1108 Translation of some Workspaces view resources and several tooltips does not occur immediately after switching preference setting between languages. QMFDQ-1488 Introduces a new IsSecurityLevel() dashboard and report function which allows authors to tailor content to the security level of the end user. QMFDQ-1495 Visual reports ignore global variable values listed under the 'globals' section of the report project. QMFDQ-1509 It is not possible to create a visual report from an open XML file. QMFDQ-1510 End users cannot save visual reports that they create during the application session. QMFDQ-1514 Exporting a visual report to HTML format does not export any corresponding images contained within the report. QMFDQ-1524 Dashboard and visual reports generate errors if their name includes an '!' character. QMFDQ-1581 Stored procedures are not supported when working with DB2 VSE/VM databases. QMFDQ-1750 After attempting to save a multi-statement query as a prompted query object type, it is not possible to save it as a query object type. QMFDQ-2583 Repository tables cannot be created within a DB2 for iSeries database when using the Toolbox JDBC driver. QMFDQ-2594 When generating a classic report from a query, report columns associated with query calculated columns may be set to an insufficient width. QMFDQ-2655 Multiple chart y-axes are displayed on the same side of the chart. QMFDQ-2686 The web application generates an error when attempting to connect to a repository that is stored within a data source that does not require a username and password. QMFDQ-2688 The data grid ignores its visible property setting when running within HTML-based dashboards and visual reports. QMFDQ-2702 Repository search results erroneously include objects for which the user does not have browse permissions. QMFDQ-2714 It is not possible to delete repository storage that has been created within a MS SQL Server data source.