This Essbase configuration setting defines the default number of threads that can be produced during parallel data export.
EXPORTTHREADS appname dbname n
appname—This is the name of the application. You can also use
xxxxxas a wildcard to indicate all application names.
dbname—This is the name of the database. You can also use
xxxxxas a wildcard to indicate all database names.
n—This integer sets the default for the number of export threads that can be used to export data. The default is 1.
Block storage cubes: The number of threads is an integer, between 1 and 1024, inclusive. The number of available block-address ranges limits the number of export threads. Essbase divides the number of actual data blocks by the specified number of export threads. If there are fewer actual data blocks than the specified number of export threads, the number of export threads that are created is based on the number of actual data blocks. This approach results in a more even distribution of data blocks between export threads.
In specifying the number of export files, it is important to consider the number of available CPU cores and I/O bandwidth on the computer on which Essbase Server runs. Specifying too large a number can result in poor performance.
Aggregate storage cubes: The number of threads is an integer, between 1 and 8, inclusive. This number should generally be equal to the number of processors on the machine that you wish to commit to doing parallel export. However, for parallel export on a very small aggregate storage cube with a small number of data blocks, it is possible that only a single file will be created (in effect, performing serial export), even though parallel export to multiple files is requested. In this case, the export file name will be the first file name given as input.
This setting enables the user to specify the number of threads that can be used to export data. The export process is then executed in parallel, and multiple threads can retrieve data and write to their corresponding export files concurrently. If EXPORTTHREADS is not specified, or is not followed by its arguments, then the default value of 1 is used.
EXPORTTHREADS Sample Basic 4