BI & Analytic Logic


Show Detail, Summary and Statistical Output

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