Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Running into a modelling issue * Need your help

Hello guys,   I am running into a data model issue, where it seems that I can't find any plausible solution for this.   Context: Company Segment: Debt Collection Company   Data Model: 3 fact ...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

It is ok to have multiple fact tables in your data model. It is not ok to join them directly.  Instead, they should all be controlled by common dimension tables (like your campaign dimension).

 

Can't help much without seeing a sample version of your data  model.