Reporting that depended on cubes nobody could fully explain
The group's reporting ran on JET Reports and seven Jet Enterprise cubes built over years. Executive dashboards took a long time to produce, and the sales team had no direct access to data, so they waited for Excel extracts prepared by others. The logic behind each number sat inside 798 pages of generated documentation, and the business had just consolidated its Business Central companies into one. Moving to Microsoft Fabric meant first knowing exactly what every cube did.
Decode the old cubes, then rebuild them on Fabric
We started with a fixed-price discovery that reverse-engineered the documentation behind the legacy cubes and traced every measure back to Business Central. That specification then drove the build: a Bronze, Silver and Gold lakehouse on Microsoft Fabric and one Direct Lake semantic model, delivered one cube at a time.
798 pages turned into a specification
We worked through the full documentation set behind the Jet Enterprise cubes and wrote down the seven cubes, 37 dimensions and 12 fact tables, with the source of every field.
Every measure carried across
Of the 142 measures, 101 were rebuilt directly, 37 derived from other measures and 4 rebuilt in part. None was lost: one field with no source in Business Central is covered by a simple mapping table.
Wine-specific logic kept
Volumes in litres and 9-litre cases, the ageing of receivables and payables, and daily currency rates all came across to Fabric, so the numbers people already trusted stayed the same.
One model instead of seven cubes
The seven cubes are now a single Direct Lake semantic model on a Bronze, Silver and Gold lakehouse, with the old MDX calculations translated into DAX.
Built on real data from day one
The specification was written against 99 tables actually extracted from Business Central during the discovery, so the build started from the real schema, not assumptions.
Delivered cube by cube
The build went one cube at a time, starting with Sales so the sales team got direct access to its data first, and finishing with Finance once the foundations were proven.
Where the data lives and how it flows
The group's ERP: finance, sales, inventory, purchasing, receivables and payables, including the history of the merged companies
What changed
The group's reporting now runs on one Microsoft Fabric model instead of seven Jet Enterprise cubes, with every legacy measure carried across, so the figures people already relied on still add up the same way.
Because the build followed a checked specification and went one cube at a time, each cube could be compared against the old numbers before the next one started, beginning with Sales and finishing with Finance.