I needed to automate the process of refreshing my Sql Server Analysis Services Cubes. My SQL server is 2000 and Analysis Services is SP4.
The approach I followed today is as follows:
I created a package in DTS of SQL Server 2000
Step 1 Created a SSAS task and pointed the Dimension (Rebuild the dimension) that needs to be updated.
Step 2 Then I created another task to refreshh all cubes.
Step 3 I created a On Success workflow between the above two tasks.
I saved this package and scheduled it to run monthly.
Today I had a situation where a few of the subscriptions for a particular report have failed. I needed a script to run only these subscripti...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
What is Checksum? Checksum is a function available in sql server 2005 and sql server 2008. It is intended to build a hash index based on an ...