BUG: Changing Partition's Underlying Fact Table Inadvertently Changes Column Name

• Microsoft SQL Server OLAP Services version 7.0

SYMPTOMS

Changing a partition's underlying fact table may change a column name if the column name is the same name as the original fact table name. Processing the partition fails and the following error appears:

ODBC error: Invalid column name <new fact table name>

WORKAROUND

Avoid having a measure column name that has the same name as the fact table.

Changing the fact table for the cube to the new fact table may also fix the problem.

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.

MORE INFORMATION

If you have a fact table named store_sales that has a column named store_sales on which you have measure defined, while processing it sends something like following to the relational db:

SELECT "customer"."customer_id", "product"."product_name", "store"."store_country", "store"."store_state", "store"."store_city", "store"."store_name", "store_sales"."store_sales" FROM "store_sales", "customer", "product", "store" WHERE ("store_sales"."customer_id"="customer"."customer_id") AND ("store_sales"."product_id"="product"."product_id") AND ("store_sales"."store_id"="store"."store_id") 

SELECT "customer"."customer_id", "product"."product_name", "store"."store_country", "store"."store_state", "store"."store_city", "store"."store_name", "sales_fact_1997"."sales_fact_1997" FROM "sales_fact_1997", "customer", "product", "store" WHERE ("sales_fact_1997"."customer_id"="customer"."customer_id") AND ("sales_fact_1997"."product_id"="product"."product_id") AND ("sales_fact_1997"."store_id"="store"."store_id") 

ODBC error: Invalid column name 'sales_fact_1997'

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug