Arc - MDX Lab - additional UI integration, drag & drop & auto-complete enhancements
Is your feature request related to a problem? Please describe.
MDX Lab is a useful tool to design and debug MDX queries. However, it must be accessed via the Tools menu in the Server Tree, which is not always convenient, and any MDX needs to be cut and pasted manually out of other editors/viewers.
Describe the solution you'd like
MDX Lab is like a code sandbox (EG JSFiddle.net) -- it should be available to edit MDX queries wherever they exist.
Like a code Sandbox, Arc could use a "Test in MDX Lab!" approach, which would also load the MDX in the Lab for the user without any cut-and-paste, or be more directly integrated. For example, it could potentially be embedded into other pages (like "Use MDX Editor") or accessed via popup dialog (like Subset Editor).
Additionally, MDX Lab should have the ability to (optionally) copy the MDX string back to the original editor/viewer.
Describe alternatives you've considered
It's easy to do these things manually, but users would appreciate the convenience of a tighter integration.
Additional context
It's worth noting that, in the abstract, the Cube Viewer and Subset Editor interfaces are just alternative visual editors for MDX.
For example, dragging and dropping dimensions between Hierarchies, Titles, Columns & Rows is just a visual way to edit an MDX string.
Likewise, clicking dimension operations (Drill, Expand all, Sort By Hierarchy, Keep, etc) in the Subset Editor toolbar.
It's possible that the integration could be more fundamental than opening the MDX editor from other places -- the MDX Lab editor could fundamentally underpin all other MDX interfaces. Just something to think about.
TODO
-
Set default splitter size for first time load -
Create help page -
Subset Editor: Restrict drag-drop by object names -
Subset Editor: Link to old MDX Editor -
Subset Editor: Mini-toolbar for basic commands -
MDX Editor: Auto-complete - include hierarchies at [dim].[
-
Separate MDX Editor component from MDX Lab -
Fix missing translations -
Embed MDX Editor in Subset Editor -
MDX Editor: Complete Drag / Drop behaviours (see below) -
MDX Editor: Auto-complete - move all custom auto-complete logic into MDX Editor -
MDX Editor: Auto-complete - list cubes at WHERE [cube].(
and[cube].(
-
MDX Editor: Auto-complete - list elements at [dim].[hie].[
and[dim].[
-
Subset Editor: Restrict drag-drop by object type