Customers Businesses often require the processing of usage event data from a number of different Carrier data sources. These sources all share a typically are their own distinct usage format and may contain one or more types of usage (e.g. APIs, Instance counts, CPU time utilization, Data, Voice, SMS …). Mediation is the process of interpreting these usage fields and mapping them to internal constructs that the rating engine can then rate and charge.
Usage feeds files that are to be mediated can either be pushed into LogiSense Billing programmatically via API or sent are uploaded to the system via SFTP or by API. Mediation is essentially an exercise in data mapping. LogiSense provides a visual , UI user interface driven mechanism for mapping feed data and transforming it into entities that the core rating engine can interpret.
...
One or more filters can be applied for any of the sources of data. Filters that can be used to determine if a line row in a the source data set (File or API body) should be processed through mediation or ignored. As an example, a given source of data may contain a field called Record Type (First Ordinal position on the line) that indicated a “Record Type”. A filter can be setup such that Only lines with a Record Type value of “6” are to be processed. All other lines are ignored.
Conditional Mapping
Many data Data Sources have variable mappings of source data elements to a Usage record. The mediation process can be set up to account for this. For example, if the line is identified as an "SMSAPI-MOGET" record the system may use field 5 for the Usage identifier Identifier where as if it is SMS-MT it a line identified as API-POST may use field 6. It is also possible to have different source fields mappings based on Conditional statements.
For example, a Carrier might send usage feed may provide twenty fields. When field 5 has a value of "SMSAPI" the mediation process would use fields 1-6, 10,14,19 ignore the rest and when it has a value of "DATACPU" it would use 1-6, 9, 11, 13-16. Determination of a usage class is usually a function based on conditions specific to data in the source or the source itself. LogiSense provides options for managing this thereby allowing reuse of rules and consistency in setting Usage Class values.
...
One or more "normalization" functions can be created to format things like phone numbers, IP addresses into common inputs. The following types of normalization can be performed on the feed:
Normalization Function Type | Definition |
|---|---|
Phone Number | Normalize the Phone Number |
Country | Normalize Country and Country Code |
Carrier | Normalize Wireless Carrier Source |
Network | Normalize the network |
Date/Time | Normalize the date and or time |
Usage Identifiers | Normalize usage identifiers |
Units of Time | Normalize units of measure (time, data etc.) |
Mathematical functions like Sum or Multiplication can also be performed on feeds in order to prepare them for rating. For example, a source that sends data usage in Upload and Download will have to have a sum process applied as well as possible normalization on the whole or parts to a standard unit (ie.eg. KB).
The mediation process may generate exceptions if the incoming feed that does not match the mediation rules that were set up for processing the feed. Mediation exceptions are logged in the system and can be accessed through the operations panel and via reportsviewed on the Setup / Mediation / Import History screen.