Service Level: The components of this FixPak are shipped at the following service levels:
|
|
|
|
U.S. English Uppercase English |
|
|
Choose 1 of 2
(see instructions for details) |
|
|
(see instructions for details) |
|
|
(see instructions for details) |
|
What is Upper English? - Upper English FixPaks are intended for double-byte systems that require English commands to be in ALL UPPER CASE. These are typically systems that use Kanji characters. |
CAUTION!!! FixPak 4 (ShowCase STRATEGY 4.0) and later contains Java code, which entails extra steps for patching. In order for a fix to take affect, you must follow these instructions in order.
If the following message appears, the patch has not been applied.
CPF9801 - Object WSE050UU in library <SCSERVER> not found.
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)
Note: ShowCase is not the only application that uses these jobs, so you must make sure that there are no other programs using these jobs. This may require that you dedicate your AS/400.
(At this point, please be sure that Item 2 from Downloading the FixPak has completed. That item involves executing the file that was downloaded from the web, thus creating the larger .bin file that will be saved as an FTP file to the server.)
Password: <password>
230 <userid> logged on.
ftp> binary
ftp> put c:...\WSE050US.BIN QGPL/WSE050US
ftp> quit
C:\>
CAUTION!!! FixPak 4 (ShowCase STRATEGY 4.0) and later contains Java code, which entails extra steps for patching. In order for a fix to take affect, you must follow these instructions in order.
If the following message appears, the patch has not been applied.
CPF9801 - Object WSE050PP in library <SCSERVER> not found.
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)
Note: ShowCase is not the only application that uses these jobs, so you must make sure that there are no other programs using these jobs. This may require that you dedicate your AS/400.
(At this point, please be sure that Item 2 from Downloading the Patch has completed. That item involves executing the file that was downloaded from the web, thus creating the larger .bin file that will be saved as an FTP file to the server.)
Password: <password>
230 <userid> logged on.
ftp> binary
ftp> put c:...\WSE050PS.BIN QGPL/WSE050PS
ftp> quit
C:\>
Downloading the FixPak
This FixPak must be applied only to DB2 OLAP Server for AS/400 V7.1 (ShowCase STRATEGY 4.00, dated 10/16/00 or later). Refer to the instructions below for downloading and applying the FixPak.
Prerequisites for Applying the
FixPak
Note: Before installing the FixPak, be sure to read and follow the prerequisites listed above.
Password: <password>
230 <userid> logged on.
ftp> binary
ftp> put c:...\db2ptch.svf QGPL/UPDTSAVF
ftp> quit
C:\>
Downloading the FixPak
Applicable Versions
This FixPak applies to ShowCase ODBC and Warehouse
Builder version 4.0 and later. Apply this FixPak if you are using one of
these applications.
FixPak Installation Instructions.
Back to table of contents to continue installation
Undoing the FixPak
If you want or need to get back to the original files (before the FixPak was applied), you will find them in the BACKUP directory, which is located on the drive that the FixPak is run from. The BACKUP directory contains a file called unpatch.bak. This file is a script file containing the commands necessary to automatically restore the original files. To restore the original files (from any operating system environment):
If you apply multiple FixPaks over time without deleting the Backup directory, the BACKUP directory will contain multiple copies of FixPak files and the related original files from each backup. You may wish to periodically clean the BACKUP directory to recover disk space. To keep the most recent backup information, keep the latest unpatch.bak (or unpatch.bat if you already renamed it) file and the files listed in its text.
Back to table of contents to continue installation
This file describes problems corrected by one or more FixPaks for the OLAP clients of DB2 OLAP Server for AS/400, Version 7.1. Even if you have only one of the problems fixed in one of the FixPaks, you need to perform a full FixPak installation.
To install this FixPak, make sure your system has enough memory. Then download the files that match your operating systems and national languages and begin the installation. For complete installation instructions, see the OLAP Setup and User's Guide.
To stop Windows NT services:
|
Contents | National
Languages |
---|---|---|
wincd.zip file |
Spreadsheet add-in for Excel Spreadsheet add-in for Lotus 1-2-3 |
Japanese
Korean Simplified Chinese Traditional Chinese English French German Italian Spanish Brazilian Portuguese Danish Finnish Norwegian Swedish Czech Hungarian Russian |
c:\tempTo change your Windows 2000 TMP User Variable and TEMP Environment Variable, take these steps:
Your applications are automatically migrated to FixPak 4 when you open them.
FixPak 4 and later adds the following features
and changes to DB2 OLAP Server V7.1:
The Hyperion Essbase calculator language can now be extended through the creation of custom-defined macros and functions.
The Java runtime environment included this FixPak is not set up for general use by other Java applications on your system. This fixpack does not define a path to the Java JRE in either your system environment variables or user environment variables; the JRE will not interfere with other Java environments already on your system.
New Calculator functions:
Member Set Functions:
Mathematical Functions:
The parallel export process works only with the multidimensional
storage manager, not the relational storage manager.
- PAREXPORT--Executes a parallel export by enabling you to specify the number of export threads to be used, export filename(s) for the data, the type of data to export, and and how the data is to be exported.
FixPaks 3 and 1.5 fix defects listed in
the Problem Summary. These FixPaks do not introduce
any new function.
http://www.ibm.com/software/data/db2/db2olap/library.html
In FixPak 4: The following books for DB2 OLAP Server have been updated to the Hyperion Essbase 6.1 level and are shipped starting in FixPak 4:
If you have filtered
access to a linked partition database, then you may encounter a server
crash while launching the partition. (13907, P3)
If you have Read-only privilege
to a filter on a linked partition database, attempting to launch the partition
may result in an exception file and a server crash.
Attempting to validate
a linked partition fails. (19115, P3)
If you create a linked
partition database and map the source outline to the target outline, attempting
to validate the partition may generate the error message, "Target dimension
count mismatches in Area One."
When you perform a default
calculation containing FIX( @IDESCENDANTS(COMPANY,-1)), the database restructure
fails. (19284, P3)
When you are performing
default calculation containing FIX( @IDESCENDANTS(COMPANY,-1)) for a database,
the settings in the Set Default Calc dialog box may change from the Use
Calc Script Object option to the Use String option, and the statement FIX(@IDESCENDANTS(COMPANY,
-1) may be truncated. As a result, your attempt to perform a database restructure
may fail.
If dimension names are
similar but not duplicate, the Essbase Member Selection dialog box displays
an incorrect dimension. (19413, P3)
If an outline has similar
dimension names, the Essbase Member Selection dialog box may ignore the
dimension that is selected on a spreadsheet and display an incorrect dimension
and its members.
In Hyperion Essbase OLAP
Server, the Agent messages are mistranslated. (19476, 19937, P3)
In Hyperion Essbase OLAP
Server, the following messages may be mistranslated: "port," "ports available,"
"connections in use," and "ports in use."
The Linked Objects Browser
dialog box does not display the scroll bar. (19500, P3)
When you open the Linked
Objects Browser dialog box, the scroll bar may not be visible at the bottom
of the dialog box. The scroll bar may be displayed when you enlarge the
dialog box or try to resize the columns.
In Hyperion Essbase Spreadsheet
Add-in for Lotus 1-2-3, the context-sensitive help is mistranslated. (19508,
P3)
In Hyperion Essbase Spreadsheet
Add-in for Lotus 1-2-3, the context-sensitive helps may not be translated.
The default query name
is not translated in the Hyperion Essbase Query Designer dialog box. (19510,
P3)
In the Hyperion Essbase
Query Designer dialog box of Hyperion Essbase Spreadsheet Add-in for Excel,
the default name assigned to a new query may not be translated.
In the Hyperion Essbase
Query Designer dialog box, the drop-down list box name is truncated. (19532,
P3)
In the Hyperion Essbase
Query Designer dialog box, the Data Sort panel drop-down list box name,
Ordering, may be truncated. The problem may be noticeable in non-English
versions of Hyperion Essbase Spreadsheet Add-in.
The short cut key to
select Enable Secondary Button does not function properly. (19595, P3)
In Hyperion Essbase Spreadsheet
Add-in, in the Global tab section of the Essbase Options dialog box, the
short cut key for selecting Enable Secondary Button fails.
After retrieving data
for a new query, the mouse pointer does not change back to an arrow. (19697,
P3)
In Hyperion Essbase Spreadsheet
Add-in for Lotus 1-2-3, after retrieving data for a new query in the Hyperion
Essbase Query Designer dialog box, the mouse pointer may not change back
to an arrow.
F1 key does not consistently
display help in Hyperion Essbase Spreadsheet Add-in. (19918, P3)
In Hyperion Essbase Spreadsheet
Add-in, the F1 key does not consistently display Essbase Help.
In non-English versions
of Hyperion Essbase OLAP Server, while initializing Essbase.exe, the server
requires the English characters. (19988, P3)
In non-English versions
of Hyperion Essbase OLAP Server, such as on German NT, while initializing
Essbase.exe, the confirmation message accepts the English alphabet "Y"
instead of a language-independent value.
The Find option in the
Edit menu of the Member Selection dialog box does not function properly.
(20266, P3)
In Hyperion Essbase Spreadsheet
Add-in, when you use the Find option to locate a value for a member that
is selected in the Member Selection dialog box and using a Windows Server,
the Find option may search for the value incorrectly.
Cannot delete the Server
log if the Application Server is running on Windows 95/98. (20630, P3)
In Hyperion Essbase Application
Manager, You cannot delete the Server log if the Application Server is
running on Windows 95/98.
Attempting to rename
a Boolean attribute member corrupts the outline. (20901, P3)
In Hyperion Essbase Application
Manager, if you attempt to rename a Boolean attribute member directly on
the outline and then enter the changes in the Boolean Member Names fields
of the Attribute Member Names dialog box, when you reopen the outline,
you may find the outline is corrupted.
If a dimension consists
of more than 32 members with a single non-consolidated child, the attribute
association with that dimension is erroneous. (21933, 23982, 25014 P3)
If there are more than
32 members in one dimension, and that dimension contains a parent with
exactly one child that does not consolidate to its parent, an attempt to
associate attributes to that dimension may result in a corrupt outline,
with no error message.
Attribute query with
sparse Two-Pass calculation members returns incorrect values. (22752, P3)
If the attribute query
contains a sparse Two-Pass Dynamic Calc member, and the calculation formula
refers to some blocks that are not included in the query, the result of
the attribute query may not include the missing blocks.
The retrieval time increases
compared to the previous releases of Hyperion Essbase OLAP Server. (22836,
24397 P3)
When retrieving data on
a large number of sparse member combinations, the retrieval process is
slower than the previous releases of Hyperion Essbase OLAP Server.
Calculation script does
not set cells to #MISSING. (22961, 25168 P3)
In a calculation script,
if a formula on a sparse member results in #MISSING, cells may
not be updated.
While importing an outline
from a rules file, you receive a segmentation fault. (23115, P3)
In MaxL, while importing
an outline from a rules file, you may notice a segmentation fault.
The application crashes
while retrieving data on an attribute dimension. (23211, P3)
In Hyperion Essbase Spreadsheet
Add-in, an attempt to retrieve data on an attribute dimension may crash
the application.
The "Allow" settings
may fail if a supervisor attempts to log in. (23657, P3)
If you disallow commands,
connects, or updates through Application Manager in the Application Settings
dialog box, through the SETAPPSTATE command in Esscmd, or using the "alter
application" command in MaxL, the settings may change if another supervisor
simultaneously attempts to log in.
Shared members of a sparse
Dynamic Calc member are not aggregated. (23865, P3)
Batch calculations involving
shared members that are shared members of sparse Dynamic Calc members may
produce incorrect results.
An EQD (Essbase Query
Designer) query for more than 65536 rows crashes a spreadsheet. (23871,
P3)
Using Hyperion Essbase
Query Designer, attempting to create queries for more than the limit of
65536 rows crashes the spreadsheet.
When attribute dimensions
are added, calculations are performed incorrectly during data retrieval.
(23881, P3)
In Hyperion Essbase Spreadsheet
Add-in or Report Writer, when attribute dimensions are added, calculations
may be performed incorrectly on Two-Pass member formulas during data retrieval.
Queries involving attributes
and Two-Pass calculation members may sometimes yield incorrect results.
(23903, P3)
If a query involving attributes
references a Two-Pass member and that two-pass member is dependent in turn
on other two pass member(s) the query results may sometimes be incorrect.
The Visual Basic API
function, EsbGetApplicationInfoEx, returns incorrect number of users connected.
(23911, P3)
Although the user is connected
to an application and a database, the Visual Basic API function, EsbGetApplicationInfoEx,
may return zero users connected with no error code.
When performing a replicated
partition on a large amount of data, an exception file is generated. (24051,
P3)
In Hyperion Essbase Application
Manager, when you perform a replicated partition on a large amount of data,
the replicated partition may fail, resulting in a network error and an
exception file.
The Visual Basic API
function, EsbLROAddObject(), generates an application error. (24116, P3)
When the Visual Basic Main
API function, EsbLROAddObject, is applied to associate linked reporting
objects to a cell, the error message, "Cell: EXCEL.EXE - Application Error"
may occur.
In an outline, the dimension
order affects XREF results. (24281, P3)
XREF may return incorrect
results if the dimension order in the source cube differs from the dimension
order in the target cube.
Calculation never finishes
across a transparent partition database. (24292, P3)
Transparent partitions
may cause the database calculation to run infinitely.
Retrieving data on a
spreadsheet containing a generation name produces an exception log and
crashes the application. (24384, P3)
If you attempt to retrieve
data on a spreadsheet containing a generation name, you may encounter an
exception log and application crash.
While loading data, if
the data file consists of attribute members, some data are skipped. (24477,
P3)
While loading data, if
the data file consists of attribute members, Hyperion Essbase OLAP Server
may skip the remaining records after the first attribute member.
Using the Grid API function,
BeginConditionalZoomIn, with the report specification, {UCHARACTERS}, causes
a crash. (24521, P3)
If using the BeginConditionalZoomin
function with the report specification, {UCHARACTERS}, results in an underlined
character string longer than 127 characters, the Grid API program may crash.
During multiple bitmap
mode calculation, excessive memory is allocated. (24552, P3)
When there are many shared
members in the last sparse dimension, multiple bitmap mode calculation
may use too much memory. Set the configuration parameter MultipleBitmapMemCheck
to TRUE to prevent the excessive use of memory.
Attempting to validate
an outline while performing incremental building generates an error message.
(24557, P3)
While performing incremental
dimension building, if you try to validate the outline, the incremental
dimension building process fails and generates an error message.
If a query involving
too many dynamic calculations with complex formulas fails to execute because
of insufficient memory on the server, the application crashes instead of
the query failing. (24669, P3)
If a query involving too
many dynamic calculations with complex formulas fails to execute because
of insufficient memory on the server, the application crashes instead of
the query failing.
An attribute calculation
with Two-Pass calculation returns inconsistent results. (24786, P3)
If you attempt to perform
attribute calculations with Two-Pass calculation repeatedly, you may encounter
inconsistent results.
Programs with multiple
calls to EsbOtlGetAssociatedAttributes and EsbOtlGetMemberInfo result in
a crash. (24807, P3)
Using the Visual Basic
Main API functions, EsbOtlGetAssociatedAttributes and EsbOtlGetMemberInfo
repeatedly may crash the Visual Basic program.
Registering more than
20,000 Essbase users to Hyperion Essbase OLAP Server gives fatal error
when restarting. (24875, P3)
After registering 20,000
users to Hyperion Essbase OLAP Server, if you terminate Essbase and then
restart, you may encounter the error message, "Fatal Error: Error reading
security file [22]."
Retrieving data on a
blank cell results in an application crash. (24895, P3)
If you try to retrieve
data on a blank cell, the application may crash with an exception file.
In Hyperion Essbase Application
Manager Japanese version, the Dynamic Time Series (DTS) settings cannot
be saved. (24905, P3)
Hyperion Essbase Application
Manager Japanese version may not retain the DTS settings.
While retrieving data
on sparse dynamic calculation members, you may receive incorrect results.
(24976, P3)
If the formula is executed
in a cell mode, attempting to retrieve data on sparse dynamic calculation
members may result in incorrect #MISSING values.
The Grid API function,
EssGetApplicationInfoEx(), generates the error 1051030 when you pass a
Null parameter to it. (24982, P3)
The use of a Null value
as the second parameter in the Grid API function, EssGetApplicationInfoEx(),
generates the error message 1051030, "Application does not exist."
The Agent hangs when
another user attempts to access the same application while filters are
being verified. (25089, P3)
Hyperion Essbase OLAP Agent
may hang if one user attempts to verify a filter, while another user attempts
to access the same application.
Attempting to perform
a zoom in on attribute members may result in the Spreadsheet Extractor
error 1130001. (25127, P3)
If you attempt to expand
attribute members, you may receive the Spreadsheet Extractor error 1130001.
Attempting to retrieve
data on attribute members crashes the server. (25278, P3)
Attempting to retrieve
data on specific attribute members results in an exception log and application
crash.
Creating 60,000 filters
causes the server to crash and corrupt security files. (25298, P3)
If you try to create 60,000
filters using the ESSCMD, copy filter command, the server may crash with
an exception segmentation violation. Moreover, if you attempt to restart
Hyperion Essbase OLAP Server, you may receive an error message, "The security
file is corrupted."
A database may lose its
currency link upon stopping the Essbase Agent. (25364, P3)
If you shutdown Hyperon
Essbase OLAP Server, the currency link to your database may disappear.
Deleting a shared member
removes all data from the actual member. (25376, P3)
If you delete a shared
member, all data from the actual member may be deleted.
Attempting to retrieve
data on attribute members across transparent partitions results in incorrect
values. (25585, P3)
If you perform a retrieval
on attribute members from a target database of a transparent partition,
you may receive incorrect results.
Using the ESSCMD command,
ENDARCHIVE, the .cfg setting _SM__BUFFERED_IO TRUE results in a crash.
(25715, P3)
With the .cfg setting __SM__BUFFERED_IO
TRUE, if you attempt to complete archiving of data using the ESSCMD command,
ENDARCHIVE, or the MaxL command END ARCHIVE, the application may crash.
The .cfg setting, __SM__BUFFER_IO
TRUE, erroneously returns zero values. (25789, P3)
If the buffered IO setting
is set to True, the calculated values may erroneously return zeros.
Sub-optimal performance
for formulas executed in top-down mode. (26003, P3)
If a formula attached to
a member is executed in a top-down mode as indicated in the application
log file, performance may be sub-optimal.
Locking and sending data
to the target of a transparent partition may not work. (12008, P2)
When using either Hyperion
Essbase Spreadsheet Add-in with Free-Form interpretation or the C or Visual
Basic API, an attempt to lock and send data to the target of a transparent
partition may fail and generate the following error message: Error the
1014004 - Unable to update members which have not been locked.
Syntax checker does not
move to the problematic line. (14020, 15997 P2)
When the syntax checker
is run in the Calc Script Editor, and if an error is found, the window
may not scroll to show the problematic line. To locate the line, you may
have to scroll through the calculation script text to find the highlighted
information.
Performing an Edit >
Replace on a large calculation script will delete some portions from the
calculation script. (18490, P2)
In Hyperion Essbase Application
Manager, performing an Edit > Replace on a large calculation script may
stop the replace process or delete the replaced text and may subsequently
generate the following message, "Text is not found. Do you want to start
at the beginning of the file?"
If an Excel spreadsheet
consists of unknown members, retrieving with Repeat Member Labels selected
may result in a corrupted spreadsheet. (18733, P2)
In Hyperion Essbase Spreadsheet
Add-in, retrieving for unknown members with Repeat Member Labels selected
may return scrambled data.
Column shifts to the
left after a Keep Only. (18973, P2)
In Hyperion Essbase Spreadsheet
Add-in, an attempt to perform a Keep Only may shift the first column to
the left.
Database state does not
get updated when the data load is partially successful. (19176, P2)
If a data load is partially
successful when you select Database > Calculate, you may encounter the
message, "the database does not contain any data" even if the database
contains data.
NLS characters get corrupted
for object name when viewed in the server console. (19546, P2)
User, Database, and Application
names containing non-English European characters are not displayed correctly
in the server console.
In Lotus 1-2-3, NLS characters
in cascading filenames are displayed incorrectly. (19833, P2)
In Hyperion Essbase Spreadsheet
Add-in for Lotus 1-2-3, non-English European characters are incorrectly
displayed in the filename when specifying them in the prefix, suffix, or
workbook text box in the Cascade Options dialog box.
Incorrect SSAUDITR setting
in .CFG corrupts database. (19844, P2)
An incorrect SSAUDITR setting
in the Essbase.CFG may give the error message, "unable to connect to database"
when you attempt to connect to the database in any client program.
In Hyperion Essbase Application
Manager Japanese version, Field Properties dialog box contains mangled
characters. (19953, P2)
In Hyperion Essbase Application
Manager Japanese version, in the Data Prep Editor, you may find some mangled
characters in the Data Load Properties and the Dimension Building Properties
tabs of the Field Properties dialog box.
When searching for a
string, the Calc Script Editor does not scroll through to locate it. (20492,
P2)
When updating a calculation
script, the Edit > Find function does not cause the window to scroll to
the next occurrence and locate the string that you are searching for.
The first part of the
formula disappears when you use Flashback. (20589, P2)
When using Hyperion Essbase
Spreadsheet Add-in with Lotus 1-2-3, an attempt to retrieve data on a formula
that has an error followed by a Flashback may cause the first part of the
formula to disappear.
EsbGetDatabaseState does
not return default or modified values. (20626, P2)
The VB API routine, EsbGetDatabaseState,
does not return correct values in the ESB_DBSTATE_T structure. In particular,
the default values for Retrieval Buffer Size and Sort Buffer Size are either
0 or incorrect. Additionally, any new values that you enter through Hyperion
Essbase
Application Manager are ignored.
@SUM function does not
work correctly with User Defined Attribute (UDA). (20758, P2)
@SUM function may not work
correctly with more than one macro as its expList.
Incorrect handling of
operators, such as AND and OR inside a FIX statement. (20766, P2)
FIX command involving member
functions used with AND, OR operators may generate incorrect member sets.
While using the @CHILDREN
function, you cannot put space between the parentheses and the member name.
(21174, P2)
While using the @CHILDREN
function within a FIX statement, inserting a blank space between the parentheses
and the member name may yield an error message.
Zoom In results in an
error message if maximum number of rows exceeds 8,192. (21242, 23210 P2)
In Hyperion Essbase Spreadsheet
Add-in with Lotus 1-2-3, an attempt to zoom into more than 8,192 rows may
result in an error message.
Generating an exception
log file, while synchronizing outlines causes the application to crash.
(21293, P2)
While synchronizing outlines,
a crash may occur and an exception error log is generated when using an
alias in the partition definition.
Error in outline synchronization
with transparent partition on a shared member. (21620, P2)
During outline synchronization,
an attempt to add both shared and regular members in the same dimension
to a target database may not add the shared member, and it may give the
error message, "There is 1 Message in the application log identifying a
change that was not applied during the outline synch."
Calculation on a transparent
partition seems to run indefinitely. (21651, P2)
Two types of formulas,
Constant Assignment and Forward References, when attached to a sparse member,
trigger top-down execution. But the application log may not contain messages
indicating top-down execution.
Creating Hyperion Essbase
directory names with more than eight characters may generate an exception
error log file and hinder the data restructure process.
Translation for Member
Selection is incorrect. (21744, P2)
In Hyperion Essbase Spreadsheet
Add-in with Excel, Essbase Member Selection features are erroneously translated.
For example, "insert list before active cell" translation is misleading.
Also, the message at the bottom of the Member Preview dialog box is mistranslated.
This problem is noticed in Hyperion Essbase Spreadsheet Add-in Release
6.0 P1 Japanese version.
Text type attribute member
having only numeric values does not get associated. (21748, P2)
While using a rules file
to associate the attribute members with the base member, a text type attribute
member that contains only numeric values and begins with the 0 may not
get associated with the base member.
Zoom In may cause incorrect
results if Essbase Options are checked. (21785, P2)
In Hyperion Essbase Spreadsheet
Add-in, when the options, Display > Cell > Repeat Member Labels and Zoom
> Member Retention > Remove Unselected Groups are selected, an attempt
to zoom in may cause incorrect results.
When the row header has
invalid alias name, the Excel spreadsheet shows incorrect values. (21804,
P2)
In Hyperion Essbase Spreadsheet
Add-in, if the option Use Both Member Names and Aliases for Row Dimensions
is selected, retrieving may result in incorrect values when row members
contain invalid alias names.
Case sensitivity does
not work correctly during dimension building. (21906, P2)
Case sensitivity may not
function correctly and may cause the server to freeze during dimension
building.
Zoom Out does not function
correctly if Formula Preservation is checked. (21949, P2)
When Formula Preservation
is selected in Hyperion Essbase Spreadsheet Add-in, zoom out may give erroneous
results.
Attribute dimension building
corrupts the outline. (22020, 22325, P2)
When a user tries to build
and associate an attribute dimension on the base dimension, Hyperion Essbase
Application Manager randomly associates attributes at all levels and corrupts
the outline.
Internal Rate of Return
(@IRR) function produces incorrect results. (22163, P2)
Using @IRR in a calculation
script may produce incorrect Retrieve results.
Database restructure
causes the application to crash. (22206, P2)
If a member is renamed
after another member that is deleted, the new member may map to both previous
and existing members and cause the server to crash.
"Invalid Block Header"
error following a calculation script or other long running update operation.
(22256, P2)
Error 1006010 or 1006016
appears following a calculation script or other long-running update operation.
Although the problem has been corrected by this patch, the error message
indicates that the database was corrupted. This patch will not fix corruption
that has already occurred. You must therefore restore the most recent clean
backup of the database or start over with an empty database.
Lotus 1-2-3 results in
an error message if #MISSING is set to 0. (22333, P2)
In Hyperion Essbase Spreadsheet
Add-in with Lotus 1-2-3, if the #MISSING label is set to zero
and there is no data, an error message is produced stating, "The sheet
contains an unknown member 0."
Dimension building for
base member hierarchy does not work properly. (22350, 22695 P2)
Dimension building for
a base member hierarchy may not work properly when using the generation
build method. The rules file does not contain attribute member associations,
but when the rules file updates the outline, it assigns attributes to members
of different levels.
A crash may occur when
verifying an outline containing lengthy date and numeric attribute member
names. (22395, P2)
If a full name of a date
or numeric attribute member, including parents and ancestors when applicable,
is larger than 80 characters, an attempt to save or validate the outline
may cause a crash.
Loading and unloading
data for a 250 GB database may result in a memory leak. (22412, P2)
When starting Hyperion
Essbase OLAP Server, building dimensions by Dynamic Dimension Build, uploading
data by Dynamic Data Load, and calculating and then shutting down Hyperion
Essbase OLAP Server, allocated memory may not be released and the operating
system may crash.
The C API routine, ESSCMD
EssOtlOpenOutlineQuery, leads to a memory leak. (22543, P2)
The C API function, EssOtlOpenOutlineQuery,
allocates memory that is not released in EssOtlFreeMembers as it should
be, which eventually seriously hinders system performance.
After default calculation
lower level data may override upper level data. (22742, P2)
When Aggregate Missing
is off, lower level consolidation that results in #Missing may
override upper level data.
Data not rolling up properly
when using an attribute dimension. (22756, P2)
When an attribute dimension
is used, Hyperion Essbase Spreadsheet Add-in and Report Writer may not
generate correct data roll-up.
The ESSCMD GETDBSTATS
fails when executed. (22816, P2)
Then ESSCMD GETDBSTATS
may not function if it is executed on a cube whose dimension name consists
of a particular character, such as '%n.'
The ESSCMD EssOtlQueryMembers
returns wrong result when outline exceeds 16K members. (22853, P2)
The outline API, routine
EssOtlQueryMembers, does not return the correct number of outline members
when the outline contains more than 16K members.
Sparse restructure causes
Linked Reporting Object (LRO) counter to be reset. (22926, P2)
When adding a new LRO immediately
after a sparse restructure, the following error occurs: "Object # already
exists".
Unable to initialize
GRID API when Regional Setting is German (Austrian). (22962, P2).
The GRID API will fail
to initialize when the Regional Setting in the Control Panel is set to
German (Austrian).
Memory leak in EssVSetSheetOption
and EssVSetGlobalOption. (22998, P2)
The VBA routines, EssVSetSheetOption
and EssVSetGlobalOption, leak memory on Windows 95/98 clients, causing
degraded performance when they are used repeatedly.
"Cannot access object:
Ess00000.TMP" error when running 4 batch jobs. (23034, P2)
When running concurrent
programs that use the Outline API, Hyperion Essbase OLAP Server occasionally
cannot create temporary file names and displays the error message, "Cannot
access object: Ess00000.TMP."
Hyperion Essbase Application
Manager is not displaying the Disk Volume. (23059, P2)
The Storage tab on the
Database Settings dialog box in Hyperion Essbase Application Manager contains
a table that is not always in synchronization with the Disk Volume edit
field or updated when changes are made to the disk volumes.
EssCell may not work
for Dynamic Time Series. (23119, P2)
In Hyperion Essbase Spreadsheet
Add-in, running EssCell (Y-T-D) on an outline with attributes may return
#MISSING
instead
of the Y-T-D value.
EssVGetDataPoint returns
incorrect values for Dynamic Time Series. (23130, P2)
When using Dynamic Time
Series in a spreadsheet to return a specific H-T-D (April), the EssVGetDataPoint
mistakenly returns "H-T-D" instead of "H-T-D(April)."
Sparse Dynamic Calc fails
in a calculation script. (23156, P2)
If a calculation of a stored
member depends on a virtual block, either through parent-child relationship
or through formula, calculation of the virtual block may not be triggered
correctly, causing incorrect results for the stored member.
GRID API crashes with
multiple concurrent logins and logouts on a multiprocessor machine. (23175,
P2)
The GRID API may crash
on connect or disconnect when using multiple threads on a multiprocessor
machine.
Data is incorrect when
aggregated with Create Block on Equation and from bottom-up. (23274, P2)
When using SET FRMLBOTTOMUP
ON, the dependencies of top-down formulas may be processed incorrectly,
causing some blocks to be missed during calculation.
EssVGetDataPoint function
does not return correct data for a first page header. (23275, P2)
EssVGetDataPoint function
may not work properly for the first page header of a query unless the cell
being inquired is in the first column.
Division by values between
.000000000000004 and -.000000000000004 results in a #MISSING.
(23375, P2)
In Hyperion Essbase OLAP
Server Release 6.1, the division with denominator values between .000000000000004
and -.000000000000004 may result in a #MISSING.
While ignoring the TimeStamp
parameter, EsbGetLogFile returns the entire log. (23396, P2)
The Visual Basic API routine,
EsbGetLogFile, ignores the TimeStamp parameter and returns the entire log
file rather than the entries of the log file produced after the date and
time specified by the TimeStamp parameter.
@XREF triggered by a
query will not automatically log off the source database. (23470, P2)
Queries involving Dynamic
Calculations with @XREF leave users logged into the remote sources of @XREF
references.
The server produces incorrect
results if the number of blocks to be locked exceeds the LOCKBLOCK setting.
(23656, P2)
When using formulas on
sparse members for which the number of blocks to be locked exceeds the
LOCKBLOCK setting, the current LOCKBLOCK setting may not return correct
values.
After moving members
of a sparse dimension, the server crashes while doing a base level restructure
(23925, P2)
After moving a sparse dimension
member, an attempt to restructure at the base level may result in a network
error, 10054, or may even cause the data to disappear.
Some ESSBASE.CFG
settings are not displayed in the Essbase Configuration panel of the Server
Information in Hyperion Essbase Application Manager. (7381, P2)
Some dialog box settings
in ESSBASE.CFG are not displayed in Hyperion Essbase Application Manager
Server > Information > Essbase configuration.
Locking and sending data
to the target of a transparent partition may not work. (12008, P2)
When using either Hyperion
Essbase Spreadsheet Add-in with Free-Form interpretation or the C or Visual
Basic API, an attempt to lock and send data to the target of a transparent
partition may fail and generate the following error message: Error the
1014004 - Unable to update members which have not been locked.
Syntax checker does not
move to the problematic line. (14020, 15997 P2)
When the syntax checker
is run in the Calc Script Editor, and if an error is found, the window
may not scroll to show the problematic line. To locate the line, you may
have to scroll through the calculation script text to find the highlighted
information.
Performing an Edit >
Replace on a large calculation script will delete some portions from the
calculation script. (18490, P2)
In Hyperion Essbase Application
Manager, performing an Edit > Replace on a large calculation script may
stop the replace process or delete the replaced text and may subsequently
generate the following message, "Text is not found. Do you want to start
at the beginning of the file?"
If an Excel spreadsheet
consists of unknown members, retrieving with Repeat Member Labels selected
may result in a corrupted spreadsheet. (18733, P2)
In Hyperion Essbase Spreadsheet
Add-in, retrieving for unknown members with Repeat Member Labels selected
may return scrambled data.
Column shifts to the
left after a Keep Only. (18973, P2)
In Hyperion Essbase Spreadsheet
Add-in, an attempt to perform a Keep Only may shift the first column to
the left.
Database state does not
get updated when the data load is partially successful. (19176, P2)
If a data load is partially
successful when you select Database > Calculate, you may encounter the
message, "the database does not contain any data" even if the database
contains data.
NLS characters get corrupted
for object name when viewed in the server console. (19546, P2)
User, Database, and Application
names containing non-English European characters are not displayed correctly
in the server console.
In Lotus 1-2-3, NLS characters
in cascading filenames are displayed incorrectly. (19833, P2)
In Hyperion Essbase Spreadsheet
Add-in for Lotus 1-2-3, non-English European characters are incorrectly
displayed in the filename when specifying them in the prefix, suffix, or
workbook text box in the Cascade Options dialog box.
Incorrect SSAUDITR setting
in .CFG corrupts database. (19844, P2)
An incorrect SSAUDITR setting
in the Essbase.CFG may give the error message, "unable to connect to database"
when you attempt to connect to the database in any client program.
In Hyperion Essbase Application
Manager Japanese version, Field Properties dialog box contains mangled
characters. (19953, P2)
In Hyperion Essbase Application
Manager Japanese version, in the Data Prep Editor, you may find some mangled
characters in the Data Load Properties and the Dimension Building Properties
tabs of the Field Properties dialog box.
When searching for a
string, the Calc Script Editor does not scroll through to locate it. (20492,
P2)
When updating a calculation
script, the Edit > Find function does not cause the window to scroll to
the next occurrence and locate the string that you are searching for.
The first part of the
formula disappears when you use Flashback. (20589, P2)
When using Hyperion Essbase
Spreadsheet Add-in with Lotus 1-2-3, an attempt to retrieve data on a formula
that has an error followed by a Flashback may cause the first part of the
formula to disappear.
EsbGetDatabaseState does
not return default or modified values. (20626, P2)
The VB API routine, EsbGetDatabaseState,
does not return correct values in the ESB_DBSTATE_T structure. In particular,
the default values for Retrieval Buffer Size and Sort Buffer Size are either
0 or incorrect. Additionally, any new values that you enter through Hyperion
Essbase Application Manager are ignored.
@SUM function does not
work correctly with User Defined Attribute (UDA). (20758, P2)
@SUM function may not work
correctly with more than one macro as its expList.
Incorrect handling of
operators, such as AND and OR inside a FIX statement. (20766, P2)
FIX command involving member
functions used with AND, OR operators may generate incorrect member sets.
While using the @CHILDREN
function, you cannot put space between the parentheses and the member name.
(21174, P2)
While using the @CHILDREN
function within a FIX statement, inserting a blank space between the parentheses
and the member name may yield an error message.
Zoom In results in an
error message if maximum number of rows exceeds 8,192. (21242, 23210 P2)
In Hyperion Essbase Spreadsheet
Add-in with Lotus 1-2-3, an attempt to zoom into more than 8,192 rows may
result in an error message.
Generating an exception
log file, while synchronizing outlines causes the application to crash.
(21293, P2)
While synchronizing outlines,
a crash may occur and an exception error log is generated when using an
alias in the partition definition.
Error in outline synchronization
with transparent partition on a shared member. (21620, P2)
During outline synchronization,
an attempt to add both shared and regular members in the same dimension
to a target database may not add the shared member, and it may give the
error message, "There is 1 Message in the application log identifying a
change that was not applied during the outline synch."
Calculation on a transparent
partition seems to run indefinitely. (21651, P2)
Two types of formulas,
Constant Assignment and Forward References, when attached to a sparse member,
trigger top-down execution. But the application log may not contain messages
indicating top-down execution.
Creating Hyperion Essbase
directory names with more than eight characters may generate an exception
error log file and hinder the data restructure process.
Translation for Member
Selection is incorrect. (21744, P2)
In Hyperion Essbase Spreadsheet
Add-in with Excel, Essbase Member Selection features are erroneously translated.
For example, "insert list before active cell" translation is misleading.
Also, the message at the bottom of the Member Preview dialog box is mistranslated.
This problem is noticed in Hyperion Essbase Spreadsheet Add-in Release
6.0 P1 Japanese version.
Text type attribute member
having only numeric values does not get associated. (21748, P2)
While using a rules file
to associate the attribute members with the base member, a text type attribute
member that contains only numeric values and begins with the 0 may not
get associated with the base member.
Zoom In may cause incorrect
results if Essbase Options are checked. (21785, P2)
In Hyperion Essbase Spreadsheet
Add-in, when the options, Display > Cell > Repeat Member Labels and Zoom
> Member Retention > Remove Unselected Groups are selected, an attempt
to zoom in may cause incorrect results.
When the row header has
invalid alias name, the Excel spreadsheet shows incorrect values. (21804,
P2)
In Hyperion Essbase Spreadsheet
Add-in, if the option Use Both Member Names and Aliases for Row Dimensions
is selected, retrieving may result in incorrect values when row members
contain invalid alias names.
Case sensitivity does
not work correctly during dimension building. (21906, P2)
Case sensitivity may not
function correctly and may cause the server to freeze during dimension
building.
Zoom Out does not function
correctly if Formula Preservation is checked. (21949, P2)
When Formula Preservation
is selected in Hyperion Essbase Spreadsheet Add-in, zoom out may give erroneous
results.
Attribute dimension building
corrupts the outline. (22020, 22325, P2)
When a user tries to build
and associate an attribute dimension on the base dimension, Hyperion Essbase
Application Manager randomly associates attributes at all levels and corrupts
the outline.
Internal Rate of Return
(@IRR) function produces incorrect results. (22163, P2)
Using @IRR in a calculation
script may produce incorrect Retrieve results.
Database restructure
causes the application to crash. (22206, P2)
If a member is renamed
after another member that is deleted, the new member may map to both previous
and existing members and cause the server to crash.
"Invalid Block Header"
error following a calculation script or other long running update operation.
(22256, P2)
Error 1006010 or 1006016
appears following a calculation script or other long-running update operation.
Although the problem has been corrected by this patch, the error message
indicates that the database was corrupted. This patch will not fix corruption
that has already occurred. You must therefore restore the most recent clean
backup of the database or start over with an empty database.
Lotus 1-2-3 results in
an error message if #MISSING is set to 0. (22333, P2)
In Hyperion Essbase Spreadsheet
Add-in with Lotus 1-2-3, if the #MISSING label is set to zero
and there is no data, an error message is produced stating, "The sheet
contains an unknown member 0."
Dimension building for
base member hierarchy does not work properly. (22350, 22695 P2)
Dimension building for
a base member hierarchy may not work properly when using the generation
build method. The rules file does not contain attribute member associations,
but when the rules file updates the outline, it assigns attributes to members
of different levels.
A crash may occur when
verifying an outline containing lengthy date and numeric attribute member
names. (22395, P2)
If a full name of a date
or numeric attribute member, including parents and ancestors when applicable,
is larger than 80 characters, an attempt to save or validate the outline
may cause a crash.
Loading and unloading
data for a 250 GB database may result in a memory leak. (22412, P2)
When starting Hyperion
Essbase OLAP Server, building dimensions by Dynamic Dimension Build, uploading
data by Dynamic Data Load, and calculating and then shutting down Hyperion
Essbase OLAP Server, allocated memory may not be released and the operating
system may crash.
The C API routine, ESSCMD
EssOtlOpenOutlineQuery, leads to a memory leak. (22543, P2)
The C API function, EssOtlOpenOutlineQuery,
allocates memory that is not released in EssOtlFreeMembers as it should
be, which eventually seriously hinders system performance.
After default calculation
lower level data may override upper level data. (22742, P2)
When Aggregate Missing
is off, lower level consolidation that results in #Missing may
override upper level data.
Data not rolling up properly
when using an attribute dimension. (22756, P2)
When an attribute dimension
is used, Hyperion Essbase Spreadsheet Add-in and Report Writer may not
generate correct data roll-up.
The ESSCMD GETDBSTATS
fails when executed. (22816, P2)
Then ESSCMD GETDBSTATS
may not function if it is executed on a cube whose dimension name consists
of a particular character, such as '%n.'
The ESSCMD EssOtlQueryMembers
returns wrong result when outline exceeds 16K members. (22853, P2)
The outline API, routine
EssOtlQueryMembers, does not return the correct number of outline members
when the outline contains more than 16K members.
Sparse restructure causes
Linked Reporting Object (LRO) counter to be reset. (22926, P2)
When adding a new LRO immediately
after a sparse restructure, the following error occurs: "Object # already
exists".
Unable to initialize
GRID API when Regional Setting is German (Austrian). (22962, P2).
The GRID API will fail
to initialize when the Regional Setting in the Control Panel is set to
German (Austrian).
Memory leak in EssVSetSheetOption
and EssVSetGlobalOption. (22998, P2)
The VBA routines, EssVSetSheetOption
and EssVSetGlobalOption, leak memory on Windows 95/98 clients, causing
degraded performance when they are used repeatedly.
"Cannot access object:
Ess00000.TMP" error when running 4 batch jobs. (23034, P2)
When running concurrent
programs that use the Outline API, Hyperion Essbase OLAP Server occasionally
cannot create temporary file names and displays the error message, "Cannot
access object: Ess00000.TMP."
Hyperion Essbase Application
Manager is not displaying the Disk Volume. (23059, P2)
The Storage tab on the
Database Settings dialog box in Hyperion Essbase Application Manager contains
a table that is not always in synchronization with the Disk Volume edit
field or updated when changes are made to the disk volumes.
EssCell may not work
for Dynamic Time Series. (23119, P2)
In Hyperion Essbase Spreadsheet
Add-in, running EssCell (Y-T-D) on an outline with attributes may return
#MISSING
instead
of the Y-T-D value.
EssVGetDataPoint returns
incorrect values for Dynamic Time Series. (23130, P2)
When using Dynamic Time
Series in a spreadsheet to return a specific H-T-D (April), the EssVGetDataPoint
mistakenly returns "H-T-D" instead of "H-T-D(April)."
Sparse Dynamic Calc fails
in a calculation script. (23156, P2)
If a calculation of a stored
member depends on a virtual block, either through parent-child relationship
or through formula, calculation of the virtual block may not be triggered
correctly, causing incorrect results for the stored member.
GRID API crashes with
multiple concurrent logins and logouts on a multiprocessor machine. (23175,
P2)
The GRID API may crash
on connect or disconnect when using multiple threads on a multiprocessor
machine.
Data is incorrect when
aggregated with Create Block on Equation and from bottom-up. (23274, P2)
When using SET FRMLBOTTOMUP
ON, the dependencies of top-down formulas may be processed incorrectly,
causing some blocks to be missed during calculation.
EssVGetDataPoint function
does not return correct data for a first page header. (23275, P2)
EssVGetDataPoint function
may not work properly for the first page header of a query unless the cell
being inquired is in the first column.
Division by values between
.000000000000004 and -.000000000000004 results in a #MISSING.
(23375, P2)
In Hyperion Essbase OLAP
Server Release 6.1, the division with denominator values between .000000000000004
and -.000000000000004 may result in a #MISSING.
While ignoring the TimeStamp
parameter, EsbGetLogFile returns the entire log. (23396, P2)
The Visual Basic API routine,
EsbGetLogFile, ignores the TimeStamp parameter and returns the entire log
file rather than the entries of the log file produced after the date and
time specified by the TimeStamp parameter.
@XREF triggered by a
query will not automatically log off the source database. (23470, P2)
Queries involving Dynamic
Calculations with @XREF leave users logged into the remote sources of @XREF
references.
The server produces incorrect
results if the number of blocks to be locked exceeds the LOCKBLOCK setting.
(23656, P2)
When using formulas on
sparse members for which the number of blocks to be locked exceeds the
LOCKBLOCK setting, the current LOCKBLOCK setting may not return correct
values.
After moving members
of a sparse dimension, the server crashes while doing a base level restructure
(23925, P2)
After moving a sparse dimension
member, an attempt to restructure at the base level may result in a network
error, 10054, or may even cause the data to disappear.
Calc Script
Editor Does Not Generate an Error Message When Reserved Words Are Not Quoted.
(20343)
When validating
a calculation script, the client may not generate an error message for
the incorrect usage of a non-quoted reserved word used for a dimension
or member name.
Calculation
script reserved words include calc script commands, operators, report script
commands, function names, and function arguments in addition to the basic
terms, such as AND, BEGIN, MEMBER, FUNCTION, IF, THEN, and so on. For a
list of these terms, see the Hyperion Essbase Database Administrator's
Guide. It is better not to use these reserved words as dimension names,
member names, and aliases. If you do use them as names or aliases in calculation
scripts, you must enclose them in quotation marks.
The ESSCMD
Batch Job Is Canceled When Regular User Logs out by the Supervisor CONSOLE.
(20434)
When running
the nightly batch job, the application log appears and can be logged out
via CONSOLE because the Essbase script files are not locked, the user has
no firewall connections, and has read-only access to the Essbase script
files.
In the Japanese
Version, Header and Footer Strings that Are Set in Cascade Menu Item Are
Preceded by Incorrect Characters. (21011)
With Japanese
Hyperion Essbase Spreadsheet Add-in for Excel, header and footer strings
that are set in the Cascade menu item are preceded by incorrect characters
when printing and previewing.
Work around:
Go into Print Preview > Setup to the Header/Footer tab and specify a custom
header/footer that does not contain the incorrect characters.
Set Member
Filter in Essbase Query Designer (EQD) Value with MBCS Displays Broken
Character. (21012)
From within
the Essbase Query Designer, attempting to create a member filter using
multi-byte characters and an IME mode causes a data entry problem in both
Excel and the Essbase Query Designer.
Work around:
Launch the Notepad (or any other text editor that accepts multi-byte input),
enter the multi-byte text, copy, and paste the text into the Essbase Query
Designer.
If "Allow
Application to Start" Setting Is Disabled When the ESSCMD, Call BEGINARCHIVE,
Is Used, the Application and Database Cannot Restart. (21247)
If "Allow Application
to Start" setting is disabled and a database is placed in the archive mode
with ESSCMD, BEGINARCHIVE, after stopping the application, the application
and database may not restart.
Attribute
Calculation with Sparse Two-Pass Calculation Members Returns Incorrect
Value. (22752)
When the attribute
query contains a Sparse Two-Pass Dynamic Calc member, and the calculation
formula refers to some blocks that are not included in the query, the result
of the attribute query may not include the missing blocks.
Work around:
Include Sparse members within the calculation formula as part of the attribute
query.
Cryillic characters
don't work in Outline/Calc editors
If you want
to use Cyrillic characters in the outline or calc editors, remember to
change the font. From the Options menu, select Font, and then select
Cyrillic from the pull-down box, the last item in the list.