Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Best practice advice data model

Hi all, I'm looking for some advice on how to design my data model. The performance of the report is too slow and I have been looking into the tabular editor best practice rules. I have quite some...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    I think the one-to-many bidirectional relationship will be better than a many-to-many relationship between table B and D (on ID). Sometimes we cannot avoid bidirectional relationships completely. As the current bidirectional relationship is one-to-many, its filtering result is still accurate. 

     

    Best Regards,

    Jing

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jing,

 

Thanks a lot for your response. I will have a look at the links you provided.

So you do not think the bidirectional relationship between B and C is a problem? Or do you know a way to get rid of it? Indeed this is only a small part of the model but I have about 8 or 9 of these similar setups with other tables & slicers.

 

Thank you!

Martine

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

I think the one-to-many bidirectional relationship will be better than a many-to-many relationship between table B and D (on ID). Sometimes we cannot avoid bidirectional relationships completely. As the current bidirectional relationship is one-to-many, its filtering result is still accurate. 

 

Best Regards,

Jing