Question : Please How tell me how i refresh the Cube automatically by another way or for this way what happen when i restart my System? and another question is : When I Upload the changes in Database by using SSIS Process and Agent services of sql server hoew i manage the refresh system ? for example, First of all i update the data in to the sql server then process will start automatically. and when next update the first process is not to be completed. then it goes hang the system. please give me answer for this situations. Which have done for these questions ? Hi all, I am using Sql Server Analysis Services 2008 I have created a Cube as financial_data_Time is a Measure part and dimensions are account_dimension, company_dimension, cost_center_dimension, month_dimension, year_dimension. Name of Cube to use as MySampleCube. The cube deploys successfully. Then I create SSIS Package to and use the Connection manager to connect the database which i created in Sql Server. and use the Analysis service Prcessing task tool and add the object as Our cube name MySampleCube. the process is success displays it successful. after that I Use the Sql Server Agent Services to refresh the cube automatically. and write the steps to refresh it. It works Successfully. My main question is when i create this process it works successfully but when i restart the my computer system the It will not work and When I check to what is the problem behind then it will ask the authentication or to open the database It gives the Error as Access dined. please check the log details. and Database is crash as well as SSAS Cube is crash totally and SSIS Process is Un Successful. Question : Please How tell me how i refresh the Cube automatically by another way or for this way what happen when i restart my System? and another question is : When I Upload the changes in Database by using SSIS Process and Agent services of sql server hoew i manage the refresh system ? for example, First of all i update the data in to the sql server then process will start automatically. and when next update the first process is not to be completed. then it goes hang the system. please give me answer for this situations. Thank you Regards, Parikshit R. Deshpande

The following forum is more appropriate for your questions: SQL Server Analysis Services For each question, start a new thread. Post as much supporting information as you can. Make sure you check all error logs and Event Viewer for related messages. Thanks.Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training