Live
Enterprise AI Layer
Which orders actually make money?
An AI layer on top of your ERP: ingestion, warehouse, 229 governed metrics and eleven role dashboards in one application, connected in an hour.
Fivetran + Snowflake + dbt + Looker, in one application
What it solves
The problem, and what changes.
Before
With Tessera RP
01
The margin number leaves out freight, fees and returns: 18–30% of net revenue on a direct-to-consumer line.
Seven cost components on every order line, and true contribution margin computed by the database.
02
Four vendors, four bills, and an analytics engineer holding them together.
One application replaces extract-and-load, warehouse, modelling and BI.
03
Spreadsheets that disagree, because each derives margin its own way.
229 metrics, each with one definition and an owner. Every answer names the one it used.
One layer
The margin after freight, fees and returns.
Tessera RP reads the ERP and the storefronts without writing back, puts freight, fees and returns on the order line, and answers questions in English from 229 governed metrics — naming the one it used and the window it ran over.
← Swipe for the whole diagram →
Inside Tessera RP
One catalog under every screen.
Connectors land the ERP in one shape, every order line carries its full cost, and 229 governed metrics sit in a catalog that each dashboard, alert and answer compiles through — so no two surfaces can disagree.
- Connectors: each stream syncs page by page from a watermark cursor saved after every page, skips unchanged records by content hash, and runs in mock mode without credentials.
- Order line: seven cost components — product, inbound freight, duty, outbound freight, payment fee, marketplace fee and return provision — with landed cost and contribution margin computed by the database.
- Metric catalog: 229 governed metrics and 101 dimensions, searchable, each with an owner and marked certified or not.
- QuerySpec compiler: a spec is built, validated against the catalog, has the caller’s row-level scope appended, and only then is SQL emitted with every value bound.
- Personas: eleven role dashboards — the CFO, merchandising, supply chain and more — over one set of definitions.
- Alerts: a threshold, percentage change or anomaly rule on a governed metric, delivered by email or Slack.
Why it's different
The short case for Tessera RP.
01
229
Governed metrics
Across 14 domains, each with an owner.
02
11
Role dashboards
One set of definitions, instead of one dashboard eleven people argue over.
03
1 hr
Credentials to dashboard
Dynamics 365, Business Central, NetSuite, Acumatica, Shopify, Amazon.
04
4,214
Tests
Tenant isolation proven against a live database.