Is performance affected by using multidimension mapping for all dimensions in EPM Data Management? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is performance affected by using multidimension mapping for all dimensions in EPM Data Management?

in Financial Consolidation and Close 2 comments

Summary:

Hello Oracle Experts,

We are loading data from a source file with 4 columns (like Account, Entity, Cost Center, Department, Location).
In our Data Management setup, all target dimensions are using multidimension mapping (except Entity) based on above combinations of 3-dimension columns.

We notice that the data load is slower, especially during the import and validation steps.

Question: Can someone help with below

  1. Does using multidimension mapping for every dimension will it slow down performance?
  2. Is there any limitation of using Multidim or best practice for using these mappings?
  3. Any way to find which mapping is causing the slowdown to load the data into target?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!