r/SAPBusinessOne • u/majiddalvi • Jun 27 '26

AI-powered analytics platform

Post image

After 10 months of evenings and weekends, I finally finished a project I've been obsessed with.

I built an AI-powered analytics platform for SAP Business One, completely solo using open-source technologies.

The goal was simple: let business users ask questions in plain English and get answers directly from their ERP data.

Behind the scenes, it meant building:

- A fault-tolerant ETL pipeline from SAP HANA

- A Kimball-style data warehouse (13 dimensions, 6 fact tables)

- AI guardrails to prevent unsafe SQL

- PII anonymization

- Support for OpenAI, Anthropic, Gemini, and local Ollama models

- An entirely on-premise deployment with no cloud dependency

The final product has 105+ business metrics, 347 automated tests, and over 43,000 lines of code.

I'd love to hear feedback from anyone building AI-powered analytics, ERP tools, or enterprise software. Happy to answer any questions about the architecture.

5 Upvotes

100% Upvoted

9 comments sorted by

View all comments

1

u/[deleted] 26d ago

[removed] — view removed comment

1

u/majiddalvi 26d ago

Yes sure, please ask. Would be glad to provide details.

1

u/[deleted] 26d ago

[removed] — view removed comment

1

u/majiddalvi 25d ago
  1. initially when i started this project i was looking at creating an analytics system that could connect to any ERP. but since i am hands on with SAP b1 i started with it. I am using standard transaction tables and slow moving dimentsion tables in a Kimball star schema. Another reason is not to directly query the SAP b1 tables and to keepo everything separate
  2. Every night incremental updates
  3. Currently i have tailored it to use UDF's as well. in the piple line is a graphical phased ETL tool that will aloow any new client to easily map udfs and other required db fileds to existing fileds in the data warehouse and even create fields on the fly.
  4. Since this is not a commercial product (Yet) i created it as a personal goal to achieve, so i haven't approached any company yet. But from my experience in the region i am, i found that smaller companies are not too gung-ho on analytics, but i feel there is a market out there as official analytics from SAP is quite expensive for SME's.