Forum Discussion
data modelling
I have a fact table where each row contains different data at a local authority level. There are therefore many rows regarding the same local authority. I then have a dim/lookup table where I list ...
BOBALENIS , Based on what I got. I think multiple join with authority table to fact. with one relation inactive and activate that using userelationship
Morning and wow- thank you so much for replying so swiftly.
I am not sure I fully understand your idea but do you mean something like this? Thanks again
