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.
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des... -
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment