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 13-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 Dimension

    Select a Smart List dimension.

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

    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.