[Mondrian] AggGen question...

Ati Rosselet ati.rosselet at gmail.com
Wed Oct 24 22:57:32 EDT 2007


using FoodMart, the following table (partial) is created:

Table:
    alias=sales_fact_1997
    relation=sales_fact_1997
    Columns:
      Unit Sales (0): sum(\"sales_fact_1997\".\"unit_sales\")
      Store Cost (1): sum(\"sales_fact_1997\".\"store_cost\")
      Store Sales (2): sum(\"sales_fact_1997\".\"store_sales\")
      Sales Count (3): count(\"sales_fact_1997\".\"product_id\")
      Customer Count (4): count(distinct
\"sales_fact_1997\".\"customer_id\")
      Unit Sales (33): sum(\"sales_fact_1997\".\"unit_sales\")
      Store Cost (34): sum(\"sales_fact_1997\".\"store_cost\")
      Store Sales (35): sum(\"sales_fact_1997\".\"store_sales\")
      Sales Count (36): count(\"sales_fact_1997\".\"product_id\")
      Customer Count (37): count(distinct
\"sales_fact_1997\".\"customer_id\")
      Sales Count (42): count(\"sales_fact_1997\".\"product_id\")
      Unit Sales (43): sum(\"sales_fact_1997\".\"unit_sales\")
      Store Sales (44): sum(\"sales_fact_1997\".\"store_sales\")
      Store Cost (45): sum(\"sales_fact_1997\".\"store_cost\")
      Customer Count (46): count(distinct
\"sales_fact_1997\".\"customer_id\")

and consequently the following aggtable sql:
CREATE TABLE agg_c_XXX_sales_fact_1997 (
    the_year INT2,
    unit_sales NUMERIC(10,4) NOT NULL,
    store_cost NUMERIC(10,4) NOT NULL,
    store_sales NUMERIC(10,4) NOT NULL,
    SALES_COUNT INT4 NOT NULL,
    CUSTOMER_COUNT INT4 NOT NULL,
    unit_sales NUMERIC(10,4) NOT NULL,
    store_cost NUMERIC(10,4) NOT NULL,
    store_sales NUMERIC(10,4) NOT NULL,
    SALES_COUNT INT4 NOT NULL,
    CUSTOMER_COUNT INT4 NOT NULL,
    SALES_COUNT INT4 NOT NULL,
    unit_sales NUMERIC(10,4) NOT NULL,
    store_sales NUMERIC(10,4) NOT NULL,
    store_cost NUMERIC(10,4) NOT NULL,
    CUSTOMER_COUNT INT4 NOT NULL,
    fact_count INTEGER NOT NULL
);

from what I can tell, the repetition is due to having multiple cubes on the
same fact table.
I thought that maybe changing the RolapStar.Table.containsColumn()
would help, but no, since the measure = measure returns false for different
cubes, but still
all these measures get assigned to the same table. ...  problem is that
AggGen can't tell them apart.. a
Is the repetition of fields a bug?  or just that AggGen can't handle it? any
ideas?

mind you.. this may not be important at all.. just when using AggGen   it
gets irritating...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20071025/72699ea8/attachment.html 


More information about the Mondrian mailing list