schedule MOLAP question

I have a question regarding storage configuration for storage modes and cache options. If I use schedule molap then

processing occurs automatically every 24 hours. If we load date at certain time (i.g. 4 am and 6 am) and we want to reprocess cubes after that

time then do I need to create IS packages for the specific time? I'm not clear when actually processing occurs with schedule molap.

Please let me know if anybody knows.

Thanks.

Take a look at the Analysis Services Processing task. If you are using SSIS to handle your ETL, I would recommend you tie the processing to your existing package using this task. As a general rule, keep your solutions as simple as is possible. This will improve the supportability of your solution.

If you need info on processing options, you may want to check out this paper:

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

B.

|||

There is also a Analysis Services Processing Best Practices article that I would also recommend.

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx

Have to confess we went with the SSIS route because it was the easiest. If I had to do it all over again, I would go the xmla route using the ascmd utility available in the SP2 sample download. http://msdn2.microsoft.com/en-us/library/ms365187.aspx We use that route in our production deployments now but our nightly loads rely on the SSIS Analysis Services processing task.

|||You're right the documentation could be clearer on this. I think the timing depends on the time when it was last processed. And I'm hoping that this would be measured from when the last process operation started. So if you deploy and process it at 3:27pm it will always reprocess at this time until you change something at which point you may change the processing time. As the other guys have suggested, it is probably better to have an explicit task initiating the processing. It gives you much more control.|||

Hi all,

Thanks for the valuable comments.

I'd better create SSIS packages for the better control.

Thanks again