What is the best approach to model a star schema in metabase?
I'm coming from a background in Oracle OBIEE where you can utilize multiple fact tables with shared dimensions.
For example revenue table which points to customer dimension and date.
And a second billing table which points to customer and date.
Then, I want to create a report (YTD Revenue and Billings by customer) where each fact table is passed their corresponding filters individually.'
With OBIEE multiple queries are run for each fact table and then combined into a result. Is something similar possible with Metabase?