Data Model Helper Table

Hi Anonymous ,

According to your description, you are trying to create a many-to-many relationship between the dimservice and dimproduct tables through the Service Category helper table. In order to do this, you will need to create a bridge table that connects the two tables.

The bridge table should contain foreign keys to both the dimservice and dimproduct tables, as well as a foreign key to the Service Category helper table. This will allow you to map each service and product to one or more categories. Once you have created the bridge table, you can create a relationship between the dimproduct table and the Service Category helper table through the bridge table. This will allow you to filter products by category.

If you are still having trouble getting the relationship to work, you may want to check that your foreign keys are set up correctly and that your queries are referencing the correct tables and columns.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.