TNPM Wireless Component - Building TIP/TCR Report for rollup aggregation at non-key data item
BengSee 2700018NMH Visits (3146)
The following illustrates the steps involved in building report for rollup aggregation on non-key data item using HOUR_KEY.
Network Object Hierarchy. 'Node' has a child 'Processor'.
Processor has the following KPIs:
1. For each hour for a Processor Id, average the Load.
2. Total the processors' load for each Node at the report output.
a. Create a query which contain the following:
On the data item expression for 'load', enter the aggregation 'average'.
Note: Query filter is configured accordingly.b. Create a query derived from the query created in Step a above, with the following:
On the data item expression for 'load', enter the aggregation 'total'.
c. Output analysis:
Sample data available:
Result of Query from Step a.
Result of Query from Step b as the report output:
Node Id Hour_Key Load