1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Defining Data Maps
  3. Moving Data
  4. Moving Data from One Cube to Another Cube Using Smart Push
  5. Viewing the Smart Push Status
  6. Identifying Smart Push Intersections with Unrecognized Smart List Values

Identifying Smart Push Intersections with Unrecognized Smart List Values

When Smart Push fails with the message "Unrecognized Smart List Value," you can identify the intersections with the invalid Smart List intersections by creating a data form.

To identify intersections with the unrecognized Smart List values:

  1. Create a data form with a definition the same as the Smart Push definition for all the dimensions except for the smart list/pivot dimension.

  2. For the Smart List dimension only, add the Smart List members which are used in the data map to define a Smart List to dimension mapping.

  3. Include the Smart List dimension as a column dimension in the data form.

  4. All the dimensions which have only a single member as per the Smart List definition need to be part of the POV or page dimensions.

    Include all other dimensions in rows.

  5. Save the form definition.

  6. Open the data form and look for cells where the value is defined as a number instead of a Smart List value. These are the intersections with unrecognized Smart List values.