with (nolock)

System.ArgumentException: The 'my cube' object was not found. Parameter name: index at Microsoft.AnalysisServices.AdomdClient.CubeCollectionInternal.get_Item(String index) at Microsoft.AnalysisServices.AdomdClient.CubeCollection.get_Item(String index) at SchemaSolutions.Olap.MdxEditor.Initialize(String server, String database, String cubeName) at SchemaSolutions.Olap.MdxIde.DisplayCube(String name) at SchemaSolutions.Mdx.ToolWindowExample.Initialize(String server, String database, String cubeName) at SchemaSolutions.Mdx.SsmsCommandTarget.SsmsManager_MenuItemClicked(Object sender, SsmsMenuClickEventArgs e) at Gmd.SsmsLibrary.SsmsManager.MenuItemClicked(Object sender, SsmsMenuClickEventArgs e) at Gmd.SsmsLibrary.SsmsMenuItem.Invoke() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItemBase.MenuInvokedHandler(Object sender, EventArgs args)

installation ok but starting management studio raise an error: the add-in 'ashton's SSMS MDX add-in' failed to load or caused an exception. Error message: class not registered Error number: 8004154 I'm asked to remove the add-in. I have run again the installation process and manually execute the registeraddin utility, but nothing works. I'm using an x64 server.

The my cube issue should now be fixed (had to do with how SSMS was reporting the database in some cases). The "Class not registered" is usually due to not having SQL SP2 Client tools installed although it could be related to x64. It would definitely be the cause for 32bit systems that don't have SP2 of SQL installed on the client machine where you are running SSMS.

Well, seems that the cube not found is still not working on some databases. For some reason ADOMD cannot pull cubes or connect properly to some databases. Still investigating. Did post new version that has some new snippets and ability to do autoreplacements (see new blog post for info)

still not working for me: with a new error. Via sql mgmt studio i can naturally run mdx just fine Also I am using adomd in another app to connect to this server/cube just fine. Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, domain\username, does not have access to the random-guid-redacted database, or the database does not exist. at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover(String requestType, IDictionary restrictions, DataTable table) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Discover(AdomdConnection connection, String requestType, ListDictionary restrictions, DataTable destinationTable, Boolean doCreate) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf() at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count() at Microsoft.AnalysisServices.AdomdClient.CubeCollection.get_Count() at SchemaSolutions.Olap.MdxEditor.Initialize(String server, String database, String cubeName) at SchemaSolutions.Olap.MdxIde.DisplayCube(String name) at SchemaSolutions.Mdx.ToolWindowExample.Initialize(String server, String database, String cubeName) at SchemaSolutions.Mdx.SsmsCommandTarget.SsmsManager_MenuItemClicked(Object sender, SsmsMenuClickEventArgs e) at Gmd.SsmsLibrary.SsmsManager.MenuItemClicked(Object sender, SsmsMenuClickEventArgs e) at Gmd.SsmsLibrary.SsmsMenuItem.Invoke()

Also, in vista add/remove programs the latest installer is seeing "1.0" as the app name.

still, the app where you use ADOMD to connect to the server/cube you're using, do you access the actual CubeDef through the AdoMdConnection? If so, is the database name you use to connect the same as what is displayed in SSMS? The problem i can't seem to figure out is that I can make a connection but there are no Cubes on the AdomdConnection object so I can't access the info. I'll change the 1.0 in next build to make it show up in Control Panel as something more friendly.

using (AdomdConnection connection = new AdomdConnection("connection string") { connection.Open(); CubeDef cubeDef = null; try { cubeDef = connection.Cubes[cubename]; } ... }

I get the following error after installation and opening a connection in SSMS: System.TypeInitializationException: The type initializer for 'Gmd.SsmsLibrary.SsmsManager' threw an exception. ---> System.MissingMethodException: Method not found: 'System.Windows.Forms.ToolStripItem[] Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.IWinformsMenuHandler.GetMenuItems()'. at Gmd.SsmsLibrary.SsmsManager..cctor() --- End of inner exception stack trace --- at Gmd.SsmsLibrary.SsmsManager.NodeSelected(Object sender, NodesChangedEventArgs e) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.OnSelectionChanged(NodesChangedEventArgs args) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.SelectedNodeChanged(Object sender, TreeViewEventArgs args) at System.Windows.Forms.TreeViewEventHandler.Invoke(Object sender, TreeViewEventArgs e) at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e) at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv) at System.Windows.Forms.TreeView.WmNotify(Message& m) at System.Windows.Forms.TreeView.WndProc(Message& m) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)