Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

Show HN: OM Core – multidimensional models without spreadsheet cell formulas

OM Core is a tool for building multidimensional models without relying on traditional spreadsheet cell formulas. It offers a new approach to modeling complex data structures.

Background

- **OM Core** is an open-source tool (on GitHub) for creating multidimensional data models — think financial planning, budgeting, or business forecasting — without writing spreadsheet formulas. - Traditional spreadsheets (Excel, Google Sheets) use a 2D grid of cells with formulas. OM Core uses a **dimensional data model**: you define dimensions (e.g., Time, Scenario, Product) and metrics, then the system calculates everything based on the relationships between those dimensions. - This approach is common in enterprise **OLAP (Online Analytical Processing)** and planning software like Anaplan, Jedox, or TM1 — but those are proprietary and expensive. OM Core aims to offer similar modeling power as a free, open-source alternative. - The "no formulas" pitch means users avoid cell-by-cell formula errors and instead define logic once at the model level, which is more maintainable and auditable for complex business calculations.