5.0.2 Patch 4 Release Notes

************************************************************

Hyperion Essbase Version 5.0.2
Patch 4 Release Notes

************************************************************

Patch file name: PATCH.HTM

Applies to: All platforms

Patch Date: 7/12/99

Identification: R5.0.2_P4

************************************************************

Contents

NOTE:

Patch Installation Overview

Key

Patch Summary

Problem Summary

Downloading Patches from the Hyperion Solutions Web Site

Files to Download

Installing Patches from the Hyperion Solutions Web Site

Installing Patches from CD-ROM

SQL Source Connectivity

Copyright Information

Patch Installation Overview

This file describes problems corrected by one or more Hyperion Essbase patches. Even if you have only one of the problems fixed in one of the patches, you need to perform a full patch installation. You can install this patch by downloading the appropriate file(s) from the Hyperion Solutions Web site, or by installing from CD-ROM. For detailed information about Hyperion Essbase installations, see the Installation Notes.

Note: If you need to revert to an earlier release of Hyperion Essbase, first see information about an updated installation process.

Unless otherwise noted, most fixes are reflected in the patched server software and do not require a client upgrade; however, we recommend upgrading client and server software to the same patch level.

To see which file(s) you need to download, see Files to Download.

For instructions on installing the file(s), see Installing Patches from the Hyperion Solutions Web Site or Installing Patches from CD-ROM.

Hyperion Essbase patches are cumulative, beginning with Patch 1 of Version 5.0.2. That is, each 5.0.2 patch contains new fixes, plus all the fixes for the previous patches.

Key

R5.0.2_P4 is Release 5.0.2, Patch 4

R5.0.2_P3 is Release 5.0.2, Patch 3

R5.0.2_P2 is Release 5.0.2, Patch 2

R5.0.2_P1 is Release 5.0.2, Patch 1

Contents

Patch Summary

Contents

Problem Summary

The following problems are fixed in Patch 4. Unless otherwise noted, these fixes are reflected in the patched server software and do not require a client upgrade; however, we recommend upgrading client and server software to the same patch level.

For the latest list of problems fixed in this patch, connect to Hyperion's Technical Support Web site at:

http://support.hyperion.com/ts

On UNIX, HTML Documentation has Broken Links and Missing Graphics (P4)
On UNIX, the online Technical Reference and API Reference documents contain broken links and missing graphics. To fix this problem, you must choose Yes to install the HTML docs as part of your API or Application Manager installation.

Current Time Displays Only Day and Year in the Japanese Version of Hyperion Essbase Application Manager. (14198, P4)
The date display for the Japanese version of the Hyperion Essbase Application Manager excludes the month.

The Application Manager Crashes if a Substitution Variable in a Calc Script Exceeds the Maximum Number of Characters (14200, P4)
An attempt to perform a syntax check on a Calc Script containing a substitution variable with more than 256 characters crashes the Application Manager.

Report Scripts Freeze When Launched from the Server Using the ESSCMD RUNREPT Command (14263, P4)
An attempt to run a report script on a remote server from ESSCMD fails because of a file input/output problem on the server.

Replicated Partition Shows Incorrect Values when Aggregate Missing Values is OFF (14317, 14319 P4)
After replicating data, if the Aggregate Missing Values option is disabled, the target partition shows incorrect values. If the Aggregate Missing Values option is enabled, then zeros were substituted for #MISSING values.

On a Particular Database, Default Calc Fails to Complete when No Data is Loaded (14405, P4)
For a specific database outline, a default calculation on the empty database never completes in Release 5.0.2, Patch 2.

LOGOUTUSER Agent Command Doesn't Log Out the Specified User (14413, P4)
When an administrator issues the LOGOUTUSER command against an active user, the Agent window reports that the user is not logged in. Other users are incorrectly logged out.

Long URL as Linked Reporting Object on a Data Cell Won't Truncate, and Causes the Spreadsheet to Crash (14501, P4)
This fix requires a client upgrade. A long URL (in this case, a URL with about 300 characters) attached to a cell as a Linked Reporting Object won't truncate. If other LROs are attached to the same cell, the spreadsheet crashes when you select Essbase|Linked Objects for that cell.

The EsbGetActive Function Truncates Database Names by One Character (14510, P4)
The API function, EsbGetActive, truncates database names to seven characters even though the limit is set to eight characters.

Unable to Reallocate Memory when Restructuring an Outline (14531, P4)
Restructuring certain large outlines fails with a memory allocation error.

Calc Script with Formula Assigned to a Member on a Sparse Dimension Returns Wrong Result with the "Create Blocks on Equation" Option Enabled (14554, P4)
A formula in a calc script that calculates a regular member on a sparse dimension member that has Dynamic Calc children (for example, Year = Qtr1 + Qtr2, where Qtr1 and Qtr2 are Dynamic Calc) returns a value of 0 instead of the calculated value. This problem occurs when the "Create Blocks on Equation" option is checked.

Users Can Add Members to a Group Beyond their Privileges, and the Members Disappear (14606, 14433 P4)
A User with only Create/Delete Users privilege can add members to a group with Application Designer privilege for Sample Basic, but the members disappear from the group's list of members. With this fix, users who attempt to add members to a group with higher privileges, or to a group created by a supervisor, will get an error message.

Default Calc using @PARENTVAL in a Formula on a Dynamic Calc Member Crashes the Application when Dynamic Time Series Members are Enabled (14635, P4)
When the @PARENTVAL function is used in a formula on a Dynamic Calc member to calculate a particular database that has Dynamic Time Series members enabled, the application shuts down abnormally.

Member Names in Outline Cannot Be Edited Using Ctrl + X, C, and V Keys (14716, P4)
This fix requires a client upgrade. Outline member names could be cut, copied, and pasted using the Windows standard Ctrl + key combinations in Release 5.0.1, but not in Release 5.0.2.

DISABLELOGIN Prevents Application Connections by Users with Application Designer Privileges (14812, P4)
Issuing the DISABLELOGIN ESSCMD command prevents users with Application Designer privileges from making certain connections to the application: for example, an error is returned after the GETDBSTATE ESSCMD command is issued from within a batch program.

Dynamic Calculation Functions Incorrectly When Level-0 Members are Removed (14843, P4)
The @ACCUM function, when applied to a Dynamic Calc member, may yield incorrect results if the query specifies only part of the defined range.

Importing an Outline Does Not Work in 5.0.2 Application Manager (14862, P4)
This fix requires a client upgrade. Selecting Import|Outline after exporting it and deleting the members fails to restore the outline.

Data Load Stops, or is Incomplete for Other Records, After a Faulty Record is Encountered in the Input File (14873, 14597 P4)
A data load terminates after encountering a record containing duplicate members from the same dimension. Unless "Abort on Error" is Selected, the data load should continue, but generate errors for the faulty records.

Outline of Data Target is Not Synchronized when Members are Rearranged (14874, P4)
Rearrangement of members in the data source outline may not be reflected accurately in the data target outline after synchronization.

Selecting a Dynamic Time Series Member from List Box Causes Application Manager to Crash (14905, P4)
This fix requires a client upgrade. On a particular outline, selecting a D-T-S member to disable (for example, Y-T-D) in Application Manager's Dynamic Time Series Member Information dialog box causes Application Manager to crash.

Server Crashes When Creating or Migrating a Large Number of .PAG Files (14931, P4)
When the server is creating or migrating .PAG files, if the number of .PAG files exceeds 99 on Windows NT, or 82 on UNIX, the Hyperion Essbase server crashes.

With a Particular Database, Default Calculations on the Unchanged Database Behave Unexpectedly (14949, P4)
A level-0 block is unnecessarily created after a default calculation on a database with all member formulas tagged as Dynamic Calc. Subsequently, repeated default calculations against the unchanged outline take an increasing amout of time.

On Windows NT, Installation of Patch 3 of the 32-bit Excel Spreadsheet Add-in Results in Wrong Placement of Three .dll Files (15041, P4)
On Windows NT, the mfc42.dll, msvcirt.dll, and msvcrt.dll files are installed in the ESSBASE folder instead of the Windows NT system folder.


The following problems were fixed in Patch 3.

Objects Download Fails if there is no /LOCALE Directory (11383, P3)
With this patch, users of Objects and API programs no longer need a separate /LOCALE directory for the .NLS (National Language Support) files. Those files can be kept in the directory containing the application program.

In a Particular Outline, a Non-Consolidating Member is Included in the Calculation (12011, P3)
The data value associated with a Dynamic Calc, non-consolidating member (labeled with the "~" operator) is incorrectly incorporated into a default calculation.

Column Adjustment Occurs on Active Sheet Instead of the one Specified by EssVRetrieve Macro (12668, P3)
This fix requires a client upgrade. The EssVRetrieve Spreadsheet Toolkit macro retrieves into the correct Excel sheet, but column widths are adjusted in the active sheet.

In Japanese Application Manager, Non-Japanese Mixed Characters Appear in Tabs for Some Dialog Boxes (12802, P3)
This fix requires a client upgrade. In the Japanese version of Application Manager, non-Japanese mixed characters appear in tabs for these dialog boxes: Database Information, Data File Attributes, Data Load Settings, Dimension Build Settings, and Dimension Attributes.

Agent Crashes after Second Startup with Certain non-English NT Regional Settings (12813, P3)
With Certain non-English NT Regional Settings, the Agent crashes after you start it a second time.

Long PATH Variables are Truncated During Server Installations on Windows NT and Windows 95/98 (13005, P3)
Long PATH variables (>255 characters) are truncated when you install the Hyperion Essbase server on NT or Win9x. With this fix, the environment is updated only when necessary. If the updated value would be too long, no update occurs, and there is an informational message.

EsbGetFilterList API Function Appends String to Normal Return Value (13059, P3)
The API function EsbGetFilterList returns an unknown string at the end of the list of users.

A Constant is Missing from Visual Basic API Header File (13212, P3)
The ESB_OBJTYPE_NONE constant is not declared in the Visual Basic header file, Esb32.bas.

Incorrect Retrieval in Spreadsheet Layout with Unknown Member (13534, P3)
The first retrieval on a particular sheet with an unknown member puts incorrect data in other rows below the unknown member. The second retrieval is correct.

Solaris Server Crashes when you View the Application Event Log in Application Manager (13667, P3)
On a Solaris server, viewing the application event log by date in Application Manager causes a core-dump crash.

Updated Message File for IBM Relational Storage Manager (13730, P3)
The message database file has been updated with two new messages.

Hyperion Essbase Release 5.0.2 Will Not Install on Solaris 2.7 (13863, P3)
With this patch, Hyperion Essbase Release 5.0.2 is installable and supported on the Solaris 2.7 operating system on Sun SPARC or ULTRASPARC machines.

Calc Script Editor Tab Settings Increased from Version 5.0.1 (14021, P3)
This fix requires a client upgrade. Tab settings in Calc Script Editor increased from version 5.0.1 to version 5.0.2, affecting on-screen script readability. This fix decreases the tab setting.

Cell Note Disappears after Outline Restructure (14174, P3)
Following an outline restructure, a cell note is no longer visible in the Linked Objects Browser of Application Manager, or Excel Spreadsheet Add-in.

Application Not Successfully Deleted from DB2 OLAP Server Looks as if were Deleted in Application Manager (14275, P3)
Hyperion Essbase removes the App folder and the security file entry for an application after a DB2 function, EssSmAppDelete(), fails to delete the application.

On Solaris Server, Drill-Down on Japanese Member in Spreadsheet Returns Incorrect Results (14333, P3)
With a Solaris server, a particular spreadsheet query with aliases using Japanese characters returns incorrect results.

Target with Mixed Source Partitions Takes Longer to Calculate after Migration to 5.0.2 (14363, P3)
A target database with twelve source partitions takes longer to calculate in version 5.0.2.

"GcSetLocale" Error Occurs When Starting Application Manager (14423, P3)
This fix requires a client upgrade. In 5.0.2 Patch 2, a GcSetLocale error occurs when you try to start the Application Manager. The installation program 502p2am.exe did not update environment variables.

When Users try to Add Members to a Group Beyond their Privileges, a Warning is not Displayed (14433, P3)
A User with Create/Delete Users privilege can add members to a group having higher security privileges. The members seem to be added, only to disappear from the group's list of members. An error message appears only in the log file. This fix provides an error message that informs the user that members cannot be added to a group with higher privileges.

Dimension Building Fails for Members with Certain Japanese Characters in the Alias (14335, P3)
Dimension building with members using certain Japanese characters in the alias fails with one of these error messages:
Incorrect Syntax For Member xxxxx (3305)
Error adding alias (xxxxx) to member xxxxxx (3319)

<DIMBOTTOM Report Writer Command Doesn't Work on Parent of Shared Members (14464, P3)
With some outlines, using <DIMBOTTOM to extract shared members into a report returns incorrect results: the level-0 members are not shown.


The following problems were fixed in Patch 2.

EssGGetMemberInfo does not return the members correctly on HPUX and AIX (12089, P2)
EssGGetMemberInfo returns the wrong member list when the parameter for children is specified.

Creation of Applications Fails in Application Manager (12376, P2)
Creation of applications fails in Application Manager with "Unable to Create application". This occurs because no App directory was created during the installation process. This problem applies only if it's a new installation (not an upgrade) and the "install sample applications" option is NOT checked.

Application Manager Missing CTL3D32.DLL on Minimal WinNT 4.0 Server Installations (12692, P2)
Application Manager fails to start on NT 4.0 with a minimal Windows NT installation, because CTL3D32.DLL is missing.

BEGINARCHIVE Doesn't List Spreadsheet Audit Files in the Backup File List (12726, P2)
After executing the BEGINARCHIVE ESSCMD to place a database in Read-Only mode, the database's .ALG and .ATX files do not appear in the backup list created.

Column Headers Missing for Integration Server Drill-through Reports in Excel (12779, P2)
In the Excel Spreadsheet Add-in, an Integration Server Drill-through report returns the data without column headers.

EssOtlGetMemberInfo Doesn't Return a Member's Total Number of Children (12905, P2)
In the Outline API, the ulChildCount field in the ESS_MBRINFO_T structure doesn't work for the EssOtlGetMemberInfo function.

Partition Validation Returns "Dimension Count Mismatch" Error (12999, P2)
A "Dimension count mismatch" error message is incorrectly returned on validation of a working partition with the outline correctly mapped.

Callback Function for Outline Restructuring with DB2 OLAP Server returns Incorrect Results (13039, P2)
An Essbase callback function (adSmOtlMbrGetId) for outline restructuring with DB2 OLAP Server may return the wrong information.

On Solaris, Calculating a Particular Database Subset Causes Application Shutdown (13132, P2)
On Solaris, calculating a particular member with the @IDESCENDANTS function within a FIX...ENDFIX command block causes an abnormal shutdown of the application.

On AS/400, Default Calc on an Empty Database Causes Crash (13134, P2)
For a particular application on AS/400, the default calculation on an empty database runs infinitely.

Partition Validation Fails Unless the Member Names are Double-Quoted (13204, P2)
Unless member names are double-quoted, partition validation fails with an "invalid member" message.


The following problems were fixed in Patch 1.

Two New API Functions Documented but not Implemented (P1)
The online API Reference documents two new C main functions, EssBeginDataload and EssEndDataload, which are not implemented in Version 502. These are included with Patch 1.

In the Japanese Version of Essbase, Formulas on Japanese Outline Members Are Deleted After Outline Updating (8685, P1) In the Japanese version of Essbase, when a formula is attached to a Japanese member of the outline, the formula is deleted after the outline is updated with the "Update Outline" in the Outline Editor.

Certain Queries Fail in Spreadsheet Add-in When "Repeat Member Labels" Option Is Enabled (8968, 8984, 9087, 9291, 11672, P1)
When the "Repeat Member Labels" option is enabled in the Spreadsheet Add-in, certain types of queries (retrievals, pivots, and zooms) fail and return error messages.

Essbase Cannot Create a Database Using Certain Japanese Characters (8989, P1)
Error messages occur when you use the CREATEDB command in an ESSCMD script to create a database named with certain Japanese characters.

#MISSING Values Don't Aggregate Properly after Moving Child Members in an Outline (9338, P1)
In certain outlines, when SET AGGMISSG is ON, after moving all children of one parent to another parent in the same dimension, and then calcuating the database with SET UPDATECALC OFF and CALC ALL, the spreadsheet shows that the parent with the removed children retains the original value (instead of having an updated value of #MISSING).

User with Application Designer Privilege and Create/Delete Applications Privilege Cannot Copy Applications (11456, P1)
A user with Application Designer privilege and Create/Delete Applications Privilege cannot copy applications.

EssGUpdateLRO Returns Error for Linked URLs (11491, P1)
The EssGUpdateLRO GRID API function works properly for files and cell notes, but returns the following error for linked URLs:

[Invalid object option for URL link entered -  3 ]

Essbase Fails to Start on NT when the Regional Setting is "Polish" or "English (New Zealand)" (11507, 11945 P1)
The Essbase Agent fails to start on Windows NT when the Regional Setting is set to "Polish" or "English (New Zealand)." Instead, the following error message occurs:
Failed on GcSetLocale ()

Database Queries Following Certain Calculations Crash the Server (11518, P1)
Following certain calculations using the "Aggregate Missing Values" and "Create Blocks on Equations" options (boxes checked in Database|Settings), database queries crash the Essbase server.

Patch 1 fixes the problem and provides an enhanced crash recovery for databases affected by this bug only. To avoid starting over with an empty or backup database, install Patch 1, leaving the crashed, pre-Patch 1 database in place. Then re-select the database.
Note: If you do not install Patch 1 before reselecting the database, then crash recovery will run into the same problem.

Free Form Retrieval in Excel Incorrectly Interprets Very Large or Small Values (11528, P1)
When Free Form mode is enabled in the Spreadsheet Add-in for Excel, a retrieval on a very large or very small number incorrectly returns numeric values as text strings. For example, a retrieval on 0.000005 incorrectly returns 5e-006 as a left-justified text value.

Time Balance "Last" Tag Returns Incorrect Values for Upper-Level Time Dimension Members (11570, P1)
The Time Balance "Last" tag returns incorrect values for upper-level Time dimension members if the last child member has a (~) (non-rollup) sign attached to it.

Integration Server Drill-Through Report Execution Returns Error Message (11648, P1)
On UNIX operating systems, when you attempt to execute an Integration Server Drill-Through report from the Spreadsheet Add-in, the report fails and Essbase returns an Invalid Login String message.

CCONV Calc Command Incorrectly Sets Data to #MISSING (11779, P1)
In certain calc scripts, the CCONV calculation command sets data to #MISSING if the associated currency database outline contains Dynamic Calc members.

Retrieval on Dynamic Calc Members with Formulas Causes Infinite Loop of Messages on Server Window (11791, P1)
In the spreadsheet, if you manually enter names of Dynamic Calc members that have member formulas, and then do a Retrieve, an infinite loop of messages (tried to read below bottom of stack in cpop(stk)) appears in the server window.

Validate in ESSCMD Produces an "LRO free catalog page" Error Following Sparse Restructuring of a Database with LROs (11859, P1)
Validate in ESSCMD produces an "LRO free catalog page" error following sparse restructuring of a database with LROs.

A #MISSING Value for a Child Member Does Not Consolidate after Lock and Send (11929, P1)
A #MISSING value for a child member in a particular outline fails to consolidate following a spreadsheet lock and send. A retrieval should show the new parent value as #MISSING.

Essbase Cannot Create a Database with '&' as Part of the Database Name (11977, P1)
In ESSCMD or Application Manager, when you try to create a database that has an '&' symbol as part of the database name, Essbase generates an error 1019002 - unable to create database.

Particular Calculation Scenario Crashes the Server (12018, P1)
When a member formula contains the @PRIOR function, and the member which uses the formula is calculated twice in a calc script, the application server crashes.

Zoom In with Repeat Member Labels Distorts Spreadsheet View (12347, 12348, P1)
When the "Repeat Member Labels" option is enabled in the Spreadsheet Add-in, zooming in on certain members distorts the spreadsheet view, and error messages are displayed.

Pivoting Columns with Repeat Member Labels Distorts Spreadsheet View (12385, P1)
When the "Repeat Member Labels" option is enabled in the Spreadsheet Add-in, pivoting column headings distorts the spreadsheet view.

Application Manager Doesn't Run when Installed on a Minimal Windows NT machine (12692, P1)
Application Manager doesn't run when installed on a minimal Windows NT machine. CTL3D32.DLL, a required file, is not on the minimal machine.


Downloading Patches from the Hyperion Solutions Web Site

  1. Using a Web browser such as Netscape Navigator or Microsoft Internet Explorer, connect to Hyperion's Technical Support Web site at:

    http://support.hyperion.com/ts

  2. Enter your Site ID, Server ID, and name; then click "Push the button to login."

    If you do not already have access to Hyperion's Technical Support Web service, ask your your company's support contact to:

    Be sure to have your company's specific support contact initiate communication with Hyperion's Technical Support.

  3. Click "Patch Central."

  4. Do one of the following:

The "Problem Summary" section of the Release Notes contains the final list of problems fixed in the patch.

Contents

Files to Download

When downloading files from the Hyperion Web site, use the following lists as your guide to which file(s) you need.

NT or Windows Files

502p4ns.exe NT (Intel) Server
502p4ds.exe NT (Dec Alpha) Server
502p495.exe Win95/98 Server
502p4ni.exe Windows NT SQL Interface
502p4da.exe Dec Alpha API
502p4na.exe NT and 32-bit Windows API
502p432.exe 32-bit Excel Client (Excel V7 and V8)
502p4lo.exe 32-bit Lotus 1-2-3 Client
502p4nd.exe 32-bit SQL Drill-Through

UNIX Files

502p4hs.tar HP-UX Server
502p4hi.tar HP-UX SQL Interface
502p4ha.tar HP-UX API
502p4ss.tar Solaris Server
502p4si.tar Solaris SQL Interface
502p4sa.tar Solaris API
502p4as.tar AIX Server
502p4ai.tar AIX SQL Interface
502p4aa.tar AIX API

Contents

Installing Patches from the Hyperion Solutions Web Site

The patch installation is similar to a full Hyperion Essbase installation, except that your sample applications, databases, and data files are not re-installed. Your existing applications and databases are not affected in any way. However, it is always a good idea to back up your applications and databases before an installation. For detailed information on Hyperion Essbase installations, see the Installation Notes.

Follow the patch installation instructions for the appropriate platform:

NT or Windows Servers and Clients

UNIX Servers and Clients

NT or Windows Servers and Clients

  1. Make sure Hyperion Essbase is not running when you perform the patch installation procedure.

  2. Before downloading the appropriate executable file(s), create a temporary local directory on the server or client machine, as appropriate.

  3. Connect to Hyperion's Technical Support Web site at:

    http://support.hyperion.com/ts

  4. Log in (if you aren't already logged in) and click "Patch Central."
  5. Select the appropriate software package, version, and platform.
  6. Download the appropriate file(s) to the temporary directory you created. For more information, see Files to Download.

    If you are installing more than one patch file, download the files into separate temporary directories before installing, or download and install one file, delete the file, and then download the next file.

  7. Unzip the file to the temporary directory by typing the name of the file (without the extension) from a command prompt, or by double-clicking the file.

    The executable file decompresses and runs SETUP.EXE, which launches the installation program.

  8. Follow the on-screen instructions to perform a full Hyperion Essbase installation. Install the patch over your existing installation, normally in C:\ESSBASE.

  9. After the installation is complete, you can delete the .EXE file from the temporary directory.

UNIX Servers and Clients

On UNIX platforms, the patch installation disables SQL Interface. SQL Interface must be reinstalled or reconfigured after installing the patch.

  1. Make sure Hyperion Essbase is not running when you perform the patch installation procedure.

  2. Before downloading the appropriate .tar file(s), create a temporary local directory on the server or client machine, as appropriate.

  3. Connect to Hyperion's Technical Support Web site at:

    http://support.hyperion.com/ts

  4. Click "Patch Central."

  5. Download the appropriate file(s) to the temporary directory you created. For more information, see Files to Download.

  6. To untar a file, enter the following command:

    tar -xf filename.tar

    from the temporary directory containing the .tar file. This command extracts the files necessary to perform a complete installation.

  7. Run essinst to launch the installation program.

  8. Follow the on-screen instructions to perform a full Hyperion Essbase installation.

  9. After the files are expanded, you can delete the .tar file.

Contents

Installing Patches from CD-ROM

The patch installation is similar to a full Hyperion Essbase installation, except that your sample applications, databases, and data files are not re-installed. Your existing applications and databases are not affected in any way. However, it is always a good idea to back up your applications and databases before an installation.

On UNIX platforms, the patch installation disables SQL Interface. SQL Interface must be reinstalled or reconfigured after installing the patch.

For detailed information on Hyperion Essbase installations, see the Installation Notes.

  1. Make sure Hyperion Essbase is not running when you perform the patch installation procedure.

  2. Before copying the appropriate patch file(s), create a temporary local directory on the server or client machine, as appropriate.

  3. Insert the CD-ROM into your CD-ROM drive.

  4. Select the appropriate executable files to copy to your local drive, based on the Files to Download section.

  5. Copy the appropriate file(s) to the temporary directory you created.

    If you are installing more than one patch file, download the files into separate temporary directories before installing, or download and install one file, delete the file, and then download the next file.

  6. Follow the instructions for the appropriate platform:

    For Windows platforms:

    For UNIX platforms:

  7. Follow the on-screen instructions to perform a full Hyperion Essbase installation.

Streamlined Installation Process

The Hyperion Essbase installation program has been made more efficient. The updated installation program:

As of Release 5.0.2 Patch 3, when you install over a previous release, only older versions of files in the ESSBASE/Bin directory are replaced. If the current installation contains files that are of the same version as the existing installation, those files are not replaced.

Reverting to an Earlier Release

If you are reverting to an earlier release of Hyperion Essbase, you must delete all files from the Bin directory except for ESSBASE.SEC and ESSBASE.CFG before you install the eariler release.

Contents

SQL Source Connectivity

INTERSOLV ODBC Drivers

INTERSOLV ODBC drivers, Version 3.11 on Windows NT, AIX, and Solaris, and Version 3.0.2 on HP-UX, are provided with Hyperion Essbase 5.0.2 Patch 3 (and later) SQL Interface. Hyperion Solutions has tested the following database configurations with 5.0.2 Patch 3.
Note: Hyperion Solutions tests only a limited number of driver configurations. Contact the provider of the driver if you have problems with a configuration.

Database Server (Client) NT 4.0 AIX 4.3 Solaris 2.6 HP-UX 10.20
DB2 5.0 (CAE 5.0) X X X -
DBASE V X - - -
Informix 7.22 (Client SDK 2.01) X - - -
Microsoft SQL Server 6.5.201 X N/A N/A N/A
Oracle 7.3.3 (SQL Net 2.3.3) unless specified. - X X X (2.3.4)
Oracle 8.0.4 (SQL Net 8.0) X - X -
Sybase 11.5 (Open Client 11.1.1) X X X -

Non-INTERSOLV ODBC Drivers

The following non-INTERSOLV drivers are not provided with Hyperion Essbase 5.0.2 SQL Interface. Hyperion Solutions has tested the following database configurations with 5.0.2 Patch 3.
Note: Hyperion Solutions tests and supports only a limited number of driver configurations. Contact the provider of the driver if you have problems with a configuration that Hyperion Solutions does not support.

Database Server (Driver and Client) NT 4.0 AIX 4.3 Solaris 2.6 HP-UX 10.20
Access 97 (Microsoft Driver) X - - -
DB2 5.0 (IBM Driver, CAE 5.0) - X - -
DBASE V (Microsoft driver) X - - -
Microsoft SQL Server 7 (Microsoft driver) X N/A N/A N/A
Oracle 8.0.4 (Oracle driver, SQL Net 8.0) X - - -

Contents

Copyright Information

Copyright (c) 1991-1999 by Hyperion Solutions Corporation.

All Rights Reserved.