How can I go from 2 dimensions to 3 with a many to many relation?
I have a model for a company that sells books, with the following relationships:
[Store - School] - many to many
The books from one school can be sold ate many stores, and each store sells books from many schools
(used a boolean model with dimensions store and school)
[School - Subject- SKU] - many to one
For each subject each school adots one only SKU, each SKU can be adopt for more than one school)
I need to relate them in a 3rd model , in order to have in each store only the SKU's it sells
[Store - SKU]
However, since the [Store - School] relation is many to many I can not use a lookup as usual, can you help me solving this?
Thank you so much