1. Administering Profitability and Cost Management
  2. Working with Profitability and Cost Management Rules
  3. Creating and Managing Rules with the Manage Rules Screen
  4. Creating Allocation Rules with the Manage Rules Screen
  5. Defining a Source for Allocation Rules
  6. Adding Dimension-Member Combinations by Pasting Text

Adding Dimension-Member Combinations by Pasting Text

You can now paste dimension-member combinations from Microsoft Excel into the Dimensions area of the following Rule Definition screen tabs: Source, Destination, and Driver Basis. This feature 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 (Viewing, Creating, and Editing Dimensions with Dimension Management).

To use this feature, click Text Entry in the Dimensions area. Then, copy and paste dimension-member combinations for that tab into the Dimension Member Editor box 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.

Note:

You must use the Member Selection area to remove dimension-member combinations created by pasting.