Forum Discussion
Solved
dimensions
Hi, I am a develolper which is involved in an application of creating fact and dimension tables to be send to PBI. Mi question is if is correct, allowed, than a foreign key in a fact table can appo...
Tecnically, yes, you can do it. But the question is: Does it makes sense?
If CaseID is a surrogate key for the case dimension, maybe you case dimension is more or lass the union of your Dim1, Dim2 and Dim3.
BUT...
if this Dims 1, 2 and 3 are really different and you, for any reason, are just using a shared ID for them, So maybe you have more than 1 fact table.
Once you are trying to use an star schema, take a look on -> http://www.kimballgroup.com (because they defined it)
aaand, you should be able to get results from a DW in a simple way (I mean....99% of the cases should be just a sum and a filter)
Yes, you can have multiple dimensions all point to the same foreign key in a fact table.