HomeSQLServerPedia SyndicationCan you query a SSAS cube while it is processing?

Comments

Can you query a SSAS cube while it is processing? — 7 Comments

  1. The best process, IMHO, is to have a production instance of SSAS and a “preprod” processing instance. Do all of your processing in “preprod” then sync into production upon successful processing. This approach means the production SSAS cube is always online and available.

    • That a great idea Wes, and one I recommend if your cube takes a long time to process, as processing is very resource intensive. Or if you can’t afford the cube being inaccessible for even a minute (although a sync does require a write lock on the target server). You have to balance the benefits of a “preprod” with the cost and effort to maintain another instance and the extra step needed for synching. And also keep in mind how often you would even need to process the cube during work hours. For info on how to sync, check out Push Cube Changes Using Synchronization

      My thoughts on writing this article was for those situations when you normally process the cube nightly during a maintenance window but occasionally upper management requests the cube to be processed during the day and they ask “Will that cause any problems?”. Hopefully, this article will help you to answer that question.

    • Hi Wes,

      Thanks for you input. Can you please tell me know how are the steps to synchronize the preprod SSAS cube with production one once the processing is complete in preprod so that the end user do realize the downtime while switching.

      Regards,
      Gogs

  2. Pingback:Improving cube processing time | James Serra's Blog

  3. hi james, when you say cube being process, which type of process are you referring to ?
    if it’s process updates, then you can access at any time. If it is full process, that is
    a different story…

  4. Hi James,

    Please can you tell whether it is possible to writeback data in the table while cube is processing, we are currently using excel with writeback enabled so that it can writeback to the table but while cube is processing , the excel goes unresponsive when hit on Publish Button during cube process.

    Please also let me know if you know any workaround to writeback data in the table during cube process.

Leave a Reply to Wes W. 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>