Chat
Request Info
Download
Overview Report Functions Format Options CDC (Deltas) CDI & Segmentation Clickstream Analytics SCD

Following are some of the basic reporting capabilities of all IRI software products using SortCL metadata. The reports can be formatted in custom layouts and are just optional targets in the same job script and I/O pass as the core engine functions (transformation, masking, migration, generation).

Capability Functions Uses
Condition Logic
Record filtering and field evaluation
Input data reduction via selection and de-duplication, and output segmentation
Field Remapping
Re-size, re-cast, and re-position fields
Integrate data sources into unified report formats
File Reformatting
Create, collate, and convert 20+ formats
Acquire, migrate, and handle data from other platforms
Type Conversion
Translate between > 120 data types
Example: convert numeric values to currency
Segmentation
Sort, join, and select to capture and group
Customer data integration (CDI) and segmentation
Summarization
Inter-record count, total, average, min, max, and multiply
Drill-down, roll-up, and windowed aggregates for billing, ranking, etc.
Cross-Calculation
Intra-record expressions (math, trig, derived functions)
Billing, business intelligence, analytics, and fraud detection
Expressions
Perl-compatible (PCRE)
Pattern matching, find and replace, etc.
Sub-strings
In-string (INSTR), format masking, length functions, etc.
Granular formatting and re-casting options
Lookups
Substitute and fuzzy logic values
Discrete value display and trend reporting / predictive analytics

Request More Information

* indicates a required field.
IRI does NOT share your information.