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, inclding CoSort, FieldShield, NextForm, and RowGen -- and the Voracity data management and ETL platform which includes them. 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, cleansing, migration, generation, etc.).
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 |