Jet Analytics Cubes for Dynamics 365 Business Central (NAV)
Jet Analytics cubes for Dynamics 365 Business Central are twelve prebuilt OLAP cubes, covering Finance, Sales, etc. that sit on a SQL Server Analysis Services data warehouse and give finance and operations teams sub-second slice-and-dice reporting across years of Business Central transaction data, accessible directly in Excel pivot tables, Power BI and Jet Reports without OData exports or IT involvement.
Jet Analytics Cubes v6.0 white paper
Every cube, dimension, measure group and hierarchy documented for your finance and BI team.
What our Business Central cubes deliver
Each cube is a fully modelled OLAP structure not a starter template.Slice by company, dimension,
posting group, period or customer the moment deployment finishes.
Bank Account
Balances, movements and cash
position by account
Fixed Asset
Acquisition, depreciation and
book value trends
Finance
P&L, balance sheet and G/L
analysis by dimension
Inventory
Stock value, movement, ageing
and turnover
Jobs & Resources
Job profitability, WIP and
resource utilisation
Manufacturing
Output, consumption, capacity
and variance
Payables
Vendor ageing, open balances and payments
Purchase
Spend by vendor, item and
period with trend analysis
Receivables
Customer ageing, DSO and collection performance
Sales
Revenue, quantity and growth by any dimension
Service Management
Service orders, contracts and response performance
Warehouse
Bin, location and movement analysis across sites
The definitive cube layer for Dynamics 365 Business Central reporting
Nobody in this region has deployed more Jet Analytics cubes for Dynamics 365 Business Central than we have. As the authorized Insightsoftware distributor for the Middle East and Africa and a Microsoft Partner, Global Data 365 has built the reference cube set that finance and operations teams run on — and we hand it to every client who buys Jet Analytics through us, at no extra cost.
Most Business Central customers who buy an analytics platform then spend months modelling it. That is wasted budget. Our prebuilt SSAS cubes for Business Central and NAV arrive with dimensions, hierarchies, calculated measures and time intelligence already defined against standard BC and NAV tables, so your first board ready number lands in the first week of the project, not the first quarter. This is why our Jet Analytics implementations close faster and cost less than the alternatives on the market.
Cube coverage at a glance
Twelve cubes, one governed model. Every one ships with dimensions,
measures and hierarchies already built against standard Business
Central and NAV tables, so your team analyses by company, dimension,
posting group, item, customer or period from the first refresh — without
a single line of modelling work.
What is included with every implementation ?
- All 12 cubes deployed on your Jet Analytics data warehouse
- Multi-company and multi-currency consolidation configured
- Scheduled cube processing aligned to your close calendar
- Excel, Jet Reports and Power BI connections tested end to end
- Handover session with your finance and BI owners
Why buyers choose Global Data 365
- Licensing, implementation & support from one accountable partner
- Consultants who deliver Jet Analytics training as well as projects
- Cube extensions for your custom BC tables and ISV add-ons
- Support desk covering MEA, UK and US business hours
Built for BC online, BC on-premises and every NAV version still in service
Our cubes run against Business Central SaaS, Business Central on-premises and Dynamics NAV from 2013 onward, on SQL Server Analysis Services in
tabular or multidimensional mode. Processing is incremental,so nightly refresh windows stay short even on databases with a decade of posted entries.
Teams connect through Excel pivot tables, Power BI over OLAP or Jet Reports — the same governed numbers everywhere.
If you are scoping a Business Central reporting solution, start here: book a demo and we will show these cubes running on live data, then quote your
licences and deployment in the same conversation. Anyone can sell you Jet Analytics. We are the team that makes it produce answers on day one.
See the cubes running on live Business Central data
Book a 30-minute session with our Jet Analytics team. We will walk through the cube model,
answer your licensing questions and quote your deployment.
Jet Analytics Cubes Buyer Questions
Jet Analytics cubes for Dynamics 365 Business Central are twelve prebuilt OLAP cubes covering Finance, Sales, Receivables, Payables, Inventory, Purchasing, Fixed Assets, Bank Account, Manufacturing, Jobs and Resources, Service Management, and Warehouse that sit on a SQL Server Analysis Services data warehouse and deliver sub-second financial and operational reporting across years of Business Central transaction data. Each cube comes prebuilt with the dimensions, hierarchies, calculated measures, and time intelligence specific to its module, mapped directly to standard Business Central and NAV tables. Finance and operations teams access the cubes through Excel pivot tables, Power BI or Jet Reports, with no OData exports, no manual data preparation, and no IT involvement required for day-to-day reporting.
The twelve prebuilt cubes are included at no additional charge with every Jet Analytics implementation delivered by Global Data 365 there is no separate cube licence fee. The overall cost covers the product licence, data warehouse configuration, cube deployment, connections to Excel, Power BI, and Jet Reports, and a handover session. The pricing is quoted based on BC version, user count and modules in scope. This is different from some partners who scope cube deployment as a separate billable engagement.
A direct Power BI-to-BC connection uses OData live queries. At scale, these degrade to 8–15 second load times and frequently produce wrong aggregations under complex filters because OData tables are transactional, not analytical. The Jet Analytics cube layer sits on SSAS, pre-aggregates data, and serves queries sub-second from memory with a star schema that gives correct totals under every filter combination. Power BI then connects to the cube as its source rather than to Business Central directly.
One to two weeks. Single-company environments activating the core five cubes (Finance, Sales, Receivables, Payables, Inventory) see first board-ready figures in week one. Full deployment with all cubes tested, Excel and Power BI connections confirmed, incremental processing scheduled is within the standard project timeline. Multi-company or custom dimension scope sits at the upper end taking a little more time in project timeline.
Yes, it is a standard configuration. Jet Data Manager connects to multiple BC companies simultaneously and the cube layer presents consolidated and entity-level views in the same report via a company dimension. Multi-currency translation is handled within the data warehouse layer reporting currency, local currency, and transaction currency selectable at query time. No manual extraction from individual company exports required.
Yes. Extensions are built in Jet Data Manager without modifying the standard cube structure. Custom fields, third-party WMS tables, manufacturing ISV data all can be included as dimensions or measures in the relevant cube, available in Excel and Power BI alongside standard BC figures. No changes to the Business Central application itself are required.
