SSAS Usage Based Optimization Hangs on Initialize

• mrseanroberts

  Valued Member

  Points: 64

  More actions

  March 25, 2010 at 11:09 am

  #220446

  Hi Guys,

  I'm trying to do usage based optimization on my SSAS cubes but it just hangs on Initializing. I have sysadmin permissions on the database server where the logs are being stored and the service account has sysadmin to the database as well. There are rows being written to the database.

  I'm thinking it's a permissions problem.

  Any Ideas?

  Thanks

• JDixon-385826

  SSCrazy

  Points: 2723

  More actions

  April 7, 2010 at 12:49 am

  #1147063

  have you tried running profiler or trace against the cubes to get what you need?