Hi Luc,<div>Thanks for the quick response! Could you point me at the specific section that talks about this? I did look at the documentation on schemas and also the sample FoodMart schema, but it wasn't clear to me how to handle this specific case that I described. Also it didn't look like the FoodMart schema had an equivalent example. :(</div>
<div><br></div><div>Thanks,</div><div>-Macros</div><div><br></div><div><br><div class="gmail_quote">On Sat, Jul 16, 2011 at 7:01 AM, Luc Boudreau <span dir="ltr"><<a href="mailto:lucboudreau@gmail.com">lucboudreau@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><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" target="_blank">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" target="_blank">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"><div><div></div><div class="h5">On Fri, Jul 15, 2011 at 8:37 PM, Macros Black <span dir="ltr"><<a href="mailto:scarletred10@gmail.com" target="_blank">scarletred10@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div class="h5">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></div></div>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">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>
</blockquote></div><br></div>