At present, we are doing manual steps to process a cube. We do it on daily basis. I am trying to create a Job Scheduler from SQL Agent to process the Cube on every morning by 9:00 AM. Prior to process the cube, I wonder what would be the best bet to automate the Cube Process.
Is there any ways to call the cube from SSIS Package and process it