Forum Discussion
One to Many relationship filtering issue
Hi
Can somesome please help me with filtering with Many to one relationship. Here is my data model.
HP table is in Many to one relation with Inflow/outflow. I need a break down of "TOTAL_ONB" (measurement in Inflow/outflow table) by "PRICING PILLLARS" column in HP table.
Here is the relationship between 2 tables
The filtering works when I do by "PROVINCE" column in HP table, but It does not work when I need to do by "PRICING PILLARS"
This is the correct breakdown
As mentioned above when doing by province, I get the right breakdown.
Any help and guidance will be appreciated. Thank you
You may need to rethink your model. At the moment there is 1 Total ONB value related to many provinces, and I assume pricing pillars. There is no way to tell what portion of the ONB should be attributed to each pricing pillar. Ideally you would have a one-to-many relationship in the other direction so that total ONB is at a lower granularity and you know which part of it belongs to what.
3 Replies
Change both relationships to single direction. Both other tables should filter HP, but HP should not filter the other tables.
Thanks, tried changing the relationship to one direction. But it does not work. It messess the breakdown by province as well.
You may need to rethink your model. At the moment there is 1 Total ONB value related to many provinces, and I assume pricing pillars. There is no way to tell what portion of the ONB should be attributed to each pricing pillar. Ideally you would have a one-to-many relationship in the other direction so that total ONB is at a lower granularity and you know which part of it belongs to what.
