Generic filters

SAP and Fabric: seamless controlling

Bissantz brings SAP data into Microsoft Fabric as a ready-to-use controlling model – with continuous history, analysis and planning.

  • continuous time series beyond the S/4HANA go-live

  • prebuilt modules for accounting, sales, logistics and production

  • planning and reporting on the same data model

  • predictable costs for capacity, licenses and operations

Mehr anzeigen

The data source

SAP supplies the data – which first lands in OneLake as raw data with cryptic table and column names. Bissantz knows the SAP base tables and CDS views and turns them into a business‑ready controlling model.

Permitted extraction paths
Approved interfaces such as CDS views and OData, assessed by Bissantz.
Old and new SAP worlds
Bissantz maps one to the other – your time series survives the go‑live.
Prebuilt modules
Accounting, sales, logistics and production as subject modules you can book.
Raw data is not a report
KPIs, hierarchies and plan‑actual variances only emerge in the business model.
Microsoft Fabric
Microsoft Fabric

The platform

Microsoft Fabric provides the platform, Bissantz the ready‑made controlling model on top: KPIs, hierarchies and history are already in place. Analysis, planning and reporting run on one data foundation.

Medallion architecture
Built by Bissantz, all the way to the finished semantic model.
Reports instead of DAX
Year‑to‑date and prior‑year comparison prepared as calculation groups.
Planning in the same model
Analysis and planning in DeltaMaster, reporting in Power BI as well.
Predictable costs
Capacity and licences calculated upfront, operation by Bissantz on request.
“We changed a lot when we moved to S/4HANA, but not our reports. Hardly anyone in controlling even noticed”
Head of ControllingMedia company

Getting the most out of SAP and Fabric

SAP provides the data, Microsoft Fabric the platform. Bissantz adds the KPIs, hierarchies and history controlling needs.

For con­trol­ling with SAP and Fabric, the plat­form is only the start­ing point. In OneLake, SAP raw data arrives with cryptic table and column names—without KPIs, hi­er­ar­chies or plan-actual vari­anc­es. These only emerge in a technical model, and without one there is nothing to build reports on.

Bissantz closes this gap for SAP and Fabric with Bissantz ERP Solutions for SAP. Years of SAP project ex­pe­ri­ence are built into prebuilt modules that know exactly which SAP base tables to access. Con­trol­ling and finance get reliable figures without having to build the model themselves.

Too many paths, no clear plan?

Too many paths, no clear plan?

Operating model, ex­trac­tion method, target ar­chi­tec­ture, ca­pac­i­ty: between SAP and Fabric, many de­ci­sions depend on each other, and not every path is per­mit­ted. Bissantz assesses your start­ing point with weighted rec­om­men­da­tions and defines the next steps.

History lost after go-live?

History lost after go-live?

In a greenfield im­ple­men­ta­tion of S/4HANA, historical trans­ac­tion data is not migrated, so the prior year is missing as a bench­mark. Bissantz maps the old and new SAP worlds to each other and preserves a con­tin­u­ous time series.

Planning overlooked in the migration?

Planning overlooked in the migration?

Many projects re­plac­ing SAP BW focus on re­port­ing alone. Plan­ning drops out of sight until it is missing in the next plan­ning cycle. Bissantz delivers plan­ning and re­port­ing on the same model in Fabric.

Market leaders and hidden champions trust us.

Microsoft fabric for SAP
with a proven technical model

With Microsoft Fabric for SAP, Bissantz delivers accounting, sales, logistics and production as ready-made modules

With Microsoft Fabric for SAP, com­pa­nies book subject modules from Bissantz in which trans­ac­tion data and KPIs are already modeled. Ac­count­ing covers the balance sheet and cost ac­count­ing, Sales covers multi-lev­el con­tri­bu­tion margin ac­count­ing, and Pro­duc­tion covers product costing. The Common Master Data module provides shared master data such as company codes and cur­ren­cies.

In Fabric, Bissantz builds a me­dal­lion ar­chi­tec­ture on this basis, all the way to the se­man­tic model. Hi­er­ar­chies are in place, and cu­mu­la­tive values and prior-year com­par­i­sons are prepared as cal­cu­la­tion groups. Con­trol­ling builds reports instead of writing DAX formulas – in DeltaMaster or Power BI.

SAP integration with OneLake in Microsoft Fabric

Bissantz tailors SAP in­te­gra­tion with OneLake in Microsoft Fabric to your start­ing point. Operating model, data volume and refresh fre­quen­cy determine the ex­trac­tion method; a Bissantz as­sess­ment tool provides weighted rec­om­men­da­tions.

On-premises and private cloud systems connect the modules directly to SAP base tables, the public cloud uses CDS views. Bissantz has already mapped the old and new SAP worlds and identified the relevant ones among numerous, partly over­lap­ping CDS views.

Stable extraction methods

Stable extraction methods

Tried and tested in­ter­fac­es such as CDS views and OData.

History without redesign

History without redesign

Existing tables are filled from CDS views; data ware­house and reports stay unchanged.

Costs and operations clarified upfront

Costs and operations clarified upfront

Capacity and licenses calculated upfront; operations handled by Bissantz upon request.

“Our plan used to live in Excel and our actuals in SAP. Today we plan contribution margins right where we analyze them.”
Head of ControllingChemical and pharmaceutical company

Analysis, planning and reporting on
SAP data in Fabric

With SAP and Fabric, DeltaMaster guides you from variance to root cause—and planning runs on the same model

Bissantz makes Microsoft Fabric for SAP im­me­di­ate­ly usable for con­trol­ling. In DeltaMaster, nav­i­ga­tion leads step by step from a variance to its root cause. An assistant suggests reports based on more than 600 rules, without an LLM. An AI model can be added if needed.

Planning follows the same model: enter and comment on values, allocate them according to seasonality, adopt the rolling forecast, and simulate assumptions with driver-based planning. Reporting and planning thus share a single database and a single cost accounting system.

FAQ: Frequently Asked Questions

Key information at a glance, answered concisely and clearly

Is SAP history preserved in Microsoft Fabric after greenfield?

SAP history is pre­served in Microsoft Fabric when the old and new SAP worlds are mapped—exactly what Bissantz ERP Solutions for SAP do.

What makes up the running costs of SAP and Fabric?

The cost of SAP Fabric is based on capacity, user licenses, and additional products and operations, such as mirroring.

Does a company on S/4HANA still need a data warehouse?

A ded­i­cat­ed data ware­house such as Microsoft Fabric for SAP becomes more im­por­tant with S/4HANA, not ob­so­lete.

Free of charge for you

How companies make faster, better, and more effective decisions with professional BI and AI consulting

Whitepaper Data Intelligence for Enterprises

Nicolas Bissantz

Diagramme im Management

Besser entscheiden mit der richtigen Visualisierung von Daten

Erhältlich überall, wo es Bücher gibt, und im Haufe-Onlineshop.