1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Defining Data Maps
  3. Managing Data Maps
  4. Defining Data Map Options

Defining Data Map Options

To define data map options:

  1. View the Data Maps listing page.
  2. Click an existing data map.
  3. Click Options.

    Table 10-1 Data Map Options

    Data Map Option Description

    Select Items to Copy

    Select the items for which you want to copy the corresponding relational data. You can copy:

    • Comments and Attachments

      If you select Collate, then:

      • If there is one-to-one mapping between the source cells and the target cells, then Comments and Attachments are copied from the source cells to the target cells.

      • If there isn’t a one-to-one mapping between the source cells and the target cells, then the Comments and Attachments from the source cells are combined and saved in the corresponding target cells.

      If you do not select Collate, then:

      • If there is one-to-one mapping between the source cells and the target cells, then Comments and Attachments are copied from the source cells to the target cells.

      • If there isn't a one-to-one mapping between the source cells and the target cells, then last source cell's Comments and Attachments are copied into the corresponding target cell. "Last source cell" means the last source cell among multiple source cells that has non-empty relational data.

    • Supporting Detail

      • If there is a one-to-one mapping between the source cells and the target cells, then the Supporting details are copied from the source cells to the target cells.

      • If there isn't a one-to-one mapping between the source cells and target cells, then the Supporting details are not copied to the target cells.

    Note that the relational data (Comments and Attachments and Supporting Detail) selected to be copied in the Data Map Options dialog box applies only to moving data using Smart Push. See Moving Data.

    Smart List/Pivot Dimension

    Select a Smart List dimension or pivot dimension.

    Note that only dense dimensions are allowed for Smart List dimension selection.

    Pivoting a dimension changes the orientation of data on the grid so you can view data from another angle, or slice and dice information. Enterprise Profitability and Cost Management can only select the dimension shown in the Smart List/Pivot Dimension drop-down list. For more information about pivoting dimensions in Enterprise Profitability and Cost Management, see Pivoting Dimensions in Administering and Working with Enterprise Profitability and Cost Management.

    Exclude Dynamic Calc Members

    Select if you don't want to move the dynamically calculated member data during the data map process.

    Note that Exclude Dynamic Calc Members is supported for data map push only and not for Smart Push.

    Allow Smart Push Simultaneously

    Allows data map and Smart Push processes to run at the same time. Click Yes to enable this option.

    See Running Data Mapping and Smart Push Processes Simultaneously.

    Prioritize Smart List Entry Names When Moving Data

    Requires the data map or Smart Push operation to use the Smart List entry name instead of the member alias in cases where the target cube has duplicate aliases.

    Smart List entry names cannot have spaces or special characters. If the Smart List is defined using a function and if the members have spaces, those spaces are converted to underscore. Due to this restriction, the Smart List entry name might not be used. When this option is selected, the system checks for the member based on the entry name, and if there are no members matching the entry name, the Smart List entry label is used to fetch the member.

    For intersections where the Smart List value isn't defined, the Smart Push and data map operations will use the missing label defined for the Smart List to push the data.

    If this option is not enabled and the data push or Smart Push operation detects duplicate aliases in the target cube, the operation will complete with warnings and the job details will prompt you to either remove the duplicate aliases (duplicated aliases are provided in the message) or select this data map option.

    Import #missing value as

    (only 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 for data maps where Strategic Modeling is the source and Planning is 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 (Strategic Modeling only)

    • 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.

    Suppress Missing Columns for Smart Push

    Enable this option to suppress missing columns from the source grid while performing a Smart Push.

    Disable this option to include missing columns in the Smart Push.