[Mondrian] schema question
scarletred10 at gmail.com
Mon Jul 18 13:41:01 EDT 2011
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:
> You will find all your answers, and much more, in our online documentation
> about Mondrian schemas. It is available at:
> You can also use our test schema, FoodMart, as a reference. It is available
> Good luck!
> 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:
>> <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
>> Help would be appreciated!
>> Mondrian mailing list
>> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian