After you select an application and database to associate with an MDX script, you can select dimension and member names directly from an outline tree to insert them in a script. You use the outline tree in conjunction with the MDX function tree to build MDX statements quickly.
You can change the outline tree view to display alias names instead of member names, and you can search the tree for specific members.
For databases allowing duplicate member names, if you choose to enter a member name instead of inserting it from the outline tree, you must enter the qualified member name for any duplicate member in order to differentiate the members. You can view the qualified member name for a duplicate member in the Member Properties dialog box in Outline Viewer. If you insert member names as described in this topic, the qualified member name is inserted automatically.
To insert dimension and member names in an MDX script:
If the outline tree in the editor window is not populated, associate an outline with the script.
In the outline tree, complete one or more of the following tasks to find the member that you want to insert in the script:
To expand all members under a dimension, select the dimension, right-click, and select Expand to descendants.
To find a member in the outline tree, select a dimension or member, right-click, and select Find members. On the Find Results tab, double-click the name to locate the member on the outline tree.
To display and insert alias names instead of member names, select Use aliases and select an alias table.
Select the dimension, member, or alias that you want to insert into the script, right-click, and select Insert member.
Note:
To insert level 0 members, double-click the member.
The name is inserted in the script at the cursor position. If the outline tree shows aliases instead of member names, Essbase inserts the alias in the script instead of the member name.
In outlines that allow duplicate member names, if you insert a duplicate member name, the qualified member name is inserted in the script. For example, if the outline contains two members named New York, if you insert either New York member, the qualified member name is inserted in the script.