TNPM Wireless Component - Building TCR Report of Foreign Busy Hour
BengSee 2700018NMH Visits (3007)
This post shows how to build a TCR report of foreign busy hour. The sample used is based on CDMA Vendor Neutral pack.
The Tech Pack network hierarchy:
The report specification defined the following:
1. Report at MSC level.
2. BH Determiner is taken from C_TrafficType, KPI 'Traffic'.
3. BH Values are taken from C_Destination, KPIS 'Calls', 'Answered', 'Traffic', etc.
1. Create a custom rollup busy hour, and provision it in the TNPM platform.
Building TCR report:
This query contains the following data item:
TSTAMP (The busiest time of the determiner) is renamed to BH_TIME.
CMSC_ID is renamed it to BH_MSC_ID.The BH Common Pack example:
The BH determiner query content:
Note: Use hourly raw Common Pack if it is available, and change the join expression accordingly.