Virtual OLAP connects directly to your ERP database, reads your data through a supercharged query engine, and delivers it into an in-memory OLAP engine — giving accountants and analysts unlimited self-service reporting, without touching IT.
How It Works
No database copies. No transformation pipelines. No delays. Just live data — structured, analysed, and ready to act on in seconds.
Connects straight to your ERP database — on-premises or via secure API for cloud ERPs. No middleware, no staging tables.
Our structured query engine reads only the data needed for your template — perfectly shaped, sent directly or via API.
Data arrives in Excel with multiple structured tabs, or on the Virtual OLAP server — cloud-hosted or on-premises. Your choice.
The in-memory OLAP engine fires up. Unlimited dimensions. End users filter, pivot and drill — without SQL or IT.
The Virtual OLAP Difference
Once your data lands in the in-memory engine, accountants and analysts become self-sufficient. No IT. No ETL re-run. No waiting.
Slice GL, AP, AR, Sales, Purchasing, Manufacturing or Projects data across any dimension — cost centre, period, region, product, customer — with zero re-programming.
Non-technical users pick a template, apply filters, and build structured drillable reports in minutes — without raising an IT ticket.
Everything runs in RAM. Sub-second responses on datasets that would crash a spreadsheet. No disk I/O, no round-trips to the ERP.
Ready-built templates for GL, AP, AR, Sales, Purchasing, Manufacturing and Projects — use out of the box or customise for your business.
Active Dimensions
Live data · YTD · Click any row to drill to transaction ↗
The Honest Comparison
Platforms like Microsoft Analysis Services are capable — but they impose trade-offs that hurt FP&A teams when they need ad-hoc answers fast.
| Capability | Traditional OLAP (e.g. SSAS) | FastClose Virtual OLAP |
|---|---|---|
| Data freshness | ERP data must be copied — never truly real-time | Reads live from your ERP at query time |
| Dimensions | Fixed schema — new dimension requires ETL re-work | Unlimited, user-selectable at runtime |
| Ad-hoc reports | May be impossible if data wasn't loaded that way | Any combination, any time, no IT involved |
| Who builds reports | BI developers and DBAs required for every change | Accountants and analysts — full self-service |
| Deployment | Separate infrastructure, licences, ongoing maintenance | Cloud SaaS or on-premises — your choice |
| Excel integration | Complex MDX queries or specialist add-ins required | Native Excel with multiple structured tabs |
Templates & Modules
Targeted templates covering the full financial and operational spectrum — ready out of the box, fully customisable.
Drill from trial balance to journal entry. Slice by cost centre, account, period or entity — all live.
Aged creditors, payment runs and accruals — cross-cut by supplier, invoice date and currency.
Live aged debtors, cash flow forecasting and collection performance — drillable to invoice level.
Revenue by product, customer, region or channel. Spot trends and exceptions the moment they happen.
Purchase orders, GRNs and supplier performance — slice by commodity, supplier or project with a click.
Job costing, WIP, material usage and labour efficiency — analysed across unlimited dimensions.
Budget vs actual, resource utilisation and project profitability — live from your ERP, fully drillable.
No template fits? Build your own from scratch — no IT ticket, no ETL pipeline, no delay.
ERP Integrations
Direct connectors for leading ERP platforms — on-premises or cloud. No data migration required.
Book a 30-minute demo. We'll connect to your ERP, pull live data, and show you what unlimited-dimension OLAP looks like — in your own numbers.
Request a Demo Contact Us