[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