I'm curious, do you translate the multiple dimensions to a fully normalized relational structure, or do you also use complex structures like JSON inside the backend database?
The masterdata is stored as JSON to avoid creating/dropping columns and tables as list/columns are added and removed. But an option to have a fully normalized relational structure in an on-premise installation is on my feature list. It could be useful for enterprise clients who could use the data directly for reports and other applications.