Star schema's with facts and dimensions is just a modelling technique used for data warehouses.
If your model is implemented in SQL Server, you can still use CTEs and UNION ALL queries.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP