Moving Data to a Reporting Cube

After setting up data maps, you can move data to a reporting cube. Planning validates the selected data maps, and then moves the mapped Planning dimension data to the reporting cube dimensions. You can also check the Job for the job status.

Note:

If you enabled parent members for dynamic children in both a block storage and aggregate storage cube and added a dynamic member, you can use Push Data to successfully move data from the block storage to the aggregate storage cube without refreshing the database. See Synchronizing Smart Lists in Reporting Applications.

To move data to a reporting cube:

  1. Create the reporting cube.
  2. Create the data map.
  3. Click Application, then Data Exchange, and then click Data Maps.
  4. To the right of the data map, click Action icon, and then select Push Data.

    Confirm whether you want to clear the data before moving it:

    • Click No to add the new data to the existing data in the reporting cube. No data is cleared from the target cube when you use this option.

      If you map Smart Lists to dimensions, Smart List labels must match either member names or aliases in the reporting cube. Push Data doesn't work with Smart List entry names.

    • Click Yes to clear the data in the target cube before moving data to it.

      When the target is an aggregate storage reporting cube, note the following when clearing and moving data:

      • Members with nonmatching names in the target reporting cube are ignored.

      • This option works only with member names, not with member aliases.

      • Use caution when using member relationships (such as Children) when selecting members for the data map, because using this option can cause the calculation script to exceed its length limit.

      • If you use member relationships, this option expands the level 0 member list in the source Planning cube. If at least one member name in the source cube matches a member in the reporting cube, this option proceeds without error. If at least one member doesn't match, the option can't proceed.

      When the target is a block storage reporting cube, to proceed successfully, clearing and moving data requires these conditions:

      • If you use member relationships, all member names in the source cube must match all member names in the reporting cube.

      • If you map Smart Lists to dimensions, all Smart List entries in the source cube must match all member names in the reporting cube.

      • If you map Smart Lists to dimensions, the Smart List entry label in the source Planning cube must match the member name in the reporting cube. If a Smart List entry label doesn't match a member name in the reporting cube, then the Smart List entry name must match the reporting cube member name.

      If the previous conditions are not met, the clearing and moving data operation can't proceed.