Advanced Options dialog box

This dialog box enables you to increase performance when processing results or importing data from other sources.

To access Analysis > Tools > Options > Database tab > Advanced button
See also Database tab

User interface elements are described below:

Option Description
Create separate threads for inserting Analysis data into the database

This option may consume a large amount of memory on your database server, and should only be used if you have sufficient memory resources.

Use SQL parameters to utilize the SQL Server memory buffer

This option is only enabled when you store result data on an SQL server.

Back to top