Skip to main content
Kashinath
Newcomer
Jul 19, 2024 9:33 AM UTC

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.

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

SimonHesford
Member
Jul 19, 2024 12:22 PM UTC

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
T_Kress
Contributor
Jul 19, 2024 1:07 PM UTC

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
    Member
    Jul 19, 2024 1:39 PM UTC

    Totally agree 🙂

    Terms & ConditionsAccessibility statement