Hello
During deployment process of large db ~200M rows I got the error
Error 1 OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00
The Analysis 2005 "data source view" connected to mssql 2000 that select the 200M rows from view.
Please advice what to do.
Thanks
Amir
If you are using the Enterprise Edition of SSAS2005 have a look at partions. You can divide cubes by using partitions and select different time periods for each partition.
With these you do not have to load all data at once.
Regards
Thomas Ivarsson
No comments:
Post a Comment