Forum Discussion
Data Model
Hi. I’m looking for some advice on how to connect two star schemas together. The scenario is as follows:- I have an existing star schema which is holding all my actual costs and revenues Fac...
Hi Greg,
Thanks for the reply.
So there are some common/shared dimensions but not all.
The problem I'm having is say for example:-
1 Job has a total cost of 10k (provided from the factcost table)
I then want to show a breakdown of these costs per sub task level which is in the other fact table.
Really I only want to me able to slice and include dimensions from the cost star schema. For example create a table visual that consists of my costs and my scheduling data combined.
hope that makes sense.
alex
AlexDawson111 OK, so what if you built a relationship between your jobs table and your subtasks table based on job code? Is it Many-to-Many (*:*) if you do that or 1:*?
Super difficult to visualize without sample data.
