=================================================================== DB2 OLAP Server Analyzer V8.1 -- Refreshed FixPak 2 December 2002 Service level: Hyperion Analyzer 6.2.1.00470 =================================================================== CONTENTS 1. Welcome to FixPak 2 2. Before you install 3. Installing the FixPak on Windows 4. Installing the FixPak on UNIX 5. Known Issues 6. Defects fixed in this FixPak =================================================================== 1. Welcome to FixPak 2 ----------------------- FixPak 2 offers the following enhancements: - On Windows: FixPak 2 upgrades Analyzer to support additional Application Servers, Tomcat v4.0.4, WebLogic 6.1, and WebLogic 7.0. - On UNIX: FixPak 2 upgrades Analyzer to support IBM WebSphere Application Server v4.0.3, Tomcat v4.0.4, WebLogic 6.1, and WebLogic 7.0 on AIX and Sun. FixPak 2 is available from the IBM FTP site: ftp://service.software.ibm.com/ps/products/db2olap/fixes/ analyzer/v81/fp2/ =================================================================== 2. Before you install ---------------------- - FixPak 2 only supports the Refreshed edition of DB2 OLAP Server Analyzer Version 8.1. If you have not yet upgraded to the Refreshed edition, do so before applying FixPak 2. - Hyperion Analyzer HTML Client and Analyzer Analysis Servers on UNIX operating systems require a running XWindows-session to support the HTML Web Client. - New 6.2.1 Report Definitions Users upgrading to FP2 (Analyzer v6.2.1), cannot return to Analyzer 8.1 Refreshed (Analyzer v6.1.1) due to changes in report definitions. Reports opened using Hyperion Analyzer 6.2.1 are automatically converted to a new report definition format and will not be available to previous releases of Hyperion Analyzer. Hyperion strongly recommends customers back up existing Hyperion Analyzer repositories prior to upgrading to release 6.2.1. The first time reports created in prior releases are opened, Hyperion Analyzer pauses slightly to auto-migrate the report to the new report definition format. There are 2 options available to having your Analyzer v6.1.1 reports and Report Groups be available in Analyzer v6.2.1. 1) Backup ANALYZ60 database through the RDBMS and during FP2 installation, point Analyzer 6.2.1 to use the existing ANALYZ60 database instead of creating a new repository (default called ANALYZ62). Once the reports are opened in v6.2.1, auto-migration will occur. or 2) In Analyzer v6.1.1, do FILE > EXPORT > REPORTS (or REPORT GROUPS) and save the reports/report groups definitions on hard drive. After performing clean up steps as stated in the "Installing the FixPak on Windows" and "Installing the FixPak on UNIX" section, install FixPak2 and after logging in, do FILE > IMPORT > REPORTS (or REPORT GROUPS). Once the reports are opened in v6.2.1,auto-migration will occur. - Installations on French Operation Systems The installation wizard may fail to install Hyperion Analyzer correctly on French operating systems when logged in as the Administrator domain user. Those installing Hyperion Analyzer on French operating systems are required to log on as the local administrator (literally "Administrator") for the installation script to operate successfully. 02-04-0161 - Installations on Japanese Operating Systems Due to limitations in WebSphere 3.5 and 4.0.3 application servers, the HTML Web Client and Analysis Server Console cannot transmit double-byte Kanji characters in WebSphere implementations. - WebSphere Application Server 4.0.3 requires IBM HTTP Server v1.3.19. The WebSphere Application Server installation program also installs IBM HTTP Server 1.3.19. If you have a level of IBM HTTP Server prior to version 1.3.19 on your system, uninstall it before running the WebSphere Application Server installation program. - Database for WebSphere Applicaton Server 4.0.3 on AIX may need to be catalogged as a remote database even if it is not. Please refer to the IBM Redbook (http://ibm.com/redbooks) "IBM WebSphere V4.0 Advanced Edition Handbook for further details. - Downloading WebSphere Application Server 4.0.3 (Fixpak 3) You can download WebSphere Application Server 4.0.3 (Fixpak 3) from the following FTP sites: For Windows: ftp://ftp.software.ibm.com/software/websphere/appserv/support/ fixpacks/was40/fixpack3/Windows/ For Advance Edition, download: Filename: was40_ae_ptf_3.zip File size: 64.4 MB Date: Mon Apr 29 12:00:00 2002 For Advance Edition Single Server, download: Filename: was40_aes_ptf_3.zip File size: 62.1 MB Date: Mon Apr 29 12:00:00 2002 For AIX: ftp://ftp.software.ibm.com/software/websphere/appserv/support/ fixpacks/was40/fixpack3/AIX/ For Advance Edition, download: Filename: was40_ae_ptf_3_AIX.tar File size: 70.4 MB Date: Mon Apr 29 12:00:00 2002 For Advance Edition Single Server, download: Filename: was40_aes_ptf_3_AIX.tar File size: 68.1 MB Date: Mon Apr 29 12:00:00 2002 For Sun: ftp://ftp.software.ibm.com/software/websphere/appserv/support/ fixpacks/was40/fixpack3/Sun/ For Advance Edition, download: Filename: was40_ae_ptf_3_SUN.tar File size: 86.4 MB Date: Mon Apr 29 12:00:00 2002 For Advance Edition Single Server, download: Filename: was40_aes_ptf_3_SUN.tar File size: 83.4 MB Date: Mon Apr 29 12:00:00 2002 If you install WebSphere Application Server 4.0.3 on a system on which version 3.5.5 still exists, install it in separate directory, and disable the service for version 3.5.5. - The directory structure "C:\hyperion\analyzer" in Windows and "/usr/hyperion/analyzer" in UNIX (by default from previous install of Analyzer) must be intact for Fixpak 2 to be successfully installed. - BEA Weblogic 6.1 Installations notes \%beainstall%\wlserver6.1\config\%domainname%\startWebLogic.cmd file must be edited to update memory settings. Edit the CLASSPATH variable and the JAVA_HOME definition to reflect the following changes: "set CLASSPATH=.;.\lib\weblogic_sp.jar;.\lib\weblogic.jar; %CLASSPATH%" and ""%JAVA_HOME%\bin\java" -hotspot -ms128m -mx256m -classpath "%CLASSPATH%"..." It should be noted that changes to the values -ms and -mx are the suggested minimum values. - Additional BEA Weblogic 6.1 and 7.0 Installation Notes. Users installing Hyperion Analyzer on a WebLogic 6.1 or 7.0 application servers must set the system CLASSPATH variable to include all JDBC drivers. This includes drivers supporting both the Hyperion Analyzer repository and RDBMS data sources to which users intend to connect. - SQL SERVER 2000 Installation Notes SQL Server 2000 Administrators must update the classes.xml file to reflect the correct TCP/IP port number (if other than 1433). - HP-UX 11.0 is not a supported platform. Please ignore references to HP-UX 11.0 in the documentation. =================================================================== 3. Installing the FixPak on Windows ------------------------------------ This section describes how to apply this FixPak: a) Download the analyzer81_fp2.zip file to a temporary directory on your Windows system. Make sure the path name of the directory does not include spaces. The FixPak installation program does not support directories whose names have spaces in them. Underscore characters are acceptable in directory names. b) Unzip the analyzer81_fp2.zip file to the same drive where Analyzer 8.1 Refresh is installed. Then run AnalyzerSetup.exe. c) Analyzer Windows Client and Analyzer Server are not separate downloads. On the installation panel called "Usage Mode", choose the appropriate radio button. To upgrade Analyzer Windows Client, choose the option called "Windows Client". To upgrade Analyzer Server, choose the option called "Enterprise Edition". d) Analyzer now requires that the location for the JDBC Driver Path (such as db2java.zip) be supplied during installation (on panel "Configure RDBMS Repository"). If DB2 UDB is located on a remote machine, please copy the db2java.zip file and put this file onto the local machine where Analyzer FP2 is being installed. On Windows, by default, this file can be found at: C:\Program Files\SQLLIB\java e) Analyzer FixPak 2 installs a different version of the ADM Driver. Thus, two different versions cannot reside on the same machine. Prior to installing FixPak 2 for Analyzer, please complete the following steps: - Stop the Application Server Process - Stop the Web Server Process - Remove the ADM folder default location in Windows: C:\hyperion\analyzer Note: For WebSphere 3.5.5, the WebSphere process needs to be running in order for FP2 to install correctly. f) If you install WebSphere Application Server 4.0 on a system that has DB2 Personal Edition installed on it, you might get an error message about not having proper version of DB2. The workaround is to click "Cancel" on the message dialog, and then "Resume Setup". The installation continues normally. g) To start the WebSphere Application Server 4.0 Service, the "Server" service must be present and started on the machine. The "Server" service can be installed by adding "File and Printer Sharing" from Network Connections in the Control Panel. You need the Windows CD to add "File and Printer Sharing" and then you need to reboot. WebSphere Application Server 4.0 requires the "Computer Browser" service to be started, which in turn is dependent on the "Server" and "Workstation" services. =================================================================== 4. Installing the FixPak on UNIX --------------------------------- a) Download the analyzer81_fp2_aix.tar (or analyzer81_fp2_sun.tar) file to a temporary directory on your UNIX system. Make sure the path name of the directory does not include spaces. The FixPak installation program does not support directories whose names have spaces in them. Underscore characters are acceptable in directory names. b) Untar the analyzer81_fp2_aix.tar (or analyzer81_fp2_sun.tar) file to the same machine where Analyzer 8.1 Refresh is installed. Then run AnalyzerSetup c) Analyzer now requires that the location for the JDBC Driver Path (such as db2java.zip) be supplied during installation (on the panel called "Configure RDBMS Repository"). If DB2 UDB is located on a remote machine, copy the db2java.zip file and put this file onto the local machine where Analyzer FP2 is being installed. On UNIX, by default, this file is in the following directory: /home/db2_instance_owner/sqllib/java12 d) Analyzer FixPak 2 installs a different version of the ADM Driver. Thus, two different versions cannot reside on the same machine. Prior to installing FixPak 2 for Analyzer, please complete the following steps: - Stop the Application Server Process - Stop the Web Server Process - Remove the ADM folder default location in AIX: /usr/hyperion/analyzer default location in SUN: /opt/hyperion/analyzer Note: For WebSphere 3.5.5, the WebSphere process needs to be running in order for FP2 to install correctly. =================================================================== 5. Known Issues ---------------- - 02-11-0008 Cumulative Calculations do not update after applying a Sort definition. - 02-08-0061 Hyperion Analyzer Analysis Servers on UNIX operating systems require a running XWindows-session to support the HTML Web Client. - 02-10-0048 Drill Link on Data does not function in the HTML Web Client. - 02-04-0116 The custom report HTML object component supports only basic HTML in the Java Web Client. The Java Web Client does not support DHTML or scripting languages. However, the HTML Web Client does not have this limitation. - 02-05-0061 Data sources defined in the course of creating custom report objects persist, even when they are not specifically used by report objects. Multiple unused data sources can negatively impact query performance, and should be manually deleted. - 02-10-0113 Custom report combo boxes do not support dynamic member selections "Select Level" and "Select Siblings" in conjunction with relational database connections. - 01-10-0088 There is nothing preventing users from naming a calculated member the same name as a dimension member. - 02-09-0041 The Hyperion Analyzer API Toolkit does not work in conjunction with Netscape browsers. - Removing members from the Essbase outline that are used in a report causes loading errors. 02-04-0073 - Page members are included in sorting definitions. 02-03-0125 - Default Chart "Series Color" settings do not migrated from 5.0.3 to v6. 02-06-0031 - API client sessions terminated using the Hyperion Analyzer Server Console offer no indication that the session has been ended. 02-03-0096 - Migration of hotspots over text labels from v5 to v6 may receive incorrect Z-axis order. 02-04-0103 - Parent First functionality is not supported. 01-10-0179 - Design Report data objects without alignment that overlap data objects with Slack alignments trigger drilling exceptions. 02-04-0224 HYPERION ANALYZER API TOOLKIT - After being set, API Toolkit Chart Properties cannot be adjusted. 01-07-0087 THIRD PARTY SOFTWARE ISSUES - 02-10-0192 EIS Drill-through reports with null values display erroneously. - 02-10-0301 EIS Drill-through reports with missing values display erroneously. - 02-07-0092 Drilling to relational members on Hybrid reports may result in memory and division by zero errors. - 02-10-0220 Missing values are automatically suppressed in reports using Hybrid-enabled database connections. - 02-05-0051 Drilling up on relational members in Hybrid analysis reports, results in server errors. - 02-05-0052 Users cannot select "Also Select Generation" with a relational member in a Hybrid analysis report. - 02-05-0090 Users cannot select "Also Select Previous" with a relational member in a Hybrid analysis report. - 02-05-0100 Users cannot select "Also Select Level" with a relational member in a Hybrid analysis report. - 02-05-0094 Users cannot select "Select Dim Bottom" in conjunction with a custom report combo box in a Hybrid analysis report. The level 0 relational member is not returned. - 02-06-0062 OLAP members do not display correctly as column headers after drilling down on relational members of Hybrid analysis reports. - 02-07-0055 and 02-08-0008 Users may receive memory errors when they create simple Hybrid Analysis spreadsheets with a single relational member in rows. - 02-10-0204 Users who use two relational hybrid members as filters receive an "Application not responding" error. - Closing the help window generates exception errors in Java console. 02-04-0228 - Users cannot navigate right-click menus with arrow keys. 02-01-0065 - The Toolbar may overlap the Page control panel incorrectly when the window is sized down. 02-04-0130 - OLAP Selection controls do not display descriptions on Shared Members unless specifically defined on Shared Member in the Essbase outline. 02-04-0010 - Design Report components layered over charts occasionally display behind charts. 02-03-0090 - Multi-pie chart legend is cropped when there are many pies. 02-05-0006 - Multi-pie Charts do not print. 01-07-0158 - Chart right-click menus display incorrectly on. 01-05-0113, 01-09-0033, 01-12-0067 - Multi-pie charts do not display in the HTML Web Client. 01-12-0157 - X- and Y-axis labels are sometimes cropped. 02-05-0080 - Floating point values in relational connections do not always display correctly. 02-04-0077 - Internet Explorer freezes when using split panes in conjunction with the API Toolkit. 02-01-0093 - Users are told "Changes have been applied" when attempting to edit cells that cannot be edited. 02-05-0045 - Users cannot drill-up on Shared Members. 01-10-0168 - Drilling down twice on the same HFM member duplicates the member's children. 02-05-0073 - Suppress Missing option does not work with HFM. 02-09-0003 - Drilling down on an HFM member already in play changes the member's indent. 02-08-0077, 02-05-0095 =================================================================== 6. Defects fixed in this FixPak ------------------------------- - 02-11-0108 Memory and object allocation is improved when the same report is loaded multiple times. - 02-10-0067 Custom report HTML object now displays in HTML Web Client. - 02-10-0224 Service Button properties display correctly. - 02-10-0119 Edit Data properly displays the thousands separator. - 02-11-0092 Users can now drag drop dimension members from the Information panel filters axis without encountering errors. - 02-10-0127 Open Report Service button does not display the "Busy" cursor during click events. - 02-10-0244 Metadata queries involving Substitution Variables and dynamic member selections are now resolved correctly. - Cube navigator no longer displays old dimension aliases erroneously. 02-05-0012 - EIS drill-through reports with more than 10 columns no longer place data in wrong columns. 02-05-0037 - Multiple issues related to the migration of user passwords from v5 to v6 have been resolved. 02-04-0088 - DTS selections now display correctly in combo boxes. 01-06-0097 - Closing Administration Tools no longer shuts down Netscape applications, including Netscape Mail. 02-08-0024 - The database connection list loads quicker. 02-07-0080 - The API Toolkit no longer prompts Essbase Authenticated users with new passwords to log on again. 02-08-0168 - Euro character now displays in Japanese environments. 02-04-0138 - Combo boxes now support members returning No Data Available. 02-09-0067 - Hyperion Analyzer displays the entire HFM member name description regardless of periods(.). 02-09-0109 (Vanitve #330899) - Scroll bars display regardless of off-screen report components. 02-09-0167 - Reports open, even when new dimensions are added to the current Essbase outline. Reports can be repaired by opening cube navigator, exiting cube navigator, and then re-saving the report. 02-08-0038 - HTML Web Client now supports the "Show on Desktop" report group property. 02-08-0083 - Printout summary page returns complete description for Filter axis members. 02-07-0064 (Vantive #322065) - Image buttons maintain image even as button is pressed. 02-07-0037 (Vantive #319124) - Administrator now supports user IDs with spaces. 02-08-0030 (Vantive #328910) - Administrators can assign users report group access without errors. 02-08-0138 - Normal exits from client applications release user sessions. 02-09-0061 - Users can drill linking to reports containing no data. 02-08-0167 - Users can now drill to top on pinboards. 02-07-0041 - Export to Excel on German OS no longer prompts user to specify the Excel.exe location. 02-08-0118 - Services buttons display images. 02-07-0085 - Service button properties display text even when length in characters exceeds the width of the input field. 02-08-0091 - Opening saved reports using SQL Server 2000 repository does not return invalid XML character error. 02-07-0071 - Member information passed when drill linking to open reports. 02-05-0083 - Users can now rename the Dimension Browser service button. 02-06-0010 (Vantive #307645) - The Data Formatting Manager dialog supports the value operator "<>" without freezing. 02-07-0023 - Cloned users receive Essbase user ID and password settings for cloned data sources. 02-05-0036 - Users can successfully select 'Select Dim Bottom' on column axis selections (Japanese). 01-10-0031 - API Toolkit NewView action now supports non-English locales. 02-02-0118 - Filter text replacement tokens correctly return selected members instead of dimension names. 02-08-0171 - When importing, user IDs with white space characters no longer prevent the creation of user IDs and database connections. 02-04-0058 (Vantive 287602) - Alias table settings for connections display correctly for cloned users. 02-08-0022 (Vantive 326450) - Restrict Data saves decimal values. 02-05-0044 (Vantive Case #301252) - Send to excel includes Pages and Filter information. 02-05-0007 (Vantive #294229) - HTML Web Client no longer displays Korean characters as "?". 02-06-0007 (Vantive #306141) - HTML Web Client supports pivoting in complex outlines. 02-06-0004 (Vantive #301220) - Users are prevented from creating multiple report groups with the same name in Administration Tools. 01-10-0010 - Variable Width text labels are not cropped under Japanese locale. 02-02-0122 - Color settings are applied when formatting pie charts. 02-04-0097 - Headers correctly display when printing reports to PDF file format. 02-04-0154 - User Preferences dialog closes after the Apply Changes prompt displays. 02-04-0099 - Quadrant charts now support scaling. 02-04-0139 =================================================================== Licensed Material - Program Property of IBM (c) Copyright IBM Corp. 1998, 2002. All Right Reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. IBM, DB2, and DB2 OLAP Server are trademarks of International Business Machines Corporation in the United States, other countries, or both. Portions (c) 1991-2002 Hyperion Solutions Corporation. All rights reserved. Hyperion is a registered trademark and Hyperion Solutions is a trademark of Hyperion Solutions Corporation. Portions (c) Blue Sky Corporation. All rights reserved. ===================================================================