Forum Discussion

Fistachpl's avatar
Fistachpl
Helper III
4 months ago
Solved

Data Model - is my setupo correct?

I have simple data model but I need to know if I plan it correctly. But first, quick explainer.    I have 5 tables:  New pricelist and old pricelist: which are sold.  But products combined...
  • InsightsByV's avatar
    4 months ago

    Hi Fistachpl ,

    To avoid one to one and cross filter direction in both ways - modify to one to many relationships between tables:

    1) dim products and assemblies  ->* New pricelist

    2)  dim products and assemblies ->*  old procelist