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 and while this is kind of descriptive, it's not very catchy . I am thinking of maybe something like powerCube, powerSSAS, powerOlap or even psAMO. So if you have any ideas for names, or if you have a preference for any of these; leave me a comment and let me know.

Technorati Tags: , ,

Print | posted on Sunday, August 26, 2007 10:20 PM

Comments on this post

# Message in a bottle: Is anyone programming in AMO?

Requesting Gravatar...
Is anybody out there? I'm writing data-driven AMO applications to create SSAS schema but I feel so alone! I can't find any kindred spirits online. The example code provided by Microsoft is deterministic and incomplete. I have problems I can't figure out and I need company.

Is anyone listening? Please respond :).
SSASAMO at nicholsoncomputerconslting dot com
Left by Bill Nicholson on Mar 06, 2008 12:09 AM

# correction to previous message

Requesting Gravatar...
I can't even type my own domain correctly:

SSASAMO at nicholsoncomputerconsulting dot com
Left by Bill Nicholson on Mar 06, 2008 12:15 AM

# re: SSAS: AMO Powershell Provider

Requesting Gravatar...
Love the provider...
Question: I am trying to use the invoke-ASMDX cmdlet. It works for running small script. But it would be very usefull, if it would accept a MDX file as an argument. I have a slightly big MDX command, but when I use this cmdlet to run it is not able ot parse the script properly.
Left by Shan Sivakolundhu on Jul 10, 2009 9:22 AM

# re: SSAS: AMO Powershell Provider

Requesting Gravatar...
The invoke-ASMDX is passing through the query to AMOMD.NET, so it should work with any size query. Are you able to post the error that you are getting? You can contact me via email using the contact link on the right hand side if you would like to discuss this directly.

Invoking an MDX query from a file directly would be an interesting feature. I'll look into it.
Left by Darren Gosbell on Jul 10, 2009 11:47 AM

# re: SSAS: AMO Powershell Provider

Requesting Gravatar...
Thanks Darren...
It was not a problem with the cmdlet... I was not copy/pasting it properly into the powershell window. It does work properly.

I am trying to get the QA folks to use the provider to fire off different MDX scripts from multiple machines to gather some stats. If the cmdlet can invoke an MDX from a file, then scripting such a thing would be easier...

Appreciate your response...
Left by Shan Sivakolundhu on Jul 15, 2009 7:19 AM

# re: SSAS: AMO Powershell Provider

Requesting Gravatar...
You might also be interested to look at the ascmd sample that is part of the official product samples for SSAS on codeplex. I believe that it can run a series of MDX statements from a file - although this was more aimed at load testing than QA testing, so I'm not sure what it does with the resultsets.
Left by Darren Gosbell on Jul 15, 2009 10:17 PM

# re: SSAS: AMO Powershell Provider

Requesting Gravatar...
Yup... Ran into the ascmd package... As you rightly pointed out it is for load testing. But we also want to do some load testing, so I will be using those to do that.

The one thing I noticed in ascmd is that it only returns the results in XMLA. It does take MDX files as inputs, which is good.
Left by Shan Sivakolundhu on Jul 18, 2009 1:35 AM

Your comment:

 (will show your gravatar)