Combine advanced Model with Data supply
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?
MU
Varoothini Answered question
Hi,
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.
Varoothini Answered question