11-20-2023
12:12 PM
- last edited on
11-28-2023
02:18 PM
by
JackLacava
Hi, I'm having trouble running a relatively simple Copy Data data management step.
The step's source and destinations share the same cube, entity, time period, and view. They differ only on scenario. The step copies all of the imported, forms and adjustment data. There is data at the specified intersections (cube-scenario-time-entity-view) in the source. However, when I review the destination , I do not see any data copied to the destination.
What else should I be checking to ensure that my Copy Data step works?
Thanks!
11-20-2023 12:20 PM
Hello,
Maybe you're using horizontal extensibility by scenario ? Also, the native 'Copy Data' step is relatively slow. You should opt for a Finance Business Rule to do so
Here's a snippet:
Dim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("")
Dim sourceDataBuffer As DataBuffer = api.Data.GetDataBuffer(DataApiScriptMethodType.Calculate,"S#<Source Scenario>",destinationInfo)
Dim targetDataBuffer As DataBuffer = api.Data.ConvertDataBufferExtendedMembers("<Cube Name>", "<Source Scenario>", sourceDataBuffer)
api.Data.SetDataBuffer(targetDataBuffer, destinationInfo,,,,,,,,,,,,,True)