-C

To set the number of records that Integration Server commits to Essbase:

In Windows, add -Cnumber_of_records to the startup.bat file.
In UNIX, type -Cnumber of records when you start Integration Server.
In Windows or UNIX, add [C]=number_of_records to the ais.cfg file.

The default setting is all records.

-C can be used with the ‑N switch.

Note:

-C should not be used in operations involving aggregate storage.

-C is often used in testing environments. The recommended setting for testing purposes is 5,000 to 10,000 records. After you have completed testing, shut down Integration Server to revert to the default setting, or reset to the limit allowed by DATAERRORLIMIT.

When -C is used with the DATAERRORLIMIT setting in the essbase.cfg file, you can maximize the number of records written to dataload.txt, the data load error file. For example, if you set DATAERRORLIMIT to 65,000, the maximum number of error records allowed in the Essbase log, and then set -C to 65,000 or less, you will be able to view all error records allowed by Essbase.

Note:

If you have included a setting for testing purposes for -C in ais.cfg, be sure to edit the file to clear the ais.cfg file so that it will change the setting back to “all records.”

Setting a smaller number of records during testing enables you to see data load errors incrementally, providing you an opportunity to correct problems before continuing. Resetting the number of records to the default of all records results in faster performance.

There is no limit to the number of records that Integration Server can transfer to Essbase during a data load. If, however, you experience memory problems during a data load, set -C to a smaller value.

Note:

The setting of -C does not apply to member loads.

In Windows:

For example, in the startup.bat file, to set the number of records that Integration Server incrementally transfers to Essbase during a data load to 5,000, add -C5000 after "C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe". For example:

"C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eis\server\bin\olapisvr.exe" -C5000

In UNIX:

For example, to set the number of records that Integration Server incrementally transfers to Essbase during a data load to 5,000, type:

olapisvr -C5000

In Windows or UNIX:

For example, to set the number of records that Integration Services incrementally transfers to Essbase during a data load to 5,000, in the ais.cfg file, type:

[C]=5000