Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Global Parameters for Indexing

Use

You use this dialog box to edit the default values for the global indexing parameters.

Integration

To navigate to this dialog box, on the BI Accelerator Monitor screen (transaction RSDDBIAMON2), choose BI Accelerator -> Index Settings -> Change Global Parameters.

Features

Global Indexing Parameters


Name


Description


Value (Changeable)


BATCHPARA


Number of Processes for Background Parallel Processing of Initial Indexing
Number of parallel background processes for initial indexing: F and E fact tables of the InfoCube are split into a number of blocks. The BACTHPARA parameter specifies the number of blocks. (The E table is split using the partitioning characteristic or another time characteristic; the F table is split using the request.) These blocks are then read from the database and written to the BI accelerator separately. (Note that a number of dialog processes, as specified in the NUMPROC parameter, are used for each background process.)
This applies to initial indexing only and not roll up.
You can change the values for these parameters in transaction RSBATCH (process type TREXINDEXP).


03


NUMPROC


Number of Processes for Parallel Processing Using aRFC Dialog Processes During Indexing
The data is read from the database table on a package-by-package basis using Open Cursor and Fetch. The system calculates the package size from the width of the table and the default value for the package size (in bytes) in the system.
If you set a degree of parallelization that is greater than one, each of these packages is indexed in a new asynchronous job in dialog mode. When the indexing job for the package is started, the system reads a new package immediately. Ideally, you should reduce the indexing time to the time that is required to read the data and pack it for the RFC module.
If the degree of parallelization is equal to one, the system performs serial processing.
The optimization of the BI accelerator index cannot be parallelized on the BI side. However, optimization automatically runs in parallel on the BI accelerator server if the index is split.


4


PKGSIZE


Package Size in Bytes for Internal Tables During Indexing Using aRFCs


5.000.000


SUBPKGSIZE


Package Size (Rows) for Export to Buffer During Indexing Using aRFCs
During dialog parallel processing with the NUMPROC parameter, packages with size PKGSIZE are read and indexed using aRFCs. To do this, the data packages must be transferred using Export to Data Buffer. This is done on a package-by-package basis since it requires a large amount of CPU and memory resources. The SUBPKGSIZE parameter specifies the number of rows for the package. We recommend a value between 10,000 and 20,000.


5000

Activities

You use this dialog box to edit the values of the global indexing parameters.

  • No labels