General Page
The TurboIntegrator scripting language includes the following direct Metadata functions for dimension updates.
DimensionElementInsertDirect
DimensionElementComponentAddDirect
These functions support changes to dimension structures the Data section of a TurboIntegrator process. Without the use of the direct functions changes to dimension structures must be performed in the Metadata section of the TurboIntegrator process. The TurboIntegrator process will process each row of the data source for both the Metadata and Data section, assuming each section is not left blank. Leaving either the Metadata or Data section of the TurboIntegrator process blank allows the TurboIntegrator process to process the data source once. Processing the data source once may provide a performance benefit.
This document explains additional considerations when using the direct metadata functions.
DimensionElementInsertDirect
DimensionElementComponentAddDirect
These functions support changes to dimension structures the Data section of a TurboIntegrator process. Without the use of the direct functions changes to dimension structures must be performed in the Metadata section of the TurboIntegrator process. The TurboIntegrator process will process each row of the data source for both the Metadata and Data section, assuming each section is not left blank. Leaving either the Metadata or Data section of the TurboIntegrator process blank allows the TurboIntegrator process to process the data source once. Processing the data source once may provide a performance benefit.
This document explains additional considerations when using the direct metadata functions.
Performance When Creating Fed Cells
An intentional change was made in Planning Analytics 2.0.4 to ensure that feeders are generated for cell created when adding elements to a dimension using the DimensionElementInsertDirect and DimensionElementComponentAddDirect functions. This change may have a a significant negative impact on performance if cells being created are addressed by a feeder statement. This is caused by an automatic reevaluation of feeder statements. Depending on the time to reevaluate feeder statements it may appear that the TurboIntegrator process is hung.
In the same scenario, Planning Analytics 2.0.3 and lower require the explicit use of the CubeProcessFeeders function at the end of TurboIntegrator process. These versions of Planning Analytics will not automatically reprocess feeders. The use of the CubeProcessFeeders function will also have an impact on performance.
The use of the non direct metadata functions, DimensionElementInsert and DimensionElementComponentAdd, should be evaluated when new cells, requiring feeders, are created by a TurboIntergrator process. Processing the data source in both the Metadata and Data sections may provide better performance than using the direct metadata functions and reprocessing feeders. The actual impact on performance depends on the number of cells created, number of data source rows, and the complexity of feeder statements to be processes. The only practical method to determine actual impact on performance testing and comparison of the direct and non-direct metadata functions.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000Gn0QAAS","label":"General"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
09 June 2021
UID
ibm16232706