Mappings

Every data point across projects

The dimensions, objects, and derivations the organization consolidates from every connection, how source values reconcile into them, and where each one comes from.

Master Consolidated View

Where each data point comes from and how they relate: connections feed dimensions and objects, derivations build on them, and automations use the result. Select a node to lay out its tree.

10 source systems7 dimensions10 business objects8 derivations6 automations

Approved / healthyDraft / needs attentionSuggested / runningAction needed

Inputs sit above the node, uses below. Hover any node to see its path to the selected one.

Source systems

2 inputs

Sage 300 CRE

connected

RailcarRX

connected

Dimensions

selected

Service Types

SERVICE_TYPES

Business objects

6 uses

Volume

VOLUME

Gross Revenue

GROSS_REVENUE

Labor Hours

LABOR_HOURS

Labor Costs

LABOR_COSTS

Car-Cycle Events

CAR_CYCLE_EVENTS

Receivables & Collections

RECEIVABLES

Derivations

7 uses

Net Revenue / Car

NET_REV_PER_CAR

Labor Hours / Car

LABOR_HOURS_PER_CAR

Average Turn Time

AVG_TURN_TIME

Completed, Not Invoiced

COMPLETED_NOT_INVOICED

Labor Cost / Car

LABOR_COST_PER_CAR

Collections Follow-up

COLLECTIONS_QUEUE

Bank Reconciliation Exceptions

BANK_REC_EXCEPTIONS

Automations

4 uses

KPI Dashboard

healthy

Collections Follow Up

paused

Bank and Payment Reconciliations

paused

Source-System Protection

paused

Tree for Service Types

Service Types

DimensionSERVICE_TYPESapproved

What was done to the car. Cleaning, light repair, heavy repair, lining and coating, inspection, storage, mobile repair.

Built from2

Feeds10

Business objects

Derivations

Automations

Canonical members7

CleaningLight repairHeavy repairLining and coatingInspection and testingStorageMobile repair

Details

Owner: Marcus Bell
Rows: 7
Approved: 2026-04-09

Edit data point Mapping treatments2 upstream · 17 downstream