DATA COPY ISSUE Summary
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-
- 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
- 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)
- 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:
0