Patch file name: FIXPAK13.HTM
Applies to: All platforms
Patch Date: December 2000
Identification: R5.0.2_P13a
************************************************************
Hyperion Patches in IBM Fixpacks
Fixpack 13a for DB2 OLAP Server Version 1.1 is the equivalent of patch 13a for Hyperion Essbase Release 5.0.2. Hyperion Essbase patches are cumulative; patch 13a contains new fixes plus the fixes found in patches 1 through 13.
This file also contains information regarding Hyperion Integration Server as it relates to DB2 OLAP Server. This fixpack does not support HP-UX. If you need service for DB2 OLAP Server on HP-UX, contact IBM.
R5.0.2_P13 is Release 5.0.2, Patch 13 from Hyperion, which is in Fixpack 13 from IBM.
R5.0.2_P12 is Release 5.0.2, Patch 12 from Hyperion, which is in Fixpack 12 from IBM.
R5.0.2_P11 is Release 5.0.2, Patch 11 from Hyperion, which is in Fixpack 11 from IBM.
R5.0.2_P10 is Release 5.0.2, Patch 10 from Hyperion, which is in Fixpack 10 from IBM.
R5.0.2_P9LA is Release 5.0.2, Patch 9LA from Hyperion, which is in Fixpack 10 from IBM.
R5.0.2_P8 is Release 5.0.2, Patch 8 from Hyperion, which is in Fixpacks 9 and 10 from IBM.
R5.0.2_P7 is Release 5.0.2, Patch 7 from Hyperion, which is in Fixpacks 7, 9, and 10 from IBM.
R5.0.2_P6 is Release 5.0.2, Patch 6 from Hyperion, which is in Fixpacks 7, 9, and 10 from IBM.
R5.0.2_P5 is Release 5.0.2, Patch 5 from Hyperion, which is in Fixpacks 7, 9, and 10 from IBM.
R5.0.2_P4 is Release 5.0.2, Patch 4 from Hyperion, which is in Fixpacks 4, 7, 9, and 10 from IBM.
R5.0.2_P3 is Release 5.0.2, Patch 3 from Hyperion, which is in Fixpacks 4, 7, 9, and 10 from IBM.
R5.0.2_P2 is Release 5.0.2, Patch 2 from Hyperion, which is in Fixpacks 4, 7, 9, and 10 from IBM.
R5.0.2_P1 is Release 5.0.2, Patch 1 from Hyperion, which is in Fixpacks 4, 7, 9, and 10 from IBM.
The following problems are fixed in Patch 13A.
Certain Asymmetric Spreadsheets Do Not Retrieve the Same Values in
Fixpack 13 that Were Retrieved with Fixpack 12. (22849, P13A)
In the Spreadsheet Add-in, certain asymmetric spreadsheets do not return
the same values in patch 13 as were retrieved in patch 12.
EssOtlQueryMembers Returns Wrong Result When Outline Exceeds 16k
Members. (22853, P13A)
The outline api routine EssOtlQueryMembers does not return the correct
number of outline members when the outline contains more than 16K members.
Crash on Zoom in a Specific View on an Asymmetric Spreadsheets. (22863,
P13A)
In the Spreadsheet Add-in, a crash occurs when using the Zoom function
on certain asymmetric spreadsheets.
The following problems are fixed in Patch 13.
In Event Log Viewer the Vertical Scroll Bar Does Not Behave Properly.
(12481, P13)
In event log viewer, the user must continuously click the down arrow
to scroll rather than hold down the mouse on the vertical scroll bar.
An Attempt to Create and Delete a Chart on Lotus 1-2-3, Release 9.0
May Disable the Double-Click Drilling Function of the Mouse. (18719, P13)
When creating and deleting a chart on the spreadsheet using IBM Fixpack
7 (Hyperion Essbase 5.0.2 P7) with Lotus 1-2-3 Release 9, may disable the
double-click drilling function.
EssVCascade Ignores Suppress #Missing Option. (19039, P13)
In the Spreadsheet Add-in, the VBA function EssVCascade ignores the
suppress #Missing flag set in Essbase options. Instead, EssVCascade
never suppresses any #Missing rows.
Application Manager Crashes When Viewing a Member with a User-Defined
Attribute (UDA) List Display Larger than 4k. (19217, P13)
If a member has a UDA that is greater than 4K, when the outline is
expanded in the Outline Editor where such a member with a UDA exists, the
Application Manager crashes.
Server Crashes During Extremely Heavy Concurrent Update Workload.
(19397, P13)
Server crashes during extremely heavy concurrent update workload.
Long Member Formula Gets Truncated with Member Load Using Rules File.
(19902, P13)
An attempt to load members using rules file fails when long member
formulas are truncated in the member load rules file field. But if the
same member formula is entered manually using the member formula editor
text box, then it works fine.
An Exception File Is Generated When Logging out the Partition User.
(19924, P13)
There are two users. One is connected to a transparent partition database
and another user is described in the VB script. While the VB script is
running, an attempt to disconnect the user who is connected to the transparent
partition database may cause longer time to disconnect, produce error messages,
and generate an exception file. Moreover, in the Spreadsheet Add-in, if
the macro is running, an attempt to disconnect the same user who is connected
to transparent partition database, may cause the agent to freeze and eventually,
cause the system to crash.
The ESSCMD Batch Job Is Canceled When Regular User Logs out by the
Supervisor CONSOLE. (20434, P13)
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.
Calc Never Finishes Across a Transparent Partition. (20579, P13)
Transparent partitions may cause database calculation to run infinitely.
This problem is a special case of bug 20956, P12.
Dimension Building Time Slower on IBM Fixpack 11 (5.0.2 P11) than
IBM Fixpack 4 (5.0.2 P2). (20581, P13)
Dimension build time can be slow if an outline has a large number of
shared members with aliases.
@SUM Function Does Not Calculate Correctly with More than One Macro
in its expList. (20758, P13)
@SUM function does not calculate correctly with more than one macro
in its expList. Sometimes it will ignore the first argument in the sum.
Renaming Member with Shared Attribute Incorrectly Causes Complete
Restructure. (20764, P13)
In a time dimension, an attempt to add, rename, and categorize members
as shared members in the data storage may rapidly reduce the page size
indicating that complete data restructuring has taken place. But upon each
time, if a shared member is deleted or added to the outline, and the outline
is saved, the page file does not change, thus, indicating that data restructure
is not taking place. This bug is specific to 502 P10 and P11.
EssVSetOption Does Not Work. (20866, P13)
In the Spreadsheet Add-in, the use of EssVSetOption may not
work if the focus is on any of the VB controls at the time of the calls.
Cannot Open Data Files in Data Prep Editor with a Space in the Folder
Name. (20925, P13)
DB2 OLAP Server does not support long file names and also, does not
accept space as a valid character in folder names.
When Substitution Variables Are Set Validating a Calc Script May
Generate an Error, "Unknown Member." (20927, P13)
When running a calc script that is associated with an outline the application
generates an error message: "unknown variable or member name," if the substitution
variables are a substring of another.
Changes to Original and Shared Members on a Source Outline Do Not
Synchronize Correctly. (20950, P13)
Changes to original and shared members on the source outline do not
properly synchronize at the target outline and produces an error message
in application log, "There is 1 message in the application log identifying
a change that was not applied during outline synchronization."
Record #65536 Is Missed When Doing a File/Update Outline. (21000,
P13)
Record #65536 is missed when doing a File/Update Outline with a large
data file (having more than 65535 records).
In Application Manager, the RUN Button in the Calc Script Editor
or Report Writer Dialog Box Is Enabled When the Database Is (all dbs).
(21169, P13)
When a calc script or a report file is created and saved in the (all
dbs) database dialog box in Application Manager, the RUN button is enabled
which actually should not be enabled.
Escape Characters ("\) Do Not Work Properly in 502 P11. (21189, P13)
The Escape characters used in ESSCMD to update substitution variables
fail when used with 502 P11, but works fine for 502 P7.
Adding Members to Outline with OUTLINECHANGELOG TRUE Crashes the
Database. (21190, P13)
On AIX 4.3.3 server, in ESSBASE.CFG file if the setting is OUTLINECHANELOG
TRUE, an attempt to add a member and save the outline may generate an exception
log.
The Multiple UPDATEVARIABLE Command Updates the First Variable. (21207,
P13)
In 5.0.2 P11 when running the calc script, Multiple UPDATEVARIABLE
command updates the first variable.
Unable to Delete Application Database After User Auto Logoff by CONSOLE.
(21238, P13)
After log in to Application Manger if the server Auto Logoff inactive
limit is set to 5 minutes, an attempt to delete an application database
may produce an error message: "Cannot unload the database [Basic]. User
[username] is performing database operation. Wait for user [username] to
complete the operation or ask the user to abort it. Log out all users and
then unload the database" when the user logs out by the CONSOLE. Only if
you reboot the Essbase server and reconnect, you can delete the application
database.
If "Allow Application to Start" setting Is Disabled When the ESSCMD
Call BEGINARCHIVE Is Used, the Application and Database Cannot Restart.
(21247, P13)
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.
Deleting a Member in an Outline Through API Takes Almost an Hour.
(21298, P13)
With 502 P7 and P11, the use of the API EssOtlDeleteMember()
takes 55 minutes to delete a member from an outline just 5 minutes in 6.0.
Calc Time Degraded from Version 502 P10 to 502 P11. (21406, P13)
Calc script calculation takes longer time from 502 P10 to P12.
Retrievals on a Transparent Target Database Take Longer on 502 P11
than on 502 P7. (21692, P13)
A retrieval on a target database with three source databases takes
approximately 35 seconds with 502 P11 (and 502 P12) compared to approximately
6 seconds with 502 P7.
If Repeat Member Labels Option Is Enabled, Retrieve May Modify the
Column labels . (21743, P13)
In Spreadsheet Add-in, if Essbase Options Repeat Member Labels setting
is enabled, Retrieve may modify the order of the column labels.
User with Create/Delete Permissions Cannot Edit Users. (21810, P13)
Two users have been provided with Create/Delete user permissions and
without Create/Delete user permissions respectively. If you attempt to
edit the second user while logged in as a first user who has Create/Delete
permissions, the check boxes are grayed out.
Not All Data Returned When Buffer Size Is 32K. (21838, P13)
When the API call EsbGetStringBuf is used on a particular report with
a buffer size of 32767, records are skipped in the report. The report is
correct with the buffer size is 32766.
The following problems are fixed in Patch 12.
EssCell May Not Work with Dynamic Time Series. (13703, P12)
#MISSING is returned instead of the Dynamic Calc member value when
EssCell is used on a Dynamic Time Series member (for example, EssCell
("Q-T-D") ).
Incorrect Retrieval on Report with Member Name in Quotes Immediately
Followed by an '!'. (14457, P12)
A report containing a member name in quotes immediately followed by
an '!' without any space in between may not get recognized. This may result
in the row with the unrecognized members to repeat the value from the row
above.
The Option CALCOPTCALCHASHTBL TRUE Causes Inconsistent Results. (16565,
P12)
In some cases when the CALCOPTCALCHASHTBL is set to TRUE in the ESSBASE.CFG
file, incorrect data values may be calculated.
EsbLROAddObject() May Give Error 1030718.(17507, P12)
If the usOption parameter of EsbLROAddObject is set to ESB_STORE_OBJECT_API,
the API may produce error 1030718: Invalid object option for cell not entered.
Successive Attempts to Retrieve May Cause Memory Leak. (17998, P12)
In Hyperion Essbase Spreadsheet Add-in, successive retrievals with
Retain
on Retrieval option may lead to memory leak.
On AIX, Locking and Sending a Formula That Divides by 0 Gives Incorrect
Results. (18108, P12)
With the Spreadsheet Add-in for Lotus 1-2-3 and an AIX server, erroneous
formulas may not get recognized, and may produce incorrect results on the
AIX server.
After Revising the Outline for Transparent Partition, Outline Synchronization
May Not Work. (18267, P12)
An attempt to re-synchronize outlines of transparent partitioned databases
may disable the Edit and Apply option buttons on the Synchronize
Outline dialog box.
Output to Audit File (.ATX) Is Not Correct When Member and Alias
Names Option Is Checked in the Spreadsheet. (18463, P12)
When sending data in the Spreadsheet Add-in, the data sent to output
file *.ATX is not correct if the Essbase Spreadsheet option
Use Both
Member Names and Alias for Row Dimensions is checked.
Database "Tesue" in Katakana May Not Be Deleted from the File System.
(18531, P12)
On Solaris 2.7 platform, the database name "Tesue" in Katakana may
not be deleted from the database file directories in the Application Manager.
The Server May Not Be Able to Create Database Whose Names Contain
Certain Foreign Characters. (18532, P12)
If a database name contains certain foreign characters, like Kanji
or Katakana, the Application Manager may produce an error 1019002: Failed
to create database.
In Katakana A Database Named "Tesuto" May Become "Tesue". (18550,
P12)
When we use some double-byte Katakana characters for a database name,
they become saved as different characters.
A Retrieval on a Target Database Partition Crashes the Target Application.
(18665, P12)
From the Spreadsheet Add-in, a retrieval against the target database
crashes the target application.
INCBUILDDIM in ESSCMD on Source Partition Outline Causes Exception
and Does Not Build Dimensions.(18715, P12)
Using ESSCMD's INCBUILDDIM command to incrementally build a source
partition outline fails to build the dimensions, and causes the application
to crash.
Calc Script with Invalid FIX Statement Calculates on the Entire Database.
(18800, P12)
When the contents of a FIX statement results in an empty list, the
server ignores the FIX statement and performs the calculation on the whole
database.
Excel Does Not Prompt to Save When Essbase Cascade Is Performed.
(19431, P12)
If a cascade is performed in the Sreadsheet Add-in, the user is not
prompted to save the file on exit.
Database Setting "Create block on equation" Behaves Differently After
Release 5.0.2 P9.(19496, P12)
When "Create blocks on equation" is on, execution of certain
formulas during calculations may clear contents of some data blocks.
Essbase EssRetrieve Macro Lock Options for 2 and 3 No Longer Work
for Lotus 9.1. (19522, P12)
The lock options 2 and 3 available for the EssRetrieve macro may no
longer work for Lotus 9.1. When EssRetrieve macro is run with EssSend macro,
the following error message appears in Lotus: Unable to Update Members
Which Have Not Been Locked.
Concurrent, Multiple Lock and Send and Retrievals Using SSAUDIT Causes
Negative Values to Be Sent to The Database Instead of #MISSING. (19632,
P12)
When spreadsheet update logging is enabled using SSAUDIT in the ESSBASE.CFG
file, two client machines simultaneously and continually issuing lock and
sends and retrievals via a VB macro causes negative values to be sent to
the database instead of the expected #MISSING. The problem occurs more
often on French client machines.
5.0.2 P10 Locale Files and ESSBASE.MDB Are Not Replaced in a New
Patch Installation. (19775, P12)
Patch installation does not update <ARBORPATH> /bin/essbase.mdb
or locale files because they are read/only.
Approximately 430 Concurrent Partition User Connections Freeze the
Agent. (19875, P12)
The Agent freezes when there are approximately 430 concurrent users
accessing a transparent partition. It happens most often with one target
and several sources with many users doing spreadsheet retrievals from the
target.
Calc Times May Increase After Migrating to 5.0.2 P10 from 5.0.2 P7.
(19901, P12)
When running calculations under 5.0.2 P10, regular members that are
dependent on Dynamic Calc members may take longer time to calculate than
under 5.0.2 P7.
ESBGetLogFile Will Not Get the Server Log File Unless Application
Name Is Undefined. (19936, P12)
The VB API routine EsbGetLogFile will not get the server log and will
return a non-zero value when the AppName parameter is explicitly set to
null. It only works properly when the AppName parameter is undefined.
EssVRetrieve (Empty, Empty, 1) and EssVFlash (Empty) Uses 100 % of
CPU. (19943, P12)
EssVRetrieve or EssRetrieve with the range parameter set to empty may
use close to 100% of the CPU for 2-3 minutes. Furthermore, after the retrieve,
EssVFlash may use close to 100% of the CPU.
Volume Spanning Has Been Set but Index File Creation Is Not Rolling
Over to the Next Volume. (19973, P12)
The error 1019028: "Out of disk space, unable to write information
to file," appears when a new page file is created and the current disk
volume has less than 1024 bytes of available space.
Retrieve Returns Invalid Values on Certain Databases with Circular
Dependencies Between Blocks. (20158, P12)
If a circular dependency between blocks exists, retrieval of Dynamic
Calc values may produce incorrect results.
Currency Conversion Calc Script Crashes the Application. (20205 P12)
Certain currency conversion calc scripts containing several levels
of reference to other members may crash the application.
Clicking on a Member Cell May Clear the Spreadsheet. (20226, P12)
In the Spreadsheet Add-in, when dimensions listed in the column heading
appear in only one row, double-clicking a data cell may clear the spreadsheet.
Dynamic Calc May Give Inconsistent Results. (20333, P12)
Retrieval in the Spreadsheet Add-in may give different results for
the same member combination depending on the view and order of retrievals.
Data Load with Erroneous Data May Cause Server Crash. (20403, P12)
When data is loaded with report output text file that does not have
a close quotation marks, the length of the error message exceeds the memory
limit for error reporting, and thus, causes a server crash.
FIX Statements in Formulas Increase Calc Script Time. (20743, P12)
FIX statements with formulas may take longer in 5.0.2 P10.
Spreadsheet Retrieval Causes the Application to Crash and Core Dump
on HP-UX. (20813, P12)
In the Spreadsheet Add-in, using a specific spreadsheet view where
the Essbase option Use Both Alias and Member Name is enabled and
where some dimensions are not represented, performing a Zoom In will cause
the application to crash. A core dump may also be created as a result of
the application crash.
Calc Never Finishes Across a Transparent Partition. (20956, P12)
Transparent partitions may cause database calculation to run infinitely.
Problem with @UDA Within Filters. (20990, P12)
Filters with user-defined attributes (UDA) may not allow users to have
access.
On AIX Servers with Multiple Processors, the Agent Returns Network
Errors. (21049, P12)
The network error code: 1042008, Network Error [76]: Unable To Accept
Connections, may occur on AIX servers with three or more processors.
The following problems are fixed in Patch 11. 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.
Member Names Move to a Different Location When They Should Not (19524,
P11)
In the Spreadsheet Add-in, when the RepeatMemberLabels option is set
to TRUE, member names may move to a different location during retrieval.
Processing Member Select on a Source Database is Slow (19437, P11)
Processing Member Select on a source database may be slow when you
create several transparent partitions.
Formula Disappears When Using Flashback if the Result is 0 (19354,
P11)
If a formula results in 0 and the Flashback menu is used, the formula
disappears and must be retyped.
Output With YTD and Non-YTD Data Gives Incorrect Value (19266, P11)
A report that contains YTD members and non-YTD members may give wrong
results.
Retrieving on Spreadsheet Causes Application to Crash (19205, P11)
In the Spreadsheet Add-in, retrieving data with two members of different
dimensions in the same column in the row tree causes the application to
end abnormally.
Stopping the DB2 OLAP Server Service in Control Panel Returns Error
Message (19047, P11)
Attempting to stop the running of the product as a service returns
an error message.
Warning Message Produced When Running Calc Scripts (19028, 18762,
P11)
Running calc scripts involving calculations that are not top-down concurrently
on isolated database segments can sometimes produce a warning message "Lock
request timed out in adResource block" and cause the calculations to run
more slowly.
Application Crashes When Calculating on a Particular Year with Dynamic
Time Series Enabled (18940, P11)
With Dynamic Time Series enabled, a calculation script fixing on a
particular year and requiring a high CALCLOCKBLOCK setting crashes the
application server.
The Server Gets an Error Message When Running a Calc Script (18821,
14615, P11)
On Windows NT, the server gets an "Unable to reallocate memory" error
after running an operation that produces data free space. This is a Microsoft
bug. DB2 OLAP Server now works around this bug. The workaround that has
been implemented has improved the performance of reading data free space
by a factor of 60, and the performance of recovering free space in the
data files by a factor of five.
Programs Written With Grid API Fail to Compile on Solaris (18755,
P11)
Programs written using the Grid API do not compile or run on Solaris.
Calculations After a Restructuring Operation may be Incorrect (18670,
P11)
When a restructuring operation results in an upper level sparse member
becoming a level-0 member (because one or more of its children members
have been either removed or moved elsewhere in the dimension hierarchy),
then, any block in the database involving the upper level sparse member
may not be recalculated by a subsequent calculation and results in incorrect
values. The workaround is to avoid transitioning a sparse dimension member
from being an upper level to a level-0 member as part of restructuring.
Incorrect Values are Displayed When Multiple Users Concurrently Retrieve
From a Database (18596, P11)
When multiple users concurrently retrieve from a database and the retrievals
involve sparse dynamic calculations, results may be incorrect.
Selecting Options From The Essbase Toolbar May Cause Excel To Crash
(18555, P11)
In the Spreadsheet Add-in for Excel, using the toolbar may cause Excel
to crash.
Users Who Are Not Logged Into an Application Are Not Logged Off (18482,
P11)
Users who log on the the Application Manager but who do not log on
to an application are not automatically logged off.
In Particular Excel Spreadsheet Layout, Column Header and Corresponding
Data Changes On Retrieval (18436, P11)
In the Spreadsheet Add-in for Excel, when member names are repeated
across all columns, and options "Repeat Member Labels" and "Advanced Interpretation"
are selected, the header label of one of the columns and the corresponding
retrieved data may change.
Problems with Dynamic Calc and Transparent Partitioning (18357, P11)
When retrieving on a transparent partition with dynamic calc on a sparse
dimension, the members on the same level and the level above return incorrect
values and change with each retrieval.
Drill Down With Retain on Retrieval and Retain on Zoom Clears Spreadsheet
(18266, P11)
In the Spreadsheet Add-in, drilling down on data after selecting the
Retain on Retrieval and Retain on Zoom options, may not return any results.
Year-To-Date Data Changes If Order of Months Changes (18147, P11)
In some cases, the Year-to-Date data shown in a Spreadsheet Add-in
retrieval differs when the presentation order of month columns is changed.
Error Message Displayed When 0 is a Member in the Outline (18138,
P11)
In Spreadsheet Add-in for Lotus 1-2-3, a query on a member that is
named 0 results in an error message.
Locking and Sending a Formula That Results in an Error Gives Incorrect
Warning Message (18108, P11)
Locking and sending a formula that results in an error on Lotus 1-2-3,
is mistaken for a string and results in an "unknown member" warning.
Dimension-build Failure Caused by Insufficient Memory Crashes the
Application Server (18106, P11)
In some scenarios, a dimension-build failure due to insufficient memory
causes the application server to crash.
No Result When Regular Member Has a Calc Script Formula That Depends
on the Dynamic Member (17946, P11)
In some specific cases, #MISSING is returned when a regular member
has a formula applied to it in a calc script and the formula contains a
dynamic calc member.
Cancelling the SQL Drillthrough the Login Box Causes Excel to Crash
(17611, P11)
In DB2 OLAP Server Version 1 and later releases, Excel will crash if
you cancel the SQL Drill Through login dialog box.
EssOtlQueryMembersEx Does Not Handle Label Only Members Properly
(17600, P11)
The EssOtlQueryMembersEx API command does not return shared or label-only
members.
First Retrieval Returns Incorrect Data in Some Spreadsheet Scenarios
(17567, P11)
In a certain spreadsheet layout, the first Spreadsheet Add-in retrieval
returns incorrect data for a cell; the correct data appears on the second
retrieval.
Retrieval in Lotus 1-2-3 97 & Lotus 1-2-3 Millenium R9 is Slower
Than in Lotus 1-2-3 R5 (15066, P11)
Retrieval of files takes longer in Lotus 1-2-3 97 and Lotus 1-2-3 Millenium
R9 than retrieval in Lotus 1-2-3 R5.
Loading Data Using a Very Long SQL Statement Crashes the Application
(14863, P11)
In SQL Interface, using a SQL statement that exceeds 4092KB may result
in a crash.
Using Rules Files From Newer Versions of Hyperion Essbase Causes
Crash (13689, P11)
Use of rules files from DB2 OLAP Server Version 7.1 is not supported
with Version 1.1. Attempts to use newer rules files may have caused
the Version 1.1 Application Manager or the application server to crash.
With this patch, a message is displayed if you attempt to use a rules file
from a newer release.
Memory Information in the Application Manager is Incorrect (12091,
P11)
In the Application Manager, the memory information displayed in the
System Information box is inaccurate.
The following problems are fixed in Patch 10. 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.
After Copying an Application to a New Name, Users Cannot Delete the
New Application or Make a Copy of it. (12829, P10)
If users who do not have superuser privileges but who do have "Create/delete
users, groups" and "Create/delete apps" privileges copy an application
to a new name, they cannot delete the resulting copy or make a copy of
it.
Application Manager Has Problems With Excel Source Files That Have
Been Saved as File Type "Microsoft Excel 97 & 5.0/95 Workbook (*.xls)"
and that contain more than 16384 rows (14686, 15991, 15994, 15986, P10)
Workaround: In Excel 97, save the Excel file as normal format, "Microsoft
Excel Workbook (*.xls)". Up to 64 KB rows can be processed in this normal
format.
Retrieving Data Using EssRetrieve in the Spreadsheet Add-in for 1-2-3
is Slow (15028, P10)
Retrieval time of data using the EssRetrieve macro in the Lotus Add-in
is slow when compared to using Retrieve from the Essbase menu.
In the Spreadsheet Add-in for Lotus 97, Certain Foreign Language
Characters are not Translated (15049, P10)
When retrieving members in the Spreadsheet Add-in for Lotus 97, certain
foreign language characters, such as French, German, and Greek, are not
translated properly.
Retrievals Involving Dynamic Calc Members With Formulas Fail (16726,
P10)
Using Dynamic Calc members that contain a formula cause the system
to crash with an error message.
Problem with Replicated Partitions and Calculations (16776, P10)
Data from transparent partition is not replicated in the target database.
The problem is the same if two replicated partitions are used. This bug
is not reproducible.
Agent Crashes When a User ID is Suppressed (17378, P10)
If you create a transparent partition using a certain user ID, and
then the administrator suppresses the user ID, the agent crashes.
AGGMISSING is Working Incorrectly (17472, P10)
When AGGMISSING is turned on, the parent member results in a #MISSING
value when all children are tagged with the Ignore consolidation property.
Calc All Function Returns Incorrect Results (17568, P10)
The Calc All function continues to run indefinitely on outlines with
certain top down formulas.
The .XCP Error Log Incorrectly Displays Physical Memory Values in
Megabytes as Kilobytes (17602, P10)
In the .XCP error log, the numbers for the physical memory values were
calculated as megabytes but were displayed as kilobytes. These values are
now calculated and displayed as kilobytes.
Calculations on Certain Outlines Not Rolling Up After Retrieve Unless
the Calc Script is Run Twice (17604, P10)
On certain outlines, calculations involving a regular dense member,
depending on the Dynamic Calc dense member, may yield incorrect results
unless the calc script is run twice.
The @PARENTVAL and @MDPARENTVAL Functions do not Calculate Dynamic
Calc Members (17651, P10)
When the @PARENTVAL and @MDPARENTVAL functions are referencing a parent
value that is Dynamic Calc, the parent value is not calculated and there
is no data returned after running the member formula.
An Attempt to Retrieve with Dynamic Calc Fails With an Error Message
(17658, P10)
Retrievals involving Dynamic Calc members with formulas operating on
a dense Dynamic Calc member across a sparse range can sometimes crash the
server.
Able to Retrieve Data into a Non-Partitioned Area of an Empty Target
Database (17694, P10)
With some partition definitions, it is possible to retrieve data into
a non-partitioned area of an empty target database.
When a Calculation is Cancelled, Some Fixed Blocks Are Not Unfixed
(17705, P10)
When a calculation is cancelled, some blocks that were fixed are not
changed back to unfixed blocks.
Sparse Roll-Up Does Not Create an Upper Level Sparse Block With Implied
Share (17858, P10)
In some cases, top-down calculation interferes with the dirty status
on blocks and generates incorrect results.
User Security Settings for Calculations Display Incorrectly (17871,
P10)
When editing the user security screen in Application Manager, the calculation
access settings do not display correctly.
Agent Hangs When Too Many Logins Using the Same ID are Used (18022,
P10)
Too many logins using a specific user ID for a partition causes the
agent to hang.
Retrieval of Dynamic Time Series Cause the Spreadsheet to Hang (18154,
P10)
Retrievals on the dynamic time series data cause the spreadsheet add-in
to hang when a DTS member is present in the first row.
After Creating an Outline in HIS and Then Adding Records in DB2 OLAP
Server, the Outline Restructure Process Generates Errors (18201, P10)
After creating an outline in Hyperion Integration Server and then adding
records through dimension build in DB2 OLAP Server, the outline restructure
process generates errors.
Tagging a Member With More Than 100 Children Results in a Dynamic
Calc Error (18373, P10)
Attempts to use Dynamic Calc fail when a database member that has more
than 100 children.
Member Labels Changing, Rearranging During Add-In Retrieve (18491,
18234, 18358, 18421, 18439, 18557, P10)
When attempting to connect to the multidimensional database and retrieve,
the label names change and undergo significant rearrangement and duplication.
Target Database of a Transparent Partition Crashes upon Retrieval
(18520, P10)
With grid expansion, the target database of a transparent partition
crashes upon retrieval.
Saving an Outline Causes the Server to Hang (18536, P10)
When you save an outline file after creating an application and database,
the server may hang.
Data Changes After Running VBA Retrieve When Using 402 P9 (18540,
P10)
When attempting a VBA retrieval, the data in an Excel file is different
from the original data when Essbase 4.0.2, Patch 9 is used.
Cannot Use the Mouse to Pivot Data (18553, P10)
On Windows 95a and in Excel 97, you cannot use the mouse to pivot data
in a spreadsheet.
The following problems are fixed in Patch 9LA, which focuses on compliance with Lotus 1-2-3 Millennium releases.
Memory Leaks Occur With Consecutive Connects and Retrieves With Flashback
Enabled in Spreadsheet Add-in (12185, P9LA)
This fix requires a client upgrade. Memory leaks occur after consecutive
connects and retrieves in the spreadsheet add-in, when Flashback is enabled
(Essbase > Options > Global tab).
Errors with Formulas After Retrieval in 1-2-3 Add-in (12477, 16057
P9LA)
This fix requires a client upgrade. In the Spreadsheet Add-in for 1-2-3,
the following problems can occur:
Formulas disappear on retrieval or are replaced with 0s. When formulas
result in a 0 data value, the 0 does not send as data.
Invalid Block Header Error Occurs During Concurrent, Multi-User Workloads
(14434, P9LA)
In various scenarios, an "Invalid Block Header" error message occurs
during concurrent, multi-user workloads, and the database must be recovered
from an archived copy or rebuilt.
Unnecessary Informational Messages Appear in Log File After Running
a Report Script (14451, P9LA)
After running a particular report script against a target partition,
the informational message "Grid Expansion enabled for this query" unnecessarily
appears multiple times in the server log file.
Unsuccessful Data Loads Treated as Successful (14494, P9LA)
If a data load request from the DB2 OLAP Server fails, the product
does not display the failure message and time elapsed.
DB2 OLAP Server May Write to the Application Log Before Process is
Completed (14677, P9LA)
When processing data on the DB2 OLAP Server, the product may record
elapsed
time into the application log before the function is completed.
Certain Characters Appear Incorrectly in the the Essbase menu for
Non-English Versions of Lotus 1-2-3 Spreadsheet Add-in (14711, 17185, 17186,
17772, 17383, P9LA)
These fixes require an upgrade of the 1-2-3 add-in. Various translation/localization
errors appear in the Essbase menu for the Lotus 1-2-3 Spreadsheet Add-in
.
Formulas Created With the Formula Editor Disappear After the Database
Outline is Saved (14974, P9LA)
Application Manager does not recognize some invalid formulas created
in a database outline. These invalid formulas disappear after the outline
is saved.
The Spreadsheet Add-in for Lotus 1-2-3 Incorrectly Displays Greek,
French, or German Characters When a Particular 1-2-3 Function is Invoked
(15049, P9LA)
This fix requires an upgrade of the 1-2-3 add-in. Greek, French, or
German characters are displayed incorrectly in the Spreadsheet Add-in for
Lotus 1-2-3 when a particular 1-2-3 function is invoked.
Reports Take Longer to Run in Patch 2 (15359, P9LA)
Reports take longer to run in 5.0.2, Patch 2 as compared to version
4.1.2, Patch 10.
Running Batch Calculations May Cause the Application to Crash (15507,
P9LA)
Running batch calculations may cause the application to crash when
the FIX statement contains only Dynamic Calc members from a dimension.
SQL Drill-Through Fails on Second Drill When Running on Machines
Faster Than 400 Mhz (15559, P9LA)
SQL Drill-Through functions correctly on the first attempt but hangs
on the second attempt.
Application Server Crashes after Running a Default Calc on Transparent-Partitioned
Target Database (15639, P9LA)
Running a default calculation on the target transparent-partition database
crashes the application server.
Application Manager Displays Incorrect Date for Database Modifications
(15698, 16450 P9LA)
This fix requires a client upgrade. After a user changes the year in
the computer's date to 2000, Application Manager's Database > Information
> Modifications tab displays the year as 1900.
Application Server Process Uses Up Memory and CPU (15830, P9LA)
If the Essbase Agent Process is killed using the Task Manager on Windows
NT while a calc is running on an application, the ESSSVR process uses up
all the available memory on the system.
Invalid Syntax Errors Returned for Calc Scripts Using Parentheses
and Commas Within a FIX statement (15952, P9LA)
Certain calc scripts containing parentheses and commas within a FIX
statement return "Invalid Syntax" errors.
Attempts to Import Data into the Data Prep Editor From Excel Fail
(15961, P9LA)
The product cannot read Excel worksheets because it does not ignore
Evaluation Errors such as #DIV/0.
After Mandatory Password Change, Retrieval Attempt Results In "Incorrect
Password" Error (15970, P9LA)
This fix requires a client upgrade. In the Spreadsheet Add-in for Excel,
after changing the password as required, a user who attempts to retrieve
on a second spreadsheet gets an "Incorrect Password" error message.
Application Crashes After Repeated Calculation Attempts by a User
Without Calc Privileges (16147, P9LA)
When a user without calculation privileges repeatedly tries to run
a default calculation from the spreadsheet, the application server crashes.
"Invalid Block Header/Duplicate Key in AVL Tree" Errors Occur After
the Following Sequence of Steps: CALC, Successful Sparse Restructuring,
Server Crash, CALC (16288, P9LA)
"Invalid Block Header/Duplicate Key in AVL Tree" errors occur after
the following sequence of steps: calculation, successful sparse restructuring,
server crash, calculation.
Exiting from Excel Returns Error Message (16492, P9LA)
This fix requires a client upgrade. After loading the Excel add-in
and closing all workbook sheets, exiting from Excel results in an DB2 OLAP
Server error: "Active sheet could not be determined."
Large Member Formulas Create Server Exception and Crashes Application
(16571, P9LA)
Large member formulas generate a server exception when you attempt
to save the database outline. This results in an application crash.
@ISMBR Function Used On Dynamic Calc Members in Member Formulas Returns
#MISSING Values (16595, P9LA)
Certain member formulas using the @ISMBR function and containing references
to Dynamic Calc members other than the ones being calculated do not execute
correctly, returning #MISSING values.
Dynamic Calc Members are Retrieved as 0 in Certain Spreadsheet Views
(16718, P9LA)
Formulas involving the @PRIOR, @SHIFT, or @NEXT functions on Dynamic
Calc members may return incorrect values upon retrieval.
Unchecking Allow Attribute Changes Results in an Erroneous Build
(16720, P9LA)
The product does not ignore duplicate occurrences of aliases for a
member and records warnings in the error file.
Using EssCell on a Dynamic Calc Member Causes Error Messages or Application
Crashes (16726, P9LA)
Retrieving on a Dynamic Calc member using the EssCell Spreadsheet
Add-in function causes application server error messages or crashes when
certain database settings and .CFG file settings are in place.
Retrievals From Partitioned Databases on Solaris Return Error Messages
(16739, P9LA)
Spreadsheet retrievals against replicated-partition databases on a
Solaris server fail with memory allocation or network timeout errors.
Aggregate #Missing Option Not Working with Non-Consolidating Children
(16810, P9LA)
When a child has a non-consolidation tag and a value, the Aggregate
#Missing option fails to consolidate #Missing values of other children
of that parent member.
In Application Manager, Successfully Defined Alias Does Not Display
in Member Properties (16848, P9LA)
After adding an alias to a member using Application Manager's Member
Properties > Alias Combination tab, the alias is not listed after the user
clicks OK. However, the alias is still functional in the Excel add-in.
A Default Calc on an Empty Database May Cause the Application to
Crash (16910, P9LA)
When a member formula contains a cross-dimensional operator with the
@ISMBR function, the application may crash.
Calc Causes a Crash with Some .cfg Settings (16956, P9LA)
If more than 100 blocks need to be locked during a batch calculation,
the database may crash with an error message.
Users Can Log On to DB2 OLAP Server After a Timed Automatic Log Out
(16964, P9LA)
This fix requires a client upgrade. After DB2 OLAP Server has logged
out users, the users can still automatically log on to DB2 OLAP Server
through the client.
No Data Values Return for Dynamic Calc Members After a Retrieve (17011,
P9LA)
In Patch 7, an attempt to retrieve data values for Dynamic Calc members
fails, resulting in #Missing values.
Calc is Slow and May Give Incorrect Results (17084, P9LA)
Calc is slow and may return incorrect results in Patch 4 and succeeding
patches.
Setting Substitution Variables at the Application Level Causes Security
Corruption(17335, P9LA)
Setting substitution variables at the application level causes the
product to display an erroneous message stating that the security files
are corrupted.
Migration of Data from Release 3.x to Release 5.0.2 Causes Server
Crash (17681, P9LA)
On UNIX, validating or exporting migrated Release 3.x data blocks from
Release 5.0.2 causes a server crash.
Retrievals in Spreadsheets with Multiple Columns, and Only Dynamic
Time Series Members in the Topmost Column, Cause the Application Server
to Crash (18154, P9LA)
Retrieval on a spreadsheet which has only Dynamic Time Series members
in the topmost column, and more than one column in the sheet causes the
application server to crash.
Retrieval Changes Members in Spreadsheet (18421, 18439, 18491, 18358,
18540, 18436, 18557, 18234, P9LA)
When the Repeat Member Label option is turned on, some spreadsheet
retrievals change the names of the displayed members.
The following is a list of known problems that exist in P9LA:
Pivoting Column Heading Returns Unexpected Results (12386)
Pivoting a column heading causes another column heading to fall outside
the Page dimension.
Keep Only and Remove Only Commands Fail When the Repeat Member Labels
Option is Turned On (14139)
When the Repeat Member Labels option is turned on, the Keep Only command
fails and the Remove Only command generates the following error message:
"The operation would generate a nonsensical report."
Alias Names for Shared Members Are Not Displayed Within the Member
Selection Dialog Box (18356)
In Member Selection, when the Use Aliases option is checked and a member
is added to the Member Selection dialog box, the stored member appears
without its alias name.
Unable to Drill Down on Greek Characters in Lotus (18480)
An attempt to drill down on a database that contain Greek characters
fails.
A Report That Has Two Accounts Over Two Months Will Only Display
One Account When The Report is Run (18495)
If a report contains values for two accounts over three months (Sales,
COGS) for Jan, Feb, Mar, and you run the same report for the two accounts
over two months instead (Jan, Mar), it will show just one account (either
Sales or COGS). It will not show both accounts for those two months.
The Target Database in a Transparent Partition Crashes During Data
Retrieval (18520)
In a transparent partition, an attempt to connect to the Target database
and retrieve data results in a crash that generates an exception log.
Saving an Outline Causes the Server to Hang and Generates an Exception
Log (18536)
Opening an outline from the client and attempting to save it causes
the server to hang and generates an exception log.
Alias Names Not Being Displayed for the First Member in the Report
Script (18539)
When a report script is run, the alias for the first member is not
displayed. The alias names for members following the first member are displayed.
If the second member is moved above the first member, the alias for the
second member is no longer displayed but the alias for the first member
is displayed since it is no longer the first member in the report.
The following problems are fixed in Patch 8, and required a client upgrade.
Data Retrieval by EssVCell is Incorrect in Spreadsheet Add-in for
Excel 2000 (15930, P8)
In Excel 2000, member formulas do not work correctly after the database
outline is restructured.
In New Installations of the Spreadsheet Add-in for Excel 2000, the
VBA Formula Retrieval Does Not Work Correctly (15928, P8)
In new, non-upgraded installations of the Spreadsheet Add-in for Excel
2000, the VBA formula retrieval loses the formula after running the macro.
Some Essbase Functions in the the Spreadsheet Add-in Do Not Work
Correctly (15196, P8)
Essbase functions such as formula preservation, pivoting, and double-clicking
work correctly when the Spreadsheet Add-in for Excel is installed as an
upgrade to the add-in on Excel 97. In fresh installations of the add-in,
these functions do not work correctly.
The following problems are fixed in Patch 7.
Memory Leak Occurs with Consecutive, Repeated Retrievals (12185,
13762, P7)
This fix requires a client upgrade. Consecutive, repeated retrievals
in Excel Spreadsheet Add-in cause a memory leak.
Viewing the Application Log by a Specified Date May Not be Successful
When Error #1013104 is Present in the Log (14398, 15194, 15479 P7)
When error #1013104 (invalid member name) is recorded in the application
log, an attempt to view the log records by a specific date may be unsuccessful.
In the Formula Editor, a Syntactically Incorrect Formula Passes Syntax
Validation, but Disappears after a Save (14974, P7)
The Formula Editor validates a member formula that has incorrect syntax,
but after the outline has been saved the formula disappears. With this
fix, the formula does not get truncated or disappear. When the outline
is saved to the server, one error message is recorded in the application
log file and another error message is inserted into the member comment
field. The formula is ignored during calculation. The error can be seen
only if the outline is closed and reopened.
To fix the member formula:
Progressive Memory Leak on Successive Dimension Builds (15520, 15521,
P7)
During dimension builds, memory leaks in the calc data structure and
the outline API.
With "Create Blocks on Equation" Database Setting Enabled, Running
a Certain Calc Script on a Database with Many Dynamic Calc Members Crashes
the Application (15647, P7)
For a particular database, the application crashes during a calculation
with the the following calc script, with "Create Blocks on Equation" enabled:
Set cache high; Set Aggmissg On; Set Frmlbottomup On; Set Updatecalc off; Calc all;Spreadsheet Retrieval Causes Application Server Crash (15650, P7)
Supervisors are Unable to Log into the Application Using the Reserve
Port (15757, P7)
Supervisors are unable to log into the application using the reserve
port but users are successful in logging in through the reserve port.
Server Crash Occurs When Viewing Database Statistics (15783, P7)
A server crash occurs after selecting Database > Information > Statistics
tab in Application Manager.
Data Load from Certain Erroneous Data Files Crash the Server (16024,
P7)
Loading data from a data file containing duplicate member names (or
other errors) crashes the server.
The following problems are fixed in Patch 6.
In addition to two bug fixes, Patch 6 contained two new C Outline API functions, and one new structure. These support Enhanced Member Queries, and are needed for integration with Hyperion applications.
Data Load and Spreadsheet Add-in Retrievals Fail with "Unknown Member"
Errors, for Members that Exist (15580, 15581, P6)
A data load from a Lotus 1-2-3 file fails with an "Unknown Member"
error when it encounters a member name with an underscore in the data file.
Spreadsheet Add-in retrievals on aliases fail with an "Unknown Member"
for particular members in Excel, when the alias has spaces or underscores.
The following problems are fixed in Patch 5.
System Password Visible on HP-UX and Solaris Using ps -ef (9377,
P5)
Users can view the DB2 OLAP Server system password on HP-UX and Solaris
when using the ps (process status) utility with options -ef to
view a full listing of all current processes. With this patch, you can
hide the system password from the UNIX process listing by creating a shell
script through which to launch DB2 OLAP Server. For more information, see
UNIX
Secure Password Script.
Data Retrieval on Large Dimension Through Excel Spreadsheet Add-in
is Slow (12302, P5)
In the DB2 OLAP Server Version 1.1 Spreadsheet Add-in, data retrieval
on large dimensions in certain outlines takes longer than it did in Hyperion
Essbase Release 4.12.
Files Named With More Than 8 Characters Cannot be Opened (13770,
P5)
This fix requires a client upgrade. An attempt to open files with names
longer than 8 characters through the Application Manager returns an error
message.
Numerous Connections and Disconnections Could Result in Users Being
Logged Off (14465, P5)
Continual connections and disconnections through the Excel Spreadsheet
Add-in may result in users being randomly logged off of the server component.
ESSLANG Language-Environment Variable is Not Documented
(14499, P5)
Information about the ESSLANG environment variable is missing
from Version 1.1 documentation. English versions of DB2 OLAP Server are
already set by default to use the correct code page. For non-English versions
of the client and server, you need to set the ESSLANG variable
(which defines the code page) to be the same on both the client and the
server. The ESSLANG variable can be a user variable or a system
variable. If $ARBORPATH is defined as a system variable, create
ESSLANG
as a system variable also. If $ARBORPATH is defined as a user variable,
create ESSLANG as a user variable.
ESSLANG settings should follow this format: ESSLANG=<locale>
where <locale> is a supported Uniscape GlobalC locale of
the format
<Language>_<Country>.<code page name>@<sort order>
Here is an example of a Japanese ESSLANG environment variable
setting:
ESSLANG=Japanese_Japan.MS932@binary
Supported locales, and more information about code pages, are listed on the Uniscape page at: http://www.uniscape.com/technology/global_c_locales.htm
Replicated Partition Shows Incorrect Values when Aggregate Missing
Values is OFF (14317, 14319 P5)
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.
Dimension Build Using a Microsoft Access Data File and a Rules File
Fails (14506, P5)
This fix requires a client upgrade. A dimension build using a Microsoft
Access data file and a rules file fails when the dimension building field
names are defined in the Access data file.
Operations on Invalid Spreadsheets Cause Application to Shut Down
(14667, P5)
Particular operations on invalid spreadsheet views (ambiguous member
combinations) cause abnormal shutdowns of the application. With this patch,
the crashes are prevented and an error message is displayed.
Application Manager crashes When There is a Large Amount of Text
in the Area Definition of the Partition Wizard (14695, P5)
This fix requires a client upgrade. During partitioning, if the text
in the area definition is more than 4K, the Application Manager crashes
when validating or saving the partition definition.
With Low Virtual Memory, Restructuring All-Dense Databases Crashes
Application (14817, P5)
On certain systems with low virtual memory, loading and restructuring
a database with all dense dimensions causes the application to crash with
an "unable to reallocate memory" message. This fix prevents the
crash.
LISTLINKEDOBJECTS ESSCMD Returns Wrong Modification Date for the
Object (14959, P5)
This fix requires a client upgrade. The LISTLINKEDOBJECTS ESSCMD returns
an incorrect modification date after the date on the client and server
is changed to 2000.
LISTLINKEDOBJECTS and PURGELINKEDOBJECTS ESSCMDs Fail to Recognize
Leap Year 2/29 as Input for the modDate Parameter (14972, P5)
This fix requires a client upgrade. The LISTLINKEDOBJECT and PURGELINKEDOBJECT
ESSCMD commands do not recognize 02/29/2000 as a valid date input.
On NT with Certain Non-English Regional Settings, Excel Spreadsheet
Add-in Returns Failed in GCSetLocale() Error (15023, 15150, 14882
P5)
This fix requires a client upgrade. When running on NT with certain
non-English Regional Settings, the Spreadsheet Add-in returns a Failed
in GCSetLocale() error. With this fix, when DB2 OLAP Server runs on
NT configured with a Regional Setting for a language that is not supported
by GlobalC locales, it will (1) first try to use the operating system's
locales, or (2) failing that, give a warning message and default to English
(United States).
After Using the @PRIOR Function in a Calc Script, Database Statistics
Indicate that an Extra Level-0 Block Has Been Created (15035, P5)
The @PRIOR function used in a calc script (with Create Block on Equation
unchecked in Database Settings) may result in Database Statistics showing
an extra level-0 block.
A Calculation with Calculator Cache On Returns Different Values than
the Same Calculation Run with the Calc Cache Turned Off (15083, 14753 P5)
A calc script using arrays is calculated incorrectly when Calculator
Cache is used; for example, by including the following lines in the ESSBASE.CFG
file:
CALCCACHEHIGH 30000000 CALCCACHEDEFAULT 10000000 CALCCACHELOW 5000000The @ANCESTVAL Function Returns Wrong Values when Level References are Used (15108, P5)
When First Disk Volume has Too Little Space, Loading a Database Configured
with Multiple Disk Volumes Fails after Creation of First Index File (15122,
P5)
When a database is configured with multiple disk volumes and the creation
of that database's first index file fails due to lack of disk space, DB2
OLAP Server does not write to the remaining allocated disk volumes. The
problem does not occur if there is already at least one index file or if
there is so little disk free space on the first disk volume such that the
first index file cannot be created at its creation size of 2 Kb.
With the Excel Spreadsheet Add-in, Lock and Sends or Retrievals in
Certain Spreadsheets Cause the Application to Crash (15154, 15274, 15409,
15648 P5)
With the Excel Spreadsheet Add-in, certain lock and send or retrieval
operations cause the application to crash.
Renaming a Member and its Shared Member with OUTLINECHANGELOG TRUE
in the ESSBASE.CFG file Crashes the Application (15232, P5)
After renaming a member and its shared member with outline change logging
turned on, saving the outline crashes the application.
Using Member Select by Generation Name Causes Application Crash (15342,
P5)
In the Spreadsheet Add-in, using Member Select to view members by generation
name when the members are Dynamic Time Series (DTS) or shared causes the
application to shutdown.
In Some Scenarios, Calculation of Dense Dynamic Calc Members May
be Incorrect in Excel Spreadsheet Add-in Retrievals (15357, P5)
Dense dynamic calculations sometimes produce incorrect results during
data retrieval in Spreadsheet Add-in.
Dynamic Calc with Time Balance Last Returns Incorrect Values (15416,
15418 P5)
Time Balance Last account totals for dynamically calculated periods
show incorrect values under the following conditions:
1. The Time dimension is sparse
2. No data exists for some of the members (for example, Qtr4) that
roll up into the dynamicaly calculated periods.
The following problems are fixed in Patch 4.
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 installation.
Current Time Displays Only Day and Year in the Japanese Version of
DB2 OLAP Server Application Manager. (14198, P4)
The date display for the Japanese version of the DB2 OLAP Server 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.
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 DB2 OLAP Server Version 1.0.1, but not in Version 1.1.
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.
ESSCMD Doesn't Work on Solaris After Customizing the Path to the
Message Database using ARBORMSGPATH Variable (14836, P4)
ESSCMD returns an error "can't init database" on Solaris 2.6
when the ARBORMSGPATH environment variable is used in the .cshrcfile.
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 the DB2 OLAP Server Version
1.1 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 server crashes.
The following problems are 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.
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 server component on windows NT, Windows 95, or Windows 98. 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 Relational Storage Manager (13730, P3)
The message database file has been updated with two new messages.
DB2 OLAP Server Version 1.1 Will Not Install on Solaris 2.7 (13863,
P3)
With this patch, DB2 OLAP Server Version 1.1 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)
DB2 OLAP Server 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.
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 are 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 returns Incorrect Results
(13039, P2)
An Essbase callback function (adSmOtlMbrGetId) for outline restructuring
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.
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 are 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 DB2 OLAP Server, Formulas on Japanese Outline Members Are Deleted After Outline Updating (8685, P1) In the Japanese version of DB2 OLAP Server, 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.
DB2 OLAP Server 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 ]DB2 OLAP Server Fails to Start on NT when the Regional Setting is "Polish" or "English (New Zealand)" (11507, 11945 P1)
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 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 DB2 OLAP Server 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.
ftp://service.software.ibm.com/ps/products/db2olap/fixes/v11/fp13a/
| Filename | Contents | Comments |
|---|---|---|
| 11nt.zip
(Windows NT, Windows 95) |
Windows NT Server
Windows SQL Interface Windows API |
27.2mb |
| 11aix.tar
(AIX) |
AIX Server
AIX SQL Interface AIX API |
21.8mb |
| 11sol.tar
(Sun Solaris) |
Solaris Server
Solaris SQL Interface Solaris API |
15.6mb |
STEP 2: Download the following file, regardless of your national language, to a temporary directory on the machine on which you have installed the clients. This file is from fixpack 13 and is compatible with the server updates in fixpack 13a. You can download the file from:
ftp://service.software.ibm.com/ps/products/db2olap/fixes/v11/fp13/
| Filename | Contents | Comments |
|---|---|---|
| 11us.zip | Application Manager
Spreadsheet add-in for Excel Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through Adobe/English |
15.6mb |
If your language is U.S. English, you can start unpacking the files now, and skip step 3. If you use another national language, proceed to Step 3.
STEP 3: If you use a national language other than U.S. English, download one of the following files, depending on your language, to the machine on which you have installed the clients. This file is from fixpack 13 and is compatible with the server updates in fixpack 13a. You can download the file from:
ftp://service.software.ibm.com/ps/products/db2olap/fixes/v11/fp13/
|
Filename |
Contents | Comments |
|---|---|---|
| 11br.zip
(Portuguese, Brazilian) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11cn.zip
(Chinese, Simplified) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11cz.zip
(Czech) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11de.zip
(German) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11es.zip
(Spanish) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11fr.zip
(French) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11hu.zip
(Hungarian) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11it.zip
(Italian) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11jp.zip
(Japanese) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
29.7mb |
| 11kr.zip
(Korean) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
|
| 11ru.zip
(Russian) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
|
| 11tw.zip
(Traditional Chinese) |
Spreadsheet add-in for Excel
Spreadsheet add-in for Lotus 1-2-3 SQL Drill-Through |
|
tar -xvf tar-file-name
Please enter the path of your 'license.id' file (/home/essbase/bin/):
If you have a license.id file for a previous version, and if you installed the previous version the default directory, then press Enter to accept the default. If you installed the previous version in a different directory, enter that directory.
If you do not have a license.id file, exit the installation program
and run the license program (license.sh or license.exe) from the installation
directory of your previous version. The license program generates the license.id
file after you answer its licensing questions.
#!/bin/sh
PASS=$1
ESSBASE -b -secure << EOF &
${PASS}
EOF
After creating this script, launch the Agent as follows to start it in
the background with <password> secured from process listing details:
essbase.secure <password>
| 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 | - |
| 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 | - | - | - |
EssOtlQueryMembersEx returns extended information
on specific members.
EssOtlGetMemberField retrieves specific fields
of a member.
ESS_OTLQUERYERRORLIST_P stores a list of
errors encountered during an extended member query.
EssOtlQueryMembersEx() queries the outline for specific members
and member fields, and returns an array of member handles. The returned
member handles can be used with other Outline API functions such as EssOtlGetMemberInfo().
(EssOtlGetMemberInfo() can retrieve any of the individual fields
contained in ESS_MEMBERINFO_T and ESS_MBRINFO_T.)
ESS_FUNC_M EssOtlQueryMembersEx (hOutline, pszFieldSelection, pszMemberSelection, pMaxCount, ppMemberArray, ppqryErrorList)
| ESS_HOUTLINE_T | hOutline |
| ESS_STR_T | pszFieldSelection |
| ESS_STR_T | pszMemberSelection |
| ESS_PULONG_T | pMaxCount |
| ESS_PPHMEMBER_T | ppMemberArray |
| ESS_PPOTLQUERYERRORLIST_T | ppqryErrorList |
| hOutline | Essbase outline handle. This must have been returned from EssOtlOpenOutlineQuery(). |
| pszFieldSelection | The query string which defines the set of fields that will be returned for each member. The syntax of pszFieldSelection is shown below. |
| pszMemberSelection | The query string which defines the set of members to be returned. The syntax of this query string is the syntax for member selection; that is, the query string can be anything that you can use in a FIX() statement. |
| pMaxCount | Input: A pointer to the maximum number of member handles to be returned.
Output: A pointer to the number of member handles returned. |
| pphMemberArray | Reference to a pointer to the first in an array of member handles returned. |
| ppQueryErrorList | Reference to a pointer to a structure containing the list of errors in the query. |
QueryString ==: <OutputType Binary | Text <SelectMbrInfo ( FieldName {, FieldName}, ... )
where FieldName is one of the following:
MemberName /* Member name */
MemberLevel /* Member level number */
MemberGeneration /* Member generation number */
Cosolidation /* Whether this member is consolidated */
TwoPass /* Whether this member undergoes a two pass operation */
Expense /* Whether this is an expense member */
CurrencyConvType /* Currency conversion type */
CurrencyMember /* Whether this is a currency member */
TimeBalance /* Time balance measure */
SkipOption /* Whether this member skips the time balance operation */
ShareOption /* Whether this is a shared member*/
StorageType /* Dimension's storage type */
DimensionCategory /* Dimension category: accounts, time, currency, etc. */
DimensionStorageCategory /* Dimension storage category: time, units, scenario, etc. */
Comment /* Member comment */
ChildrenCount /* Number of children */
MemberNumber /* Member number */
DimensionName /* Dimension name */
DimensionNumber /* Dimension number */
MemberAliasName /* Alias for this member */
ParentMemberName /* Parent's name */
ChildMemberName /* Child's name */
PreviousMemberName /* Left sibling's name */
NextMemberName /* Right sibling's name */
CurrencyConversionDatabase /* Whether this database has currency conversion */
MemberStatus /* Member status */
UDAList /* List of UDAs attached to this member */
MemberFormula /* Formula for this member */
MemberValidity /* Whether this member is valid */
member_fields = "<OutputType Binary <SelectMbrInfo ( MemberName, Consolidation, MemberFormula ) "; member_selection = "@ichild(Product), @ichild(Market)"; MaxCount = -1; phMemberArray = ESS_NULL; pqryErrorList = ESS_NULL; sts = EssOtlQueryMembersEx(hOutline, member_fields, member_selection, &MaxCount, &phMemberArray, &pqryErrorList); if (sts != 0) goto error_exit;See Extended Member Query for an example that uses EssOtlQueryMembersEx(), EssOtlGetMemberField(), and ESS_OTLQUERYERRORLIST_T, and includes calls to EssOtlFreeMembers() and EssFree().
ESS_FUNC_M EssOtlGetMemberField(hOutline, hMember, MbrFieldID, ppFieldElement);
| ESS_HOUTLINE_T | hOutline |
| ESS_HMEMBER_T | hMember |
| ESS_ULONG_T | MbrFieldID |
| ESS_PPVOID_T | ppFieldElement |
| hOutline | Essbase outline handle. This must have been returned from EssOtlOpenOutlineQuery(). |
| hMember | Member handle returned by EssOtlQueryMembersEx(). |
| MbrFieldID | One of the following member field identifier constants:
ESS_OTLQRYMBR_NONE ESS_OTLQRYMBR_NAME ESS_OTLQRYMBR_LEVEL ESS_OTLQRYMBR_GENERATION ESS_OTLQRYMBR_CONSOLIDATION ESS_OTLQRYMBR_TWOPASS ESS_OTLQRYMBR_EXPENSE ESS_OTLQRYMBR_CURRENCYCONVTYPE ESS_OTLQRYMBR_CURRENCYCONVNAME ESS_OTLQRYMBR_TIMEBALANCE ESS_OTLQRYMBR_SKIP ESS_OTLQRYMBR_SHARE ESS_OTLQRYMBR_STORAGE ESS_OTLQRYMBR_CATEGORY ESS_OTLQRYMBR_STORAGECATEGORY ESS_OTLQRYMBR_COMMENT ESS_OTLQRYMBR_CHILDCOUNT ESS_OTLQRYMBR_NUMBER ESS_OTLQRYMBR_DIMNAME ESS_OTLQRYMBR_DIMNUMBER ESS_OTLQRYMBR_ALIASNAME ESS_OTLQRYMBR_NEXTNAME ESS_OTLQRYMBR_PREVNAME ESS_OTLQRYMBR_PARENTNAME ESS_OTLQRYMBR_CHILDNAME ESS_OTLQRYMBR_UDA ESS_OTLQRYMBR_FORMULA ESS_OTLQRYMBR_LASTFORMULA ESS_OTLQRYMBR_EXTCOMMENT ESS_OTLQRYMBR_ALIASCOMBO ESS_OTLQRYMBR_VALID ESS_OTLQRYMBR_CURRENCYCONVDB ESS_OTLQRYMBR_STATUS ESS_OTLQRYMBR_MBRINFO |
| ppFieldElement | Returned pointer to the required field element. |
typedef struct ESS_OTLQUERYERRORLIST_T
{
ESS_ULONG_T ulCount;
ESS_OTLQUERYERROR_T* ErrorArray;
} ESS_OTLQUERYERRORLIST_T, *ESS_POTLQUERYERRORLIST_T, **ESS_PPOTLQUERYERRORLIST_T;
| Data Type | Field | Description |
| ESS_ULONG_T | ulCount | Number of errors returned during a query |
| ESS_OTLQUERYERROR_T* | ErrorArray | Pointer to an array of errors returned during a query |
#include <windows.h>
#include <essapi.h>
#include <essotl.h>
#include <string.h>
#include <stdio.h>
#include <stdlib.h>
#define AD_CHK_PRINTF_1(ARG1, ARG2)
do
{
printf(ARG1, (ARG2) ? (ARG2) : "NullValue");
}
while (0)
void PrintResult(ESS_HCTX_T hCtx,
ESS_HINST_T hInst,
ESS_HOUTLINE_T hOutline,
ESS_HMEMBER_T hMbr)
{
ESS_PMBRINFO_T pMbrInfo = NULL;
ESS_STS_T sts;
int size;
ESS_STR_T pszFormula = NULL;
ESS_STR_T pszLastFormula = NULL;
ESS_STR_T pszCommentEx = NULL;
ESS_STR_T pszAlias = NULL;
ESS_STR_T pszAliasCombo = NULL;
ESS_PMBRNAME_T pUDAList = NULL;
ESS_USHORT_T iCount = 0;
ESS_STR_T pszPrev = NULL;
ESS_USHORT_T iIndex;
ESS_ULONG_T* pMemNum;
ESS_ULONG_T* pDimNum;
ESS_STR_T pDimName = NULL;
ESS_STR_T pAliasName = NULL;
ESS_STR_T pNextName = NULL;
ESS_STR_T pPrevName = NULL;
ESS_STR_T pParentName = NULL;
ESS_STR_T pChildName = NULL;
ESS_BOOL_T* pCurrConv = NULL;
ESS_ULONG_T* pStatus = NULL;
sts = EssOtlGetMemberInfo(hOutline, hMbr, &pMbrInfo);
if (sts != 0) goto Error;
size = sizeof(ESS_MBRINFO_T);
printf("MbrInfo\n");
AD_CHK_PRINTF_1(" szMember --------------->(%s)\n", pMbrInfo->szMember);
printf(" usLevel --------------->(%hd)\n", pMbrInfo->usLevel);
printf(" usGen ----------------->(%hd)\n", pMbrInfo->usGen);
printf(" usConsolidation ------->(%hd)\n", pMbrInfo->usConsolidation);
printf(" fTwoPass -------------->(%hd)\n", pMbrInfo->fTwoPass);
printf(" fExpense -------------->(%hd)\n", pMbrInfo->fExpense);
printf(" usConversion ----------->(%hd)\n", pMbrInfo->usConversion);
AD_CHK_PRINTF_1(" szCurMember ------------>(%s)\n", pMbrInfo->szCurMember);
printf(" usTimeBalance ---------->(%hd)\n", pMbrInfo->usTimeBalance);
printf(" usSkip ----------------->(%hd)\n", pMbrInfo->usSkip);
printf(" usShare ---------------->(%hd)\n", pMbrInfo->usShare);
printf(" usStorage -------------->(%hd)\n", pMbrInfo->usStorage);
printf(" usCategory ------------->(%hd)\n", pMbrInfo->usCategory);
printf(" usStorageCategory ------>(%hd)\n", pMbrInfo->usStorageCategory);
AD_CHK_PRINTF_1(" szComment -------------->(%s)\n", pMbrInfo->szComment);
printf(" ulChildCount ----------->(%ld)\n", pMbrInfo->ulChildCount);
sts = EssOtlGetMemberFormula(hOutline, hMbr, &pszFormula);
if (sts) printf("sts=%d ", sts);
AD_CHK_PRINTF_1("szFormula ------------------>(%s)\n", pszFormula);
sts = EssOtlGetMemberLastFormula(hOutline, hMbr, &pszLastFormula);
if (sts) printf("sts=%d ", sts);
AD_CHK_PRINTF_1("szLastFormula -------------->(%s)\n", pszLastFormula);
sts = EssOtlGetMemberCommentEx(hOutline, hMbr, &pszCommentEx);
if (sts) printf("sts=%d ", sts);
AD_CHK_PRINTF_1("szCommentEx ---------------->(%s)\n", pszCommentEx);
sts = EssOtlGetMemberAlias(hOutline, hMbr, ESS_NULL, &pszAlias);
if (sts) printf("sts=%d ", sts);
AD_CHK_PRINTF_1("szAlias (Default)----------->(%s)\n", pszAlias);
sts = EssOtlGetNextAliasCombination(hOutline, hMbr, ESS_NULL, "\0", &pszAliasCombo);
if (sts) printf("sts=%d ", sts);
printf("szAliasCombo ::\n" );
pszPrev = pszAliasCombo;
while (sts && pszAliasCombo)
{
AD_CHK_PRINTF_1("\t(%s)\n", pszAliasCombo);
sts = EssOtlGetNextAliasCombination(hOutline, hMbr, ESS_NULL, pszPrev, &pszAliasCombo);
EssFree(hInst, pszPrev);
pszPrev = pszAliasCombo;
}
sts = EssOtlGetUserAttributes(hOutline, hMbr, &iCount, &pUDAList);
if (sts) printf("sts=%d ", sts);
printf("User Defined Attributes ::\n");
for(iIndex = 0; iIndex < iCount; iIndex++)
AD_CHK_PRINTF_1("\t(%s)\n", pUDAList[iIndex]);
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_NUMBER, (ESS_PPVOID_T) &pMemNum);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
printf("Member Number ------------------>(%ld)\n", *pMemNum);
EssFree(hInst, pMemNum);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_DIMNUMBER, (ESS_PPVOID_T) &pDimNum);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
printf("Dimension Number ---------------->(%ld)\n", *pDimNum);
EssFree(hInst, pDimNum);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_DIMNAME, (ESS_PPVOID_T) &pDimName);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
AD_CHK_PRINTF_1("Dimension Name ------------------>(%s)\n", pDimName);
EssFree(hInst, pDimName);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_ALIASNAME, (ESS_PPVOID_T) &pAliasName);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
AD_CHK_PRINTF_1("Alias Name ------------------>(%s)\n", pAliasName);
EssFree(hInst, pAliasName);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_NEXTNAME, (ESS_PPVOID_T) &pNextName);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
AD_CHK_PRINTF_1("Next Mbr Name ------------------>(%s)\n", pNextName);
EssFree(hInst, pNextName);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_PREVNAME, (ESS_PPVOID_T) &pPrevName);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
AD_CHK_PRINTF_1("Prev Mbr Name ------------------>(%s)\n", pPrevName);
EssFree(hInst, pPrevName);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_PARENTNAME, (ESS_PPVOID_T) &pParentName);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
AD_CHK_PRINTF_1("Parent MbrName ------------------>(%s)\n", pParentName);
EssFree(hInst, pParentName);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_CHILDNAME, (ESS_PPVOID_T) &pChildName);
if (sts)
{
printf("sts=%d ", sts);
}
else
{
AD_CHK_PRINTF_1("Child Mbr Name ------------------>(%s)\n", pChildName);
EssFree(hInst, pChildName);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_CURRENCYCONVDB, (ESS_PPVOID_T) &pCurrConv);
if (sts)
{
printf("sts=%d ", sts); printf("Curr Conv Type ------------------>\n");
}
else
{
AD_CHK_PRINTF_1("Curr Conv Type ------------------>(%ld)\n", *pCurrConv);
EssFree(hInst, pCurrConv);
}
sts = EssOtlGetMemberField(hOutline, hMbr, ESS_OTLQRYMBR_STATUS, (ESS_PPVOID_T) &pStatus);
if (sts)
{ printf("sts=%d ", sts); printf("Status ------------------>\n"); }
else
{
printf("Status ------------------>(%hd)\n", *pStatus);
EssFree(hInst, pStatus);
}
EssFree(hInst, pMbrInfo);
EssFree(hInst, pszFormula);
EssFree(hInst, pszLastFormula);
EssFree(hInst, pszCommentEx);
EssFree(hInst, pszAlias);
EssFree(hInst, pszAliasCombo);
return;
Error:
printf("******************* Error *************************");
}
int TestCode_EssOtlQueryMembersEx(ESS_HCTX_T hCtx,
ESS_HINST_T hInst)
{
ESS_STS_T sts = ESS_STS_NOERR;
ESS_HOUTLINE_T hOutline;
ESS_OBJDEF_T Object;
ESS_HMEMBER_T hMember = 0;
ESS_PHMEMBER_T phMemberArray = ESS_NULL;
ESS_ULONG_T i;
unsigned long MaxCount = -1;
ESS_STR_T member_fields;
ESS_STR_T member_selection;
/* query string to get level numbers of all markets members */
member_fields = "<OutputType Binary <SelectMbrInfo ( MemberName, MemberLevel,Consolidation, MemberFormula ) ";
member_selection = "@ichild(Product), @ichild(Market)";
memset(&Object, '\0', sizeof(Object));
Object.hCtx = hCtx;
Object.ObjType = ESS_OBJTYPE_OUTLINE;
Object.AppName = "Basic";
Object.DbName = "Demo";
Object.FileName = "Demo";
sts = EssOtlOpenOutlineQuery(hCtx, &Object, &hOutline);
if (sts) goto exit;
if(!sts)
{
ESS_POTLQUERYERRORLIST_T pqryErrorList;
sts = EssOtlQueryMembersEx(hOutline, member_fields, member_selection, &MaxCount, &phMemberArray, &pqryErrorList);
if (sts) goto exit;
if (phMemberArray)
for (i = 0; i< MaxCount; i++)
PrintResult(hOutline, phMemberArray[i]);
}
if(MaxCount && phMemberArray)
{
sts = EssOtlFreeMembers(hOutline, MaxCount, phMemberArray);
if (sts)
printf("EssOtlFreeMembers sts = %d\n",sts);
}
sts = EssOtlCloseOutline(hOutline);
exit:
return sts;
}
Return to EssOtlQueryMembersEx() or EssOtlGetMemberField().
To use this option, add the line EVENT 28 to Hyperion ESSBASE.CFG and
restart Essbase.
Copyright (c) 1991-2000 by Hyperion Solutions Corporation. All Rights Reserved.