Hi

I'm trying to use the objects in the Microsoft.AnalysisServices namespace (in VB.NET) to manage objects on the SSAS server.  (Specifically, I'm trying to create a partition).

Reading collections, objects and properties from the server works fine.  But if I try to do anything (write rather than read), the code runs with no errors, but on the server nothing has happened.

All the examples I've seen use this .CaptureXML to capture the XMLA generated, and then .ExecuteCaptureLog to actually do the thing.

Why is this?  Is it the only way to actually do anything with these objects?  Or just a better way?  Is there some magic "DO IT" method I can execute on the server, to make the changes my code makes actually happen?

I've (of course) looked at the MSDN documentation, but it (as all too often these days) says nothing about this kind of background information: it's pretty much all based on this template:

Public Sub ThrobWangle(Wangle Wangle, HowMuch int)

'This method throbs the wangle, to a degree specified by HowMuch

Does anyone know of any more "meta" documentation on these objects?

Hi

It sounds like you are probably not executing the update command after adding the new partition to the measuregroup with the ExpandFull option after creating the partition.

In C# this would look something like this p.Update(UpdateOptions.ExpandFull);

If you are interested there is an open source codeplex project where many of the functions have already been built that you are looking for.

https://tabularamo2012.codeplex.com/

• Edited by MichaelAdrianJohnson 11 hours 55 minutes ago fix grammar

Hi

It sounds like you are probably not executing the update command after adding the new partition to the measuregroup with the ExpandFull option after creating the partition.

In C# this would look something like this p.Update(UpdateOptions.ExpandFull);

If you are interested there is an open source codeplex project where many of the functions have already been built that you are looking for.

https://tabularamo2012.codeplex.com/

• Edited by MichaelAdrianJohnson Tuesday, July 07, 2015 7:11 PM fix grammar
• Marked as answer by sebts 22 hours 19 minutes ago

Hello,

There is a code that can change the Metadata of the cube. It uses C# AMO.

https://ssaspartitionmanager.codeplex.com/

Regards,

Suresh

Thank you both for your replies - I'm looking at both those code projects now!

At the bottom of the samples page on codeplex is a project called AMO Adventure Works. This project builds a subset of the Adventure Works database entirely using AMO.

http://msftasprodsamples.codeplex.com/