Saturday, February 02, 2013 8:57 PMI need to refresh data every second hour. How to do automatically?
Sunday, February 03, 2013 5:29 AM
have you thought about creating a job in sql server agent then set a schedule for that ?.. if no this is an easy option, the following is a link that contains the steps to do so:
but in summary, you have to generate a script to process your cube then past that script in a job in sql server agent .. again the link contains step by step how to do it + screenshots.
after you follow the steps in the URL, add schedule to the job ... hopefully you know how to do that, if not, please let us know
Monday, February 04, 2013 3:01 AMModerator
We have two options to process our cubes automatically:
•SQL Server Agent
SQL Server Agent is a Windows service that runs scheduled administrative tasks, or jobs. For example, you can create a job that processes a cube and then performs a backup of the cube. For more information, see Automating Administrative Tasks (SQL Server Agent).
•SQL Server Integration Services
SQL Server Integration Services is a platform that is used to build enterprise-level data integration and data transformation solutions. You can use an Integration Services package to automatically process cubes. The package that you create should include at least two Analysis Services Processing tasks. The first task should process the dimensions, and the second task should process the cubes. For more information, see the Analysis Services Processing Task topic and the Cube Processing discussion.
For more information, please see:
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 12, 2013 3:20 PM