RESTRUCTURETHREADS

This Essbase configuration setting specifies whether parallel restructuring is enabled for a cube, and the number of threads to use.

This setting does not apply to aggregate storage cubes.

Syntax

RESTRUCTURETHREADS [ appname [ dbname] ] n

appname—Application name. Optional parameter for enabling parallel restructuring for one or all cubes in an application.
dbname—Database (cube) name. Optional parameter for enabling parallel restructuring for an individual cube. This parameter must be used in combination with appname.
n—Number of threads to use in parallel restructuring. The default is 1.

Notes

Use the value xxxxx to indicate "all" for any application or cube argument. For example:

RESTRUCTURETHREADS xxxxx Basic 2

enables parallel restructuring for any application with a Basic cube.
Settings for nonexistent applications or cubes are ignored.
Oracle recommends setting an application’s RESTRUCTURETHREADS to 2 for most systems (with a maximum of 4), or 4 if the application runs on Exalytics (maximum of 8). Check your calculation and restructure performance after making any changes.

Description

This setting specifies whether parallel restructuring is enabled for a cube, and the number of threads to use. You can enable parallel restructuring for individual cubes, or for all cubes in an application. For more information about parallel restructuring, see Parallel Restructuring.

Examples

RESTRUCTURETHREADS Sample 2

Specifies two threads and applies to all databases in the Sample application

RESTRUCTURETHREADS Sample Basic 4

Specifies four threads and applies to the Basic database in the Sample application