MDX Script Editor displays a tree view of MDX functions. When you select a function from the tree, you insert the function and its argument template into the open script without having to type it manually. You can then change the arguments, as appropriate.
Note: | The functions displayed in the tree may be different depending on the Essbase Server release level to which you are connected. |
To insert an MDX function into an MDX script:
In the lower left pane of the script editor window, MDX functions are displayed in a tree view.
Perform an action:
To view the list by category, click the Categorical tab.
To view the list in alphabetical order, click the Alphabetical tab.
In the script, click where you want to insert the function and its argument template.
In the functions tree, double-click the function that you want to insert.
Essbase inserts the function at the cursor position in the script. Replace the argument template with the appropriate dimension or member from the outline tree. See Inserting Dimension and Member Names in MDX Scripts.