[Mondrian] schema question

Luc Boudreau lucboudreau at gmail.com
Sat Jul 16 10:02:56 EDT 2011


You will find all your answers, and much more, in our online documentation
about Mondrian schemas. It is available at:


You can also use our test schema, FoodMart, as a reference. It is available


Good luck!


On Fri, Jul 15, 2011 at 8:37 PM, Macros Black <scarletred10 at gmail.com>wrote:

> Hi guys,
> I am new to Mondrian, and first let me say, really sweet concept,
> leveraging this whole hypercube model for analytics. Also, nice, apt name.
> :) So I have a question that I hope someone can help me with. I have a fact
> table of product sales which I'm extracting dimensions from. These products
> belong to categories, which is represented in a separate table
> product_categories which has two columns, product_id and category_id.
> I would like to have 'categories' as a dimension in the cube as well, but
> I'm not sure how to achieve this since it's not in the fact table (only
> product_id is in the fact table, along with the sales, prices, dates etc.).
> Also since it is a "dependent" dimension in the sense that a product id
> uniquely determines the values of the "category" axis, it doesn't seem right
> to modify the fact table to include category_id. I think I am looking for
> something like this:
> <dimension>
> <table = ?>
> use key product_id in sales_fact_table and maybe do some kind of join or
> use the corresponding category_id's in the product_categories table
> </table>
> </dimension>
> Help would be appreciated!
> Thanks,
> -m
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110716/3db2d9ec/attachment.html 

More information about the Mondrian mailing list