Can I combine an advanced model (e.g. levels 1-6 are created manually) with a “data supply”, e.g. level 7 comes from the chart of accounts and level 8 are the detailed accounts. I have created a “snowflake scheme” and it works up to level 7, level 8 then no longer works.
Do I have to take from the dimension table into the category or from the fact table?