Where are the SSAS Optimization logs configured?

• admin 3353

  SSC Veteran

  Points: 204

  More actions

  March 9, 2011 at 9:13 am

  #233089

  I am getting the message "Invalid Object Name 'OlapQueryLog'" when I try to run the usage-based optimization wizard. I have not found where this file is supposed to reside or where to change the configuration, assuming this is some permissions problem. Where should I be looking? Thanks.

• admin 3353

  SSC Veteran

  Points: 204

  More actions

  March 9, 2011 at 9:20 am

  #1296591

  OK, the configuration is Analysis Services > Properties > General tab.

  However, even when I change the path and filename, I still get the error (referencing the new filename).

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  March 9, 2011 at 10:33 am

  #1296641

  I always logged to a db table, are you set up the same way and if so, is the connection information correct?

  Steve.