How can I go from 2 dimensions to 3 with a many to many relation?

versilva

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

alexpavel

@versilva It you want to get the boolean from [Store - School] module and bring it into the module [Store - SKU] , you can do it by using lookup by School from the system SKU module which, if I understood correctly is in hierarchy with Subject and School (in the SKU module you can define a line-item School as parent(paren(SKU)).

However, in Store - SKU module you will have TRUE for all the SKUs of that school. This means that all SKUs of a particular School are sold in a Store. Not sure if this is what you want.