Skip to main content
K
Kashinath
July 19, 2024

Copy Data between cubes with different Entity Dimensions

  • July 19, 2024
  • 2 replies
  • 3 views

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.

2 replies

S
SimonHesford
July 19, 2024

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
T_Kress
July 19, 2024

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!

S
SimonHesford
July 19, 2024

Totally agree 🙂

Terms & ConditionsAccessibility statement