depends on what you mean by a star... If you have both fact detail level (eg. individual daily sales) and aggregated data (say monthly summaries) in the SAME base table, then you'll need to create table views for it to work in mstr. It's ok to have the lookups in the same table but not the data itself. Any other schema is fine.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.