Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like your help with this, I am trying to create a dashboard comparing budget with sales for specific users.
I do not know how to create the data model to do this correctly without creating cirkular references. Below is a picture of that part of the data model, what I would like to do is to associate the date fields in Budget and Sale.
Since I need to associate the tables on aassociate_id, I can't associate the date fields, because that causes a cirkular reference.
Does anyone know how to solve this?
you can create a unique FACT table concatenating both tables (Budget and SALE).
like below:
FACT:
load *, 'SALE' as source From SALE
CONCATENATE
load *, 'BUDGET' as source From Budget
you can create a unique FACT table concatenating both tables (Budget and SALE).
like below:
FACT:
load *, 'SALE' as source From SALE
CONCATENATE
load *, 'BUDGET' as source From Budget
Maria
Concatenating seperate Fact tables into a single fact table as Andrea suggests is a powerful and good thing. Well worth giving it a go and adding it to your repertoire of good things you know about.
Thank you!
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .