Sales data (by Product) is available from the source system. However the analytical reporting is done Brand wise. The association of Product and Brand changes every year. The reports should show the association as on the transaction date. Which is the best way to model the Product-Brand combination?
Please let me know the logic