1. Analytical Application Infrastructure User Guide
  2. Command Line Utilities
  3. Command Line Utility for Resaving Derived Entities and Essbase Cubes
  4. Command Line Utility for Partition-Based Derived Entities
  5. Manage Derived Entity Performance

Manage Derived Entity Performance

The application is enhanced to manage the performance of derived entities at an enterprise level. You can configure the performance at an individual derived entity definition level. The database table METADATA_PERFORMANCE_PARAMS holds this configuration. Provide the required performance parameters in the database table with the details shown in the following illustration and table:

Figure 16-2 Example of the METADATA_PERFORMANCE_PARAMS Table


You can view an example of the METADATA_PERFORMANCE_PARAMS table that stores the configuration for the performance at an individual derived entity definition level.

Table 16-15 METADATA_PERFORMANCE_PARAMS Table Details

Table Name Parameter
V_METADATA_CODE The DE Code.
N_METADATA_TYPE The type is 856.
V_METADATA_INFODOM The name of the metadata Infodom.
V_SELECT_HINT The query for select hint.
V_INSERT_HINT The query for insert hint.
V_PARALLELISM The query for parallelism.
V_PRESCRIPTS The query for prescripts to modify connection session attributes, this gets executed before firing the derived entity queries.
V_POSTSCRIPTS The query for postscripts rollback connection session attributes, this gets executed after completion of derived entity queries.