Filter with multiple level dimensions in Snowflake Schema

Hello,

I am new to data modelling - and I think I am making a mistake here and looking for help.

I have a Fact table - Transactions. This table has ID columns for the Buyer and the Supplier, each have their own dimension tables containing much more information.

Then there is an Account Owner table, which relates to both the Buyer and Supplier Tables. As below:

We look after both sides of the marketplace, so I need multiple reports:

• A filter by Account Owner which shows all of their accounts, both Buyers and Suppliers
• A filter by Buyer to see which Suppliers they are purchasing from and how much
• A filter by Supplier to see which Buyers they are selling to and how much.

Is this possible?

thanks for your help,