Hi,
I am creating ROLAP aggregations on Analysis services 2005. When I tried to
process I am getting error "OLE DB error: OLE DB or ODBC
error: Incorrect syntax near ')'.; 42000.". This is due to
the query "CREATE UNIQUE CLUSTERED INDEX [Agg_Sales Fact
1997_1_3_3_10_10_2] ON [Agg_Sales Fact 1997_1_3_3_10_10_2]
( )" generated by analysis services engine. As you see
the query, there is no column name specified in the
paranthesis to create index. Please let me know is there any bug while
analysis services generates the SQL query while processing or I am missing
anything.

Thanks in advance,