yes, that shouldn't be a problem.
with that many tables, you might want to use Views: https://cube.dev/docs/reference/data-model/view
with that many tables, you might want to use Views: https://cube.dev/docs/reference/data-model/view
In my use case, it's going to be exposed to various kind of stakeholders and there will be versatility of user queries. I can't pre-create views/aggregations for all scenarios.