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. Data Maps and Smart Push Performance

Data Maps and Smart Push Performance

If the data map push or Smart Push is taking more time than expected to process, check if there are any dynamic calc members as part of the selection. If the data from these dynamic calc members is not required to be moved to the target, add the dynamic calc members to exclude the selection.

If the dynamic calc member data has to be pushed, check if the formula has cross dimensional members and are included in @ISMBR function These formulas has to be rewritten by avoiding the @ISMBR function to improve the performance.