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.
As mentioned last week, I have started the Databases and Data Visualisations course for kids aged between 11 to 15 years yesterday. It was...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...