Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Creating local cubes with AMO

with one comment

Interesting nugget from the MSDN Forum, in a post by Adrian Dumitrascu: you can create local cubes in AMO. Here’s the text of the post:
 
AMO (Analysis Management Objects, the object model for administering AS2005, the successor for DSO from AS2000) also works with local cube files (.cub). You can use it to create/alter objects or to refresh the data by re-processing every night, as you mentioned.
Sample code to connect to a local cube file:

using Microsoft.AnalysisServices; // the .dll is in "%ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies", also in GAC

Server server = new Server();
server.Connect(@"Data Source=c:\MyLocalCube.cub"); // this will create an empty local cube if not there already
… // do something, for example process cubes
server.Disconnect();

 
Makes sense that you can do this, when you think about it, given that everything’s XMLA behind the scenes.

Written by Chris Webb

June 21, 2007 at 6:56 am

Posted in Analysis Services

One Response

Subscribe to comments with RSS.

  1. Hi Chris,It is a help full two lines of code. I developed an application that generates a cube on server programmatically. Previous version of my application was creating local cube using DSO. After switching to AMO I couldn\’t find a way to create a local cube. May be this will help. I didn\’t try this method yet. But I will inform you as soon.I really want to show you a video of my application. It is a combination of Linear Programming algorithms, AMO and ProClarity.Regards,Muti.Note: Please e-mail me on mehmetmutigozel@gmail.com

    Mehmet Muti

    August 21, 2007 at 11:17 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,866 other followers

%d bloggers like this: