HomeSQLServerPedia SyndicationImproving cube processing time

Comments

Improving cube processing time — 5 Comments

  1. Hi James,

    Thanks for your post, very informative and better than anything else I was able to locate on the web.

    Can you confirm whether the approach / functionality in this post works the same in SSAS 2005?

    Regards – Robert

  2. Thanks for the great info. I’m a bit confused.
    If I do a Process Update on a dimension, shouldn’t I then do a Process Index on the dimension? Then after I Process Data only the partitions that were affected, I Process Index on the partitions?

    Have you ever use the Process Affected Objects option? Is this advised or not and do you know why?

  3. Hi James,

    Thanks for sharing valuable inputs. I have query for you. currently I am using Processfull for partition, which is taking lots of time. I want to convert processfull to increment or process data only. But the problem only if I added 5 row and delete one row when I processdata that delete row is not getting update even there is not data for that row in the fact table. Still it shows in the Cube. Do you have any suggestion ?

    Regards,
    Sam

  4. Thanks for sharing valuable points.:) As part of Project migration process we have upgrade all ssis packages from 2008 to 2012 server and applied connection managers at project level. And scheduled all jobs in SQL Server Agent. Analysis server cube processing task job(last) is running very poor more than 9 hours rest of packages running fine and performance also improved. Before upgrade this package(cube processing task) ran’s around 55 mins. I have checked all the cube related proc’s and view’s but views(Fact tables) query’s are performing very slow. And while processing cube some errors also populating “A duplicate attribute key has been found when processing” for this case applied ignore errors in error configuration.
    Please let me know how to improve the cube processing time without doing any optimization in views.

Leave a Reply to Phil Cancel reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>