with (nolock)

Home of the Dirty Read
Welcome to with (nolock) Sign in | Join | Help
in Search
Home Blogs Forums Photos Downloads

The Daily Dirty Read

New MDX Editor

I've posted an MDX Editor I've been working on in my spare time.  It integrates with SSMS and provides features like Intellisense for MDX as well as snippets (very few defined currently but they can be user created).  The editor requires SQL SP2 client tools and can be invoked by right clicking on a cube and choosing the context menu to open the editor (Currently "Ashton's MDX Editor")

For those who find it useful, please let me know what other items you would like to see and I will add them as time permits.

The file is available for download from here: http://withnolock.com/communityserver/files/default.aspx

 

Published Monday, August 06, 2007 12:31 AM by achobbs

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Antony Sims said:

It would be really useful if you could drag-and-drop items from the tree onto the Pivot Results pane in order to generate/edit the MDX script in the script pane.

August 12, 2007 6:20 PM
 

achobbs said:

Antony,

I'll think about that.  I think it should be possible to do some basic MDX generation that way (I assume you're talking about dragging a hier/level/member to the grid and then generating the MDX for whether you dropped it on rows/columns/etc?

August 13, 2007 7:22 AM
 

sxq613 said:

how can i get your mdx editor. it need an account when i download it.

January 2, 2008 12:27 AM
 

feemurk said:

Hi,  Can you make your MDX Editor recognize unique members from the root of the dimension?  I would prefer to have the intellisense to be able to recognize [Time].[Quarter].[Q12005] as either that or [Time].[Q12005].  It should be relatively easy to implement by recursing through the defined hierarchies for a given dimension.

Thank you for a neat little tool! :)

November 7, 2008 4:54 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Personal Edition), by Telligent Systems