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

DATA COPY ISSUE Summary

in Financial Consolidation and Close 8 comments

Requirement: As per the client requirement we need to copy from aggregated parent members to base level stat members for 4 dimension(Account, Profit Center, Functional Area and Product.)

Options we tried-

  1. Currently we have created one integration in DM which is able to copy it to the target for 3 dimensions(Account,Profit Center,Funcitonal Area) within 30 seconds(Source is having 497000(125*71*56) combinations
  2. When we are including product then the integration is taking more than 45 mins to copy to target as the source combinations are becoming 20874000(125*71*56*42)
  3. We have explored using Groovy Gridbuilder but it will give an error that the source intersection has more than 5 million blocks. Even if possible to use groovy with workarounds, we believe that it may still end up taking a lot of time since it still needs to access 20874000 intersections.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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