Comparing Budget vs Actual result

[Anonymous]

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?

[agigliotti · Accepted solution]

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

[Anonymous]

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.

[Anonymous]

Thank you!

[oknotsen]

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 .