AnalysisServices

There are 5 entries for the tag AnalysisServices
SSAS: AMO Powershell Provider
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 ......

Posted On Sunday, August 26, 2007 10:20 PM | Comments (8)

SSAS: Manipulating Cube Partitions with PowerShell
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 ......

Posted On Sunday, August 26, 2007 10:13 PM | Comments (2)

SSAS: AMO gems from the MSDN Forum - Measures.Remove()
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. ......

Posted On Wednesday, July 18, 2007 11:32 PM | Comments (0)

SSAS: Analysis Services Stored Procedure Project (ASSP) 1.1 release is out!
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 ......

Posted On Sunday, June 24, 2007 10:32 PM | Comments (1)

BIDSHelper: DeployMDXScript feature enhanced
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 ......

Posted On Wednesday, June 6, 2007 11:24 PM | Comments (1)