CALCPARALLEL

Enables parallel calculation, defining the number of processing threads.

Syntax

CALCPARALLEL [appname [dbname]] n

appname An optional parameter specifying that parallel calculation applies to all databases on the named application. If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application. If you do not specify an application, you cannot specify a database and the setting applies to all applications and databases on the Analytic Server.
dbname An optional parameter specifying that parallel calculation applies only to the database named. If you specify a value for dbname but do not include appname, the parameter is ignored and parallel calculation is enabled for all applications and databases on the Analytic Server.
n

A required parameter that specifies the number of threads to be made available for parallel calculation.

  • For block storage, an integer from 1-4. The default value, 1, specifies serial calculation: no parallel calculation takes place.
  • For aggregate storage, an integer from 1-8, with 2 the default value.

A value less than 1 is interpreted as the default size. A value greater than the maximum size is interpreted as the maximum size.

You must restart Analytic Server to initialize any change to the configuration file.

Description

This setting enables parallel calculation. For block storage databases, Analytic Services analyzes each pass of a calculation to determine whether parallel calculation would optimize the calculation. If it would not, Analytic Services uses serial calculation even if CALCPARALLEL is set to a number greater than 1.

Notes

Example

CALCPARALLEL 3
enables up to three threads to perform calculation tasks at the same time.

See Also

CALCTASKDIMS
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com