SoftPro Tetral  MDX Editor    Products  
MDX Editor

You need MDX Visual Studio?

It is here!

Drag-and-drop editor with built-in functions allows to edit more then one MDX sintax at the same time.  Built in function support and ability to create and use local calculated sets, named sets, members,  measures and inner queries will make your life easier while working with Microsoft SSAS 2000 or SSAS 2005 or SSAS 2008.

Full support for MDX intellisense 
-
 all cube dimensions, hierarchies, levels available inside intellisense


- for cube elements intellisense windows linked in natural order
  after selection of dimension inside dimension window and pressing
  "." (dot) hierarchies window will appear

EditorIS4.JPG
- all cube measures available inside intellisense

EditorM.JPG
- all set  functions (CrossJoin, Union, Extract, Stdev ...) available
- all functions (.Members, .PrevMember, .Firstchilde ...) available
- SELECT, ON AXIS, FROM, WHERE, WITH, WITH MEMBER ...
   available with aditional features
   example: 
                - FROM will insert cube name as well
                    FROM [Sales]

WHERE, WITH, WITH MEMBER, WITH SET ...
   available with aditional features
   example: 
                - WITH MEMBER will insert WITH & MEMBER snippet
                   WITH
                          MEMBER
                         «DIMENSION».«MEMBER_NAME»
                          AS
                          '
                                «Expression»
                          '

EditorIS1.JPG
Intellisense is automatically started while you type whenever appropriate.


ESC - close intellisense window

"." (dot) activates MDX functions (.Member, .Item ...)

chars A-Z when appropriate activates MDX functions intellisense
                (CrossJoin, TopCount ...)

ENTER or TAB - selects element from listview window

Note - Intellisense will not be activated while carret is inside square brackets
           [
no intellisense zone]

Editor has it's own MDX syntax checker that will try to trap errors while writing MDX syntax in editor.Other features you can find in editor:

folding
split window
insert MDX functions over selected MDX section (even with tuples)
insert formats
insert WITH members or sets
comments/uncomments …
MDX Function drag-and-drop list
MDX hierarchical view

F3 
-
 Bracket counter, counts brackets [],{},() inside selected part of MDX 

EditorBC.JPG


F4 
-
 Inserts function over sselected MDX part
  example:
                  - select part of MDX with mouse,
                  - press F4,
                  - on dialog select function, measure,  conditions,
                  - additional filters inside function, 
                  - select Accept

F5 
-
 Runs query internaly (runs even part of MDX or single member) 

F6 
-
 Runs query externaly (runs even part of MDX or single member) 


F7 
-
 Select part of the MDX or one or more members and 
  press F7 to see captions inside tooltip (click on tooltip to close it)
  note* - displays first 20 members

F8 
-
 like F7, displays last 20 members

EditorF7.JPG

F9 
-
 Split window

F10 
-
 foldings

F11 
-
 comment/uncomment

F12 
-
 Structurize MDX

We support creating local calculated:

members
measures
sets
named sets
inner queries

in editor and designer and those elements, shared between designer and editor will be on users disposition at any time.

Any CP object can be drag-and-droped into editor from browsers inside application as well as from outside application.

   Folding.JPG  MDX Structure.jpg

Folding                                                        MDX hierarchical structure

MDX Error Checker.jpg

MDX syntax checker

 

Copyright (c) 2024 Business Intelligence Website  SoftPro Tetral