Forum Discussion

fernandoC's avatar
fernandoC
Icon for Helper V rankHelper V
5 years ago

Errors when filtering by Month

Hi,   I'm trying to create a visualization that includes 3 different fields: "Location" on the Legend, Sum of Training Hours Delivered and a Month column for the Axis. For some reason, I started re...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

I can't give you the detailed reason because I can't see the data or measures but the data model is not a star schema, there are bi-directional relationships and there is a many-to-many relationship, so that's why it's broken.  It looks relational rather than dimensional.

 

Rework the model so that the dimension tables filter the fact table and sort out the bidirectional relationships.

 

Good luck