Skip to content

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

Tessera RP at work: asked “Which channels actually make money?”, the assistant plans a QuerySpec — the contribution margin metric by channel over the last 90 days, with the member’s data scope appended — and answers with the certified metric it used, the data-as-of time and its confidence, without writing SQL. Connections to Dynamics 365, Business Central, NetSuite, Shopify and Amazon sync incrementally by watermark, skipping unchanged records. Signals ranks findings such as a coming stockout and discount leakage by money at risk, with the workings behind each. And the admin audit log records every action, including denied access, while a member’s row-level scope is appended to their queries.

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.

Dynamics 365read-onlyorders · cost · stockShopifyread-onlyorders · fees · returnsnothing written backGoverned metrics229one owner and onedefinition eachmargin, per order lineRevenueProductFreightFeesReturnsMarginon the order linewhat a product-cost margin leaves out, in rustWhich SKUs lose moneyonce returns are in?asked in EnglishAnswerwith its workingA ranked list of SKUsmetriccontribution marginwindowlast 90 daysSharedviewersSupply chainNorthFinanceallBuyingShopifyunlimited, each scoped

← 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.

Questions

Asked first.

No. Viewers are unlimited on every paid plan, and every one of them gets their own persona dashboard. Pricing runs on monthly orders and sync cadence instead.

Tessera RP is live

See it on a seeded demo workspace, no password.