Inserting Dimension and Member Names into Scripts

An outline that is associated with an editor (such as Calculation Script Editor or Formula Editor) is displayed in a tree view in the upper left pane of the editor window. Tree views can display aliases, rather than names, and can be searched for names.

To insert dimension and member names into scripts, you can select from the tree. You need not enter names manually. However, if entering formula text manually, you must enclose in quotation marks member names that contain blanks or special characters.

For duplicate members, qualified member names must be entered. For example, if the outline contains two New York members, one of the two qualified member names must be inserted (such as "[State].[New York]" rather than “New York”). You can view the qualified member names for a duplicate member in the Member Properties dialog box in Outline Viewer. If you select names from the tree (rather than entering them manually), qualified member names are inserted automatically.

  To insert dimension and member names into scripts:

  1. Open or create a script.

  2. If the outline tree in the editor window is not populated, associate an outline with the script.

  3. In the outline tree, complete one or more of the following tasks to locate the member that you want to insert in the script:

    • To expand a dimension, select the dimension, right-click, and select Expand to descendants.

    • To locate a dimension or member in the outline tree:

      1. Select any dimension or member.

      2. Right-click, and select Find members to open the Find Members dialog box.

      3. On the Find Results tab, double-click the preferred dimension or member name.

    • To display and insert alias names, instead of member names:

      1. Select Use aliases.

      2. From Alias table, select an alias table.

  4. Select the preferred dimension or member name or alias, right-click, and select Insert member.

    Note:

    To insert level 0 members, you can double-click the member name.

    The name or alias is inserted in the script at the cursor position; the name is enclosed in double quotation marks ("name").

Related Information