InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:32:05 GMT20http://www.sqlservercentral.com/Forums/Topic953673-17-1.aspxSorry, yes, I am using Analysis Services 2005 and Visual Studio 2005. I want to design cube aggregations with the usage-based optimization wizard.Fri, 16 Jul 2010 02:50:20 GMTnmesethhttp://www.sqlservercentral.com/Forums/Topic953673-17-1.aspxAnalysis services? Are you designing cube optimisations?Fri, 16 Jul 2010 02:48:00 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic953673-17-1.aspxHi,the usage-based aggregation optimization wizard does not seem to offer a way to configure the source of the log it uses for optimization. I am using QueryLog and I have configured it to write to a [b]file [/b]instead of a log table. I have done this simply because there is no database in our project where I could write the data to, and I have access to a share on the server where I store the file.Anyway, does anyone know how to tell the aggregation wizard to read the query information from this file? Also, in general, where does the wizard get the information about the connection string from if I used a log table?Any help is very much apprecitated!NicolasFri, 16 Jul 2010 02:32:37 GMTnmeseth