with (nolock)

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

The Daily Dirty Read

MDX Editor - Changes for August 7th, 2007

I tried to correct the issue with some cubes not displaying properly but didn't have too much luck.  It fixed the problem on one of my PCs but not the other.  Has something to do with ADOMD not reporting the database or cubes correctly.  Will continue to investigate.
 

I did add several new features and snippets.  I added new snippets for named set  (nset I think), bottomsum and topsum (bsum and tsum respectively).  Also Ctrl+Shift+P should invoke the snippet picker now or you can type the shortcut and press <TAB>.  The top and buttom sum snippets will drop down a measures list for the 3rd argument.  You can get a drop down list of measures in your own snippets by using "Measure" as the title for the replacement.  This builds upon the existing "DateLevel" that will show all levels from Date user hierarchies in date dimensions.

I also added the ability to have AutoReplacements and to be able to right click on some objects in the treeview to add those autoreplacements manually.  Although the menus work for all treeview nodes, some don't perform any actions yet (hey, it's 1:30AM here and I have to get up at 6:00AM).  You can right click on level/hier/member/measure for both individual adds and child adds.  The autoreplacements should make it easy to replace common items with a shorter name or be able to pick them from the list by pressing "!" (by default, all system assigned replacements have "!" as the first character of the find text).

I want to possibly improve the autoreplacement list to have it narrow itself down and possible not even show itself until the list of items can be narrowed since you could have thousands of replacements defined.

Hopefully this week I can resolve the cube issue, clean up some of the replacements and menus, and add the ability to save/load scripts, manage scripts in a query manager type repository, and export results to PDF/Excel/etc.

Here is a link to a short video that shows some of the new features: http://withnolock.com/communityserver/files/folders/8/download.aspx

Published Tuesday, August 07, 2007 6:25 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

 

Winston said:

Hi there Achobbs, I have come across your website in my search for good MDX editor for SQL 2000 and 2005 and am now wondering how much farther you have managed to get with this great development? I will try to download it and take it to work with me. Will also try to let you know if I have any issues crop up... Hope you keep it going.

Winston

February 8, 2008 3:51 PM
 

Ashton said:

Winston, I kinda stopped dev a while back because of what I thought was lack of interest.  I had someone else ask today about it.  What features do you think it would need before it really becomes useable?

February 14, 2008 1:39 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server (Personal Edition), by Telligent Systems