<br>Macros,<br><br>You will find all your answers, and much more, in our online documentation about Mondrian schemas. It is available at:<br><br><a href="http://mondrian.pentaho.com/documentation/schema.php">http://mondrian.pentaho.com/documentation/schema.php</a><br>
<br>You can also use our test schema, FoodMart, as a reference. It is available here:<br><br><a href="http://perforce.eigenbase.org:8080/@md=d&cd=//open/mondrian/demo/&cdf=//open/mondrian/demo/FoodMart.xml&rc=s&sr=14118&c=2iQ@//open/mondrian/demo/FoodMart.xml">http://perforce.eigenbase.org:8080/@md=d&cd=//open/mondrian/demo/&cdf=//open/mondrian/demo/FoodMart.xml&rc=s&sr=14118&c=2iQ@//open/mondrian/demo/FoodMart.xml</a><br>
<br>Good luck!<br><br>Luc<br><br><br><br><br><div class="gmail_quote">On Fri, Jul 15, 2011 at 8:37 PM, Macros Black <span dir="ltr"><<a href="mailto:scarletred10@gmail.com">scarletred10@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">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><font color="#888888"><div><br></div>
</font><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>