1. Administering Profitability and Cost Management
  2. Creating and Managing Rules with the Designer Features
  3. Entering Text in the Dimension Member Editor

Entering Text in the Dimension Member Editor

You can paste dimension-member combinations from Microsoft Excel into the Dimension Member Editor accessed from the Designer screen. This reduces the keystrokes needed to create new rules or modify existing rules. It is helpful for cases where users manually generate rules; for example, by using a spreadsheet or downloading dimension files through Dimension Management.

To access the Dimension Member Editor from the Designer screen:

  1. On the Home page, select Models, and then Designer.

  2. In Waterfall Setup, select a rule, and then click Create button to create a new rule or Edit button to edit an existing rule.

    • For allocation rules, select the Source/Destination tab, and then click Ellipses button next to either Source or Destination to access the Dimension Member Editor.

    • For custom rules, select the Target tab, and then click Ellipses button next to Target Dimensions to access the Dimension Member Editor.

  3. In the Dimension Member Editor, copy and paste dimension-member combinations using the following format:

    "DimensionName", "MemberName"

    Use one row per member. You can include combinations for multiple dimensions in the same box. When entries are complete, click OK.

    If you try to input a dimension or member that does not exist or one that is not available for that tab, an error message is displayed.

  4. Click OK to close the Dimension Member Editor.