[Mondrian] schema question

[Macros Black]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110716/d199e77d/attachment.html