CALCOPTCALCHASHTBL specifies whether Hyperion Essbase optimizes the calculation of large, flat database outlines.
CALCOPTCALCHASHTBL TRUE | FALSE
TRUE | Optimizes the calculation of large, flat database outlines; for example, where one member has more than 5,000 children. |
FALSE | Does not optimize the calculation of large, flat database outlines. The default is FALSE. |
This setting tells Hyperion Essbase whether to use a hash table to optimize use of the calculator cache for large, flat databases. A large, flat database is, for example, a database in which one or more members has over 5,000 children. Using this feature may significantly improve the performance of a CALC ALL of the database or CALC DIM of the dimension containing the member with over 5000 children. For more information on the calculator cache, see the Hyperion Essbase Database Administrator's Guide.
You can override the CALCOPTCALCHASHTBL ESSBASE.CFG
setting by using the SET CALCHASHTBL command in a calc script.
If Hyperion Essbase reaches the hash table memory limit during calculation,
Hyperion Essbase cannot use the hash table method. You can set the limit
of the hash table using the CALCHASHTBLMEMORY setting in
the ESSBASE.CFG
file.
CALCOPTCALCHASHTBL TRUE
CALCHASHTBLMEMORY
SET CALCHASHTBL (calculation command)
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.