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. Running a Data Map

Running a Data Map

Data maps run automatically in the following situations:

  • If the source is a model and you associated the data map with the model and selected Run on Check-In, when you make a change to the model and check it in, the data map runs and Smart Push pushes the data to Planning.

  • If the Target is a model, and the target has an associated a data map with the Run on option of Data Map Import or Check In, when the first data map completes, the data map associated with the Target model runs. (Importing the data implicitly checks in the model.)

    For example: When a model is checked in, and this model has a data map associated with it that pushes data to another model that has a data map associated with it that has the option Data Map Import or Check In, that data map will run after the first data map completes, without having to open the second model:

    • Model 1 has data map 1 associated with it that pushes data from Model 1 to Model 2, with the Run On option Data Map Import or Check In or Check In.

    • Model 2 has data map 2 associated with it that pushes data from Model 2 to Model 3, with the Run On option Data Map import or Check In.

      Data map 2 runs after Model 1 is checked in.

    • Model 3 has data map 3 associated with it that pushes data from Model 3 to a Planning cube (BSO or ASO), with the Run On option Data Map Import or Check In.

      Data map 3 runs after data map 2 is finished.

  • If the source is a scenario rollup and you associated the data map with the scenario rollup and selected Run on Rollup, in Scenario Rollups, click Run. On the Run Rollup and Data Maps page, select Refresh and/or Publish to run data maps associated with those phases. Before and After data maps run automatically.

    If you mapped the Business Case in Strategic Modeling to Scenario and Version in Planning, when you run the scenario rollup, you have the option to select Overwrite Target Version, which overwrites the Version defined in the data map.

    If Version is in the Unmapped section, the selected Overwrite Target Version is ignored.

  • If the source is a Planning cube, associate the data map with a form and specify it to Run on Save. See Configuring Smart Push for a Form. You can associate multiple data maps with a single form.

If the source is a model or a Planning cube, you can also run data maps from the Data Maps page: From the Home page, click Application, then Data Exchange, and then click Data Maps. From the Actions menu for the data map you want to run, select Clear and Push Data.

Note:

The Clear and Push Data option is unavailable for Planning to Strategic Modeling scenario rollups.

To check the status of the data map and Smart Push job, from the Home page, click Application, and then click Jobs. Click the job name to see information and status about the Smart Push job. If there is an error, click Error to see details to help you resolve the error. For more information about data maps and Smart Push jobs, see Checking Real Time Progress Status for Data Maps and Smart Push in Administering Data Integration for Oracle Enterprise Performance Management Cloud.

Note:

Data maps that push data from Planning to multiple Strategic Modeling models and have missing accounts in the target will be ignored and the data will be pushed for all valid accounts. The job details will provide a listing of dimension members that were ignored because they weren't available in the target model.