Forum Discussion

Kashinath's avatar
Kashinath
New Contributor II
6 months ago

Copy Data between cubes with different Entity Dimensions

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.

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.

Finance
  • T_Kress's avatar
    T_Kress
    Contributor III
    6 months ago

    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!

  • SimonHesford's avatar
    SimonHesford
    Contributor
    6 months ago

    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