Enables parallel calculation, defining the number of processing threads.
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.
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.
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.
CALCPARALLEL 3
enables up to three threads to perform calculation tasks at the same time.
CALCTASKDIMS
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |