[Mondrian] schema question

Macros Black scarletred10 at gmail.com
Mon Jul 18 13:41:01 EDT 2011

Hi Luc,
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. :(


On Sat, Jul 16, 2011 at 7:01 AM, Luc Boudreau <lucboudreau at gmail.com> wrote:

> 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/20110718/b88d1b6a/attachment.html 

More information about the Mondrian mailing list