1. Administering Planning
  2. Setting up Strategic Modeling
  3. Pushing Data Between Strategic Modeling and Planning
  4. Pushing Data Between Strategic Modeling and Planning Using Data Maps
  5. Defining Strategic Modeling Data Map Options

Defining Strategic Modeling Data Map Options

Specify data map options that apply to Strategic Modeling data maps.

Note:

For Planning data map options, see Defining Data Map Options in Administering Data Integration for Oracle Enterprise Performance Management Cloud.

  1. View the Data Maps listing page.

  2. Select an existing data map or click Create to create a new one.

  3. Click Options (or if creating a new data map, click Actions, and then click Options).

  4. Specify data map options, and then click OK.

Table 7-2 Strategic Modeling Data Map Options

Data Map Option Description

Import #missing value as

(Only available for data maps where Planning is the source and Strategic Modeling is the target)

  • Ignore: Ignores the imported #missing value and retains the existing value in the target cell.

  • Zero As Output (default): Imports the #missing values and sets their output value to 0 in the target cells.
  • NaN: Imports the #missing values and sets their output value to NaN (Not a Number) in the target cells.
  • Zero As Input: Sets the input cell to 0, no back calculation required.

Import NaN value as

(Only available for data maps where Strategic Modeling is both the source and the target)

  • Ignore: Ignores the imported NaN value and retains the existing value in the target cell.
  • Zero As Output (default): Imports the NaN value and sets the output value to 0 in the target cells.
  • NaN: Imports the NaN values and sets their output value to NaN in the target cells.
  • Zero As Input: Sets the input cell to 0, no back calculation required.

For cells that are not being imported
  • Preserve Input Values(default): Preserves the existing input data values in the model during the data import
  • Preserve Output Values: Preserves the existing output data values in the model during the data import

Push data for mapped custom dimension root

When the mapping contains both the parent and child members of the custom dimension, this option pushes the data for the custom dimension root to the target.