Find Constituents
The Find Constituents process finds all source data to be aggregated for a given aggregation measuring component, based on the Aggregation Measuring Component’s dimensions. The queries used for this process are based on data source template SQL extended by attributes defined on the Aggregation Measuring Components being processed.
The Find Constituents process is initiated by the aggregation algorithm on the Aggregation Measuring Component (each type of Aggregation Measuring Component — interval, item, billed quantities — has its own aggregation algorithm), and is performed by algorithms defined for the Find Constituents system event on the Aggregation Measuring Component business object.
This process differs slightly when finding constituents for interval and scalar measurements stored on measuring components, item data, and billed quantities.
Measuring Components
The Find Constituents process for measuring components uses the Find Constituents for Dynamic Aggregation (D1-FINDCONST) algorithm which retrieves data based on the following:
• Attributes on the Aggregation Measuring Component based on the Measuring Component Set configuration
• Measuring Component Types on the Data Source
Measuring component constituents are inserted into a global temporary table (GTT1) with the following information:
• Measuring Component ID
• Horizon Start Date/Time
• Horizon End Date/Time
• Time Zone
Note:
The aggregation period for each is adjusted by the source Measuring Component’s installation history.
Items
The Find Constituents process for items uses the Find Constituents for Items (D1-FICONITEM) algorithm which retrieves data based on the following:
• Attributes on the Measuring Component based on the Measuring Component Set configuration
• Item Types / Service Point Types on the Data Source (for badged vs. unbadged items, respectively)
Item constituents are inserted into a global temporary table (GTT3) with the following information:
• Maintenance Object (Device or Service Point)
• Device Type: Item Type
• Item Count
• Horizon Start Date/Time
• Horizon End Date/Time
• Time Zone
Note:
The aggregation period for each is adjusted by the source Item’s installation history.
Billed Quantities
The Find Constituents process for billed quantities uses the Find Constituents for Billing Data (D1-FINDCONSB) algorithm which retrieves data based on the following:
• Attributes on the Aggregation Measuring Component based on the Measuring Component Set configuration
• Usage Subscription Types on the Data Source
Billed quantity constituents are inserted into a global temporary table (GTT5) with the following information:
• Usage Subscription ID
• Usage ID
• Horizon Start Date/Time
• Horizon End Date/Time
• Time Zone
Note:
The aggregation period for each is adjusted by the source Usage Subscription’s installation history.