Hi guys,<div>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.</div>
<div><br></div><div>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:</div>
<div><br></div><div><dimension></div><div><table = ?></div><div>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</div>
<div></table></div><div></dimension></div><div><br></div><div>Help would be appreciated!</div>
<div><br></div><div>Thanks,</div><div>-m</div><div><br></div>