E5MS Same Statistics For Different Times in Reporting Studio Customized Report

Asset ID:	1-71-2313297.1
Update Date:	2017-10-12
Keywords:

Solution Type Technical Instruction Sure

Solution 2313297.1 : E5MS Same Statistics For Different Times in Reporting Studio Customized Report

Applies to:

Oracle Communications EAGLE (Software) - Version E5-MS 46.2 and later
Tekelec

Goal

Same Message Transmit values in Reporting studio report for different times in the reporting studio Eagle measurement report.

Solution

The table used for creating the customized report does not contain all the information for different times.Hence same data for different times.
customer is trying to create report using the table tek_lui_link_data. This table does not contain data for all the different times.

For example, login to Mysql and run below mentioned command there will be only one row per link. Hence that data will be copied throughout the report.:

select * from tek_lui_link_data where CLLI like 'stpclli' and LOC=xxxx and LSN like 'lsn';

Replace stpcllli with exact stp name, xxxx with card location on which link is present and lsn with the linkset name.

In order to get what you need, try fetching data from some other table like TEK_MEAS_COMP_LINK in conjunction with tekelec_meas_headers.

However please note that Technical Support team does not customize configurations for custom reports. Customer may contact Oracle consulting via their Technical Account Manager for help with customizing the Reporting Studio Reports.

Attachments

This solution has no attachment