1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. DEXPSQLROWSIZE

DEXPSQLROWSIZE

When the DATAEXPORT calculation command is used to export data directly into a relational database and when the batch-insert method is used, the DEXPSQLROWSIZE Essbase configuration setting allows you to specify the number of rows to be inserted at one time.

To enable batch insert, set the DATAEXPORTENABLEBATCHINSERT configuration setting to TRUE. Essbase determines whether the relational database and the ODBC driver permit batch insert. If they do, Essbase determines the batch size unless you set DEXPSQLROWSIZE. If Essbase cannot determine whether the relational database and the ODBC driver support batch insert, it uses the row-insert method, and DEXPSQLROWSIZE (if set) is ignored.

The DEXPSQLROWSIZE and DATAEXPORTENABLEBATCHINSERT configuration settings apply to block storage cubes only.

DEXPSQLROWSIZE [appname [dbname]] n

  • appname—Optional. Specifies the application for which to set the number of rows to be inserted at one time.

    If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified application.

    To enable the setting for a specific cube, you must specify an application and cube.

    If you do not specify an application, you cannot specify a cube, and the setting applies to all applications and cubes on Essbase Server.

  • dbname—Optional. Specifies the database (cube), in the application specified by appname, for which to set the number of rows to be inserted at one time.

    If you specify a value for dbname but do not specify a value for appname, your specification is ignored, and data associated with logged transactions is archived for all applications and cubes on Essbase Server.

  • n—The number of rows in the batch (from 2 to 1000). The default is 10.

Notes

  • If DATAEXPORTENABLEBATCHINSERT is set to TRUE and DEXPSQLROWSIZE is set to 1, batch insert is disabled (as a DEXPSQLROWSIZE setting of 1 inserts one row at a time).

  • When using DATAEXPORT to export data for direct insertion into a relational database:

    • The table to which the data is to be written must exist prior to the data export

    • Table and column names cannot contain spaces

Example

DEXPSQLROWSIZE Sample Basic 300

Specifies a 300-record batch size for data exported from Sample.Basic to a relational database using DATAEXPORT.

DEXPSQLROWSIZE Sample 500

Specifies a 500-record batch size for data exported from any database within the Sample application to a relational database using DATAEXPORT.

See Also

DATAEXPORT calc command

DATAEXPORTENABLEBATCHINSERT configuration setting