using FoodMart, the following table (partial) is created: <br><br>Table:<br>&nbsp;&nbsp;&nbsp; alias=sales_fact_1997<br>&nbsp;&nbsp;&nbsp; relation=sales_fact_1997<br>&nbsp;&nbsp;&nbsp; Columns:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unit Sales (0): sum(\&quot;sales_fact_1997\&quot;.\&quot;unit_sales\&quot;)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store Cost (1): sum(\&quot;sales_fact_1997\&quot;.\&quot;store_cost\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store Sales (2): sum(\&quot;sales_fact_1997\&quot;.\&quot;store_sales\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales Count (3): count(\&quot;sales_fact_1997\&quot;.\&quot;product_id\&quot;)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer Count (4): count(distinct \&quot;sales_fact_1997\&quot;.\&quot;customer_id\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unit Sales (33): sum(\&quot;sales_fact_1997\&quot;.\&quot;unit_sales\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store Cost (34): sum(\&quot;sales_fact_1997\&quot;.\&quot;store_cost\&quot;)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store Sales (35): sum(\&quot;sales_fact_1997\&quot;.\&quot;store_sales\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales Count (36): count(\&quot;sales_fact_1997\&quot;.\&quot;product_id\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer Count (37): count(distinct \&quot;sales_fact_1997\&quot;.\&quot;customer_id\&quot;)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales Count (42): count(\&quot;sales_fact_1997\&quot;.\&quot;product_id\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unit Sales (43): sum(\&quot;sales_fact_1997\&quot;.\&quot;unit_sales\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store Sales (44): sum(\&quot;sales_fact_1997\&quot;.\&quot;store_sales\&quot;)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Store Cost (45): sum(\&quot;sales_fact_1997\&quot;.\&quot;store_cost\&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer Count (46): count(distinct \&quot;sales_fact_1997\&quot;.\&quot;customer_id\&quot;)<br>&nbsp;&nbsp; <br>and consequently the following aggtable sql:
<br>CREATE TABLE agg_c_XXX_sales_fact_1997 (<br>&nbsp;&nbsp;&nbsp; the_year INT2,<br>&nbsp;&nbsp;&nbsp; unit_sales NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; store_cost NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; store_sales NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; SALES_COUNT INT4 NOT NULL,
<br>&nbsp;&nbsp;&nbsp; CUSTOMER_COUNT INT4 NOT NULL,<br>&nbsp;&nbsp;&nbsp; unit_sales NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; store_cost NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; store_sales NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; SALES_COUNT INT4 NOT NULL,<br>&nbsp;&nbsp;&nbsp; CUSTOMER_COUNT INT4 NOT NULL,
<br>&nbsp;&nbsp;&nbsp; SALES_COUNT INT4 NOT NULL,<br>&nbsp;&nbsp;&nbsp; unit_sales NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; store_sales NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; store_cost NUMERIC(10,4) NOT NULL,<br>&nbsp;&nbsp;&nbsp; CUSTOMER_COUNT INT4 NOT NULL,<br>&nbsp;&nbsp;&nbsp; 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.&nbsp; <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. ...&nbsp; problem is that AggGen can&#39;t tell them apart.. a<br>Is the repetition of fields a bug?&nbsp; or just that AggGen can&#39;t handle it?
any ideas?<br><br>mind you.. this may not be important at all.. just when using AggGen&nbsp;&nbsp; it gets irritating...
<br>