Analysis Services 2000 DSO Scripts

I have a number of DSO scripts that I developed a couple of years ago when I was working on a very large Analysis Services 2000 project. I was recently catching up on the OLAP newsgroup and noticed that there was someone asking about DSO scripts for copying aggregations. I had one such beast in my tool box and decided to post it on my blog. As I get time I will go through and pull out some of the other more generic scripts and put them up here too.

Copying Aggregations Script

List Source Tables (added 1 Oct 2005)

List Aggregation Counts (added 17 Oct 2005)

List Cube Sizes (added 24 Feb 2006)

Add Roles (added June 13 2006)

Print | posted on Thursday, September 8, 2005 7:30 AM

Comments on this post

# re: Analysis Services 2000 DSO Scripts

Requesting Gravatar...
how do you plan to port the current DSO code to 2005. I have a lot of DSO code as well and i would hate to loose it all!!!
Left by Nick Kletnoi on Oct 26, 2005 11:05 PM

# re: Analysis Services 2000 DSO Scripts

Requesting Gravatar...
This is a very useful script & I have used it as is... I am on a larger SSAS project & every small change requires redesigning storage. Since we have on an average over 10 partitions per cube... this is great! However I have noticed that the old data in the cube still remains... although the SSAS GUI shows the cube to be not processed, the old data still remains in the partitions.

Is there any method that could empty the partitions ? I could then include it as part of the copying of aggregations.

I haven't been able to find anything so far?

Thank you,
Left by Nisha Lalvani on Nov 28, 2006 10:19 AM

# re: Analysis Services 2000 DSO Scripts

Requesting Gravatar...
The only thing I can think of might be to try processing the cube with the processBuildStructure flag. I'm not sure, but this might clear out the partitions. Unfortunately SSAS 2000 does not have a direct equivalent of the unprocess option that SSAS 2005 has.
Left by Darren Gosbell on Nov 28, 2006 8:39 PM

# re: Analysis Services 2000 DSO Scripts

Requesting Gravatar...
I realize its been a while but I am kinda new to Analysis Services 2000 (have to use 2000) and I was wondering if there was some way I could modify the Data Source for an Analysis Services database via script or C# code.

Thanks.
Left by abraham on Apr 09, 2009 12:19 PM

# re: Analysis Services 2000 DSO Scripts

Requesting Gravatar...
AS 2000 can only be administered throught the DSO COM library. So you could use VBScript or Powershell or even C#, but you would need to add a reference to the "Microsoft Decision Support Objects" COM library to use it from C#.

Then you could do something like

DSO.Server svr = new DSO.Server();
svr.Connect("localhost");
DSO.Database db = dvr.MDStores.Find("Foodmart 2000")
db.DataSoures.item(0).ConnectionString = myNewConnectionString;
svr.CloseServer();

It is very important to only change the ConnectionString, do not change the name or you will break all the connections to your cubes and dimensions.
Left by Darren Gosbell on Apr 09, 2009 12:52 PM

Your comment:

 (will show your gravatar)