[Mondrian] schema question

[Luc Boudreau]

Macros,

You will find all your answers, and much more, in our online documentation
about Mondrian schemas. It is available at:

http://mondrian.pentaho.com/documentation/schema.php

You can also use our test schema, FoodMart, as a reference. It is available
here:

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

Good luck!

Luc




On Fri, Jul 15, 2011 at 8:37 PM, 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/20110716/3db2d9ec/attachment.html