Using the SET Commands Template in a Business Rule (Planning and Essbase Block Storage Users Only)

You use the SET Commands template to enter script commands that optimize the performance of calculation scripts. You can include data volume, data handling, memory usage, and threading and logging script commands.

  To use the SET Commands template in a business rule:

  1. Complete step 1 through step 4.

  2. In the SET Commands Template Wizard, on Data Volume:

    1. Specify whether to calculate all data blocks or only those marked as dirty. Using intelligent calculation, only dirty blocks, such as updated data blocks and their dependent parents, are calculated. Therefore, the calculation is very efficient.

    2. Specify when to mark data as clean.

    3. Specify whether to stop the calculation if the FIX command evaluates to an empty member set.

    4. Specify whether to optimize the calculation of complex formulas on sparse dimensions within large database outlines.

      See the Oracle Essbase Database Administrator's Guide.

    5. Click Next.

  3. On Data Handling:

    1. Specify whether to consolidate missing data values.

    2. Specify whether to create new data blocks when a calculation formula assigns anything other than a constant to a member of a sparse dimension.

    3. Specify whether to create blocks in memory and whether to store missing data blocks.

    4. Specify whether to turn off calculation of dense dynamic calc members during batch calculation, if runtime dependent functions are included in formulas on stored members.

    5. Specify whether to turn remote calculation to the source on for applications with transparent partitions.

      See the Oracle Essbase Database Administrator's Guide.

    6. Click Next.

  4. On Memory Usage:

    1. Specify the size of the calculator cache.

      • High: A calculator cache with the maximum number of bytes is used.

      • Default: A calculator cache with the default number of bytes is used.

      • Low: A calculator cache with the minimum number of bytes is used.

      • Off: No calculator cache is used.

      • All: A calculator cache is used even if one full sparse dimension is not calculated.

      • No changes (use system default): Whatever the system uses by default is used.

        Note:

        This option does not display in the script of the rule.

    2. Specify the maximum number of blocks that can be locked when calculating a sparse member formula.

      • High: the maximum number of blocks that can be fixed concurrently when one block is being calculated

      • Default: the default number of blocks that can be fixed concurrently when one block is being calculated

      • Low: the minimum number of blocks that can be fixed concurrently when one block is being calculated

      • No changes (use system default): the number of blocks the system fixes concurrently when one block is being calculated

        Note:

        This option does not display in the script of the rule.

    3. Click Next.

  5. On Threading:

    1. Specify whether to enable parallel calculation by selecting the number of threads to be available for parallel calculation. (By default, serial calculation is used, but parallel calculation may optimize the calculations.)

      • For block storage on 32-bit platforms, select an integer from 1-4.

      • For block storage on 64-bit platforms, select an integer between 1-8.

        Note:

        If you select Off, serial calculation is used; no parallel calculation takes place.

      • For aggregate storage, select an integer from 1-8. Two is the default value.

    2. Specify how many of the sparse dimensions in the outline should be used to identify potential tasks that can be run in parallel. You can enter a value or use the Actions icon to select a member or variable that holds this value.

      • Select the default value, 1, to indicate that only the last sparse dimension in the outline should be used to identify tasks.

      • Enter a value of 2, for example, to indicate that the last and second-to-last sparse dimensions in the outline should be used.

      • Enter the maximum value, which is the total number of sparse dimensions in the outline to indicate that all sparse dimensions in the outline should be used.

    3. Click Next.

  6. On Logging:

    1. Select the level of error reporting for calculations:

      • Summary: Displays calculation settings and provides statistics on the number of data blocks created, read, and written, and the number of data cells calculated

      • Detail: Provides the same information as SUMMARY. In addition, it displays a detailed information message every time a data block is calculated.

      • Error: Displays only error messages

      • Info: Displays only informational, warning, and error messages

      • None: Displays no messages during execution of the calculation script. However, because error messages may contain vital information, they are still displayed.

      • Only: Performs a simulated calculation only. You may disregard any error message during validation that indicate that a command is not recognized.

    2. Specify whether to monitor the progress of the calculation by having completion notices generated at intervals during the calculation.

      • High: Generates the maximum number of completion notices

      • Default: Generates the default number of completion notices

      • Low: Generates the minimum number of completion notices

  7. Click Finish.