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?
Combining advanced model with data supply is possible, could you provide more details so I can better understand your question.
For the Category section, you can take the key column from the dimension table.