CODEWITHSUNDEEP
jrubypentahodata-warehouseolapmondrian
jphorta
jphorta

Reputation: 2174

Many-to-many dimensions in a datawarehouse using Mondrian schema

I'm using mondrian-olap JRuby gem to query a datawarehouse using Mondrian library. I'm trying to build the OLAP schema but i'm having trouble setting a dimension composed by a many-to-many relationship.

I have a product with many categories, and so I created a table Product, a table ProductCategory and a table Category. The number of products is always increasing and so, using a single ProductCategory table seems a bit risky to me.

The Mondrian documentation was inconclusive for me, and all existing schema examples with a snowflake schema use only a single relationship table (like ProductCategory) and not a many-to-many combination of ones.

Is it possible to represent a many-to-many relationship using a Mondrian schema? Is there a better way to set this relationship?

Upvotes: 2

Views: 1312

Answers (1)

Luc
Luc

Reputation: 672

Mondrian does not support many-to-many relationships. This is a feature that we have already started looking into, but there are no ETA as of now.

Upvotes: 1

Related Questions