with (nolock)

Home of the Dirty Read
Welcome to with (nolock) Sign in | Join | Help

MDX Editor for SSMS

File Details
Downloads: 1650 File Size: 4.8MB
Posted By: achobbs Views: 2569
Date Added: 5 Aug 2007
An improved (hopefully) MDX Editor for SSMS that provides Intellisense, Snippets, tooltips, and a better results viewer that can support more than 2 defined axis in a query.

Comments
 

doesn't work for me said:

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)
6 Aug 2007 3:59 PM
 

Jerome said:

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.
6 Aug 2007 4:23 PM
 

achobbs said:

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.
6 Aug 2007 9:15 PM
 

achobbs said:

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)
6 Aug 2007 10:16 PM
 

still not working for me said:

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()
7 Aug 2007 11:24 AM
 

still not working for me said:

Also, in vista add/remove programs the latest installer is seeing "1.0" as the app name.
7 Aug 2007 11:27 AM
 

Ashton said:

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.
7 Aug 2007 12:29 PM
 

yes our code does nearly simplest possible connect said:

using (AdomdConnection connection = new AdomdConnection("connection string") { connection.Open(); CubeDef cubeDef = null; try { cubeDef = connection.Cubes[cubename]; } ... }
7 Aug 2007 1:47 PM
 

MichaelK said:

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)
8 Oct 2008 6:23 AM

Add Comment

Name (required)
Web Site (optional)
Comment (required)
Add
Powered by Community Server (Personal Edition), by Telligent Systems