Copy Data between cubes with different Entity Dimensions

Kashinath
New Contributor II

Hi,

I need to copy data between 2 cubes . they both use different Entity Dimensions . Not Extended ones.so is there any way I can map the entities . I am using customcalculate DM with the Destination Data Units  to run finance rule.

I have given the Source Entity and destination Entity in the Corresponding DataBuffers.

Kashinath_1-1721381573699.png

But when I give  api.Data.ConvertDataBuffer("sourceCube","SourceScenario", databufferConvInfo, sourceDataBuffer). I am getting Error Saying "the Cube and Entity Are invalid or Incompatible".

What is the issue ?

Thanks.

3 REPLIES 3

SH_INT
Contributor

Does the Entity you are trying to copy data to exist in the Target cube? The error message would suggest not so check that out first

T_Kress
Contributor III

I have always used a DM export step, tied to a data source and then a WF to move data between cubes because then you can map the Ux in one cube to Entity in another cube via transformation rules and the data source.  I find it more transparent than a data buffer. But there is always more than one way to tackle the problem in OS!

Teresa C. Kress
Principal Delivery Manager Partner Enablement | OneStream Software

Totally agree 🙂