[Mondrian] schema question

Venkatesh U venkatesh20 at gmail.com
Sun Jul 24 01:45:08 EDT 2011

You have got various options
1. Design the product dimension as a snowflake dimension, using join table
syntax in the schema XML(You may use schema workbench to easily edit the
schema xml files)
2. Create a view joining Product dimension and Product categories and use it
as a single dimension with 2 levels Category and Product
3. Join the tale product_categories with the Fact and create a view, use
this view as your fact table.

I would go with the second option due to its simplicity
Hope this helps.


On Sat, Jul 16, 2011 at 6:07 AM, 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/20110724/1cd45481/attachment.html 

More information about the Mondrian mailing list