We are implementing the federation at my current company. we do have a couple of entities, Brand, Category, and Product. In some cases, we need to do some data aggregation between two of these entities. we could also have aggregation between Product and Category.
We trying to figure out the best way to that. is it by adding a new entity BrandProductAggeragtion, CategoryProdcutAggregation? or by just playing with a query? if it is a latter, how that could be achieved