Tag | AnalysisServices Posts

Following up from my recent post on Powershell, I have updated the Powershell provider for Analysis Services that I wrote back when Powershell was still known by its code name of "Monad", so that it works with the released version of Powershell. I have a few more features that I would like to add to it, but it is quite functional in its current state and I am thinking of putting it up on codeplex in its current form. My main issue now is what to call the thing. The project is currently called AmoPsProvider ...
Jesse Orosz posted some interesting sample code recently on how to remove partitions with a certain prefix using AMO. I thought it would be an interesting comparison to see what similar code would look like in PowerShell. There is definitely not anything wrong with Jesse's code, it's obviously part of a much larger framework. It's more that I think PowerShell is a really good tool for doing these sort of admin tasks and it's an interesting exercise to take someone else's code from .net and re-implement ...
The second gem from the Analysis Services MSDN forum is also by Adrian Dumitrascu and deals with what the second "CleanUp" argument of the Measures.Remove() method does. MeasuresCollection.Remove() Method The 'cleanUp' boolean argument specifies if the dependent objects will be removed. For a Measure, the dependents include the PerspectiveMeasure objects. For a DimensionAttribute, the dependents include the CubeAttribute objects. If you do not specify the 'cleanUp' parameter, the dependents are removed. ...
It's been a little while since we did the initial release of ASSP, but things have been bubbling along quietly in the background and today we pushed out another release which in addition to a few minor fixes includes the following new features. ListFunctions - This is cool on a couple of fronts (and not just because it is one of mine :) ) Firstly it is practical because it will list all the available functions in all the .Net assemblies that have been registered either at the server or, if you pass ...
Have you ever renamed a deployed database in SSMS and then tried to deploy changes using BIDS? I don't imagine that it is too common an occurrence as it does not work! I renamed the "Adventure Works DW" sample to "Adventure Works DW1" in SSMS and then told BIDS to deploy to the "Adventure Works DW1" database and got an error that the "Adventure Works DW1" database already exists - of course it does. If you capture the XML/A that BIDS is sending you will notice something strange. The ID and the Name ...