using FoodMart, the following table (partial) is created: <br><br>Table:<br> alias=sales_fact_1997<br> relation=sales_fact_1997<br> Columns:<br> Unit Sales (0): sum(\"sales_fact_1997\".\"unit_sales\")
<br> Store Cost (1): sum(\"sales_fact_1997\".\"store_cost\")<br> Store Sales (2): sum(\"sales_fact_1997\".\"store_sales\")<br> Sales Count (3): count(\"sales_fact_1997\".\"product_id\")
<br> Customer Count (4): count(distinct \"sales_fact_1997\".\"customer_id\")<br> Unit Sales (33): sum(\"sales_fact_1997\".\"unit_sales\")<br> Store Cost (34): sum(\"sales_fact_1997\".\"store_cost\")
<br> Store Sales (35): sum(\"sales_fact_1997\".\"store_sales\")<br> Sales Count (36): count(\"sales_fact_1997\".\"product_id\")<br> Customer Count (37): count(distinct \"sales_fact_1997\".\"customer_id\")
<br> Sales Count (42): count(\"sales_fact_1997\".\"product_id\")<br> Unit Sales (43): sum(\"sales_fact_1997\".\"unit_sales\")<br> Store Sales (44): sum(\"sales_fact_1997\".\"store_sales\")
<br> Store Cost (45): sum(\"sales_fact_1997\".\"store_cost\")<br> Customer Count (46): count(distinct \"sales_fact_1997\".\"customer_id\")<br> <br>and consequently the following aggtable sql:
<br>CREATE TABLE agg_c_XXX_sales_fact_1997 (<br> the_year INT2,<br> unit_sales NUMERIC(10,4) NOT NULL,<br> store_cost NUMERIC(10,4) NOT NULL,<br> store_sales NUMERIC(10,4) NOT NULL,<br> SALES_COUNT INT4 NOT NULL,
<br> CUSTOMER_COUNT INT4 NOT NULL,<br> unit_sales NUMERIC(10,4) NOT NULL,<br> store_cost NUMERIC(10,4) NOT NULL,<br> store_sales NUMERIC(10,4) NOT NULL,<br> SALES_COUNT INT4 NOT NULL,<br> CUSTOMER_COUNT INT4 NOT NULL,
<br> SALES_COUNT INT4 NOT NULL,<br> unit_sales NUMERIC(10,4) NOT NULL,<br> store_sales NUMERIC(10,4) NOT NULL,<br> store_cost NUMERIC(10,4) NOT NULL,<br> CUSTOMER_COUNT INT4 NOT NULL,<br> fact_count INTEGER NOT NULL
<br>);<br><br>from what I can tell, the repetition is due to having multiple cubes on the same fact table. <br>I thought that maybe changing the RolapStar.Table.containsColumn() <br>would help, but no, since the measure = measure returns false for different cubes, but still
<br>all these measures get assigned to the same table. ... problem is that AggGen can't tell them apart.. a<br>Is the repetition of fields a bug? or just that AggGen can't handle it?
any ideas?<br><br>mind you.. this may not be important at all.. just when using AggGen it gets irritating...
<br>