Forum Discussion

Kashinath's avatar
Kashinath
New Contributor II
6 months ago

Mapping Individual members using Data Buffer while copying data.

Hi Community, I have a rule that is using DataBuffer to copy data from 1 cube to another. The 2 cubes use separate Flow Dimensions . right now I have given in the following way : Is there ...
Finance
  • sameburn's avatar
    sameburn
    6 months ago

    Hi Kashinath this is possible with the method you are using. However you need to add each base member line individually e.g you need to map two separate DataBufferConvMapItems to your DataBufferConvDimInfo collection. E.g instead of F#SF_Movement.Base replace it with F#BGBAL and F#EBAL as source member filter(s) and replace F#None with F#BegBal for your destination member filter on both lines.

    You can do this using dataBufferConvDimInfo.Add() for each DataBufferConvMapItem

    Then you use the ConvertDataBuffer api to convert the data buffer from source to target, as desired.

    That should resolve your issue. Log the buffer and check results 🙂

sameburn's avatar
sameburn
Contributor II
6 months ago

Hi Kashinath this is possible with the method you are using. However you need to add each base member line individually e.g you need to map two separate DataBufferConvMapItems to your DataBufferConvDimInfo collection. E.g instead of F#SF_Movement.Base replace it with F#BGBAL and F#EBAL as source member filter(s) and replace F#None with F#BegBal for your destination member filter on both lines.

You can do this using dataBufferConvDimInfo.Add() for each DataBufferConvMapItem

Then you use the ConvertDataBuffer api to convert the data buffer from source to target, as desired.

That should resolve your issue. Log the buffer and check results 🙂

  • Kashinath's avatar
    Kashinath
    New Contributor II
    6 months ago

    Hi sameburn ,

    thanks , it is working as expected. I have some other doubts related to this.

    • If I am mapping a dimension  -  take Flow for Example using   DataBufferConvMapItem, do I need to mention this dimension in the Source and Destination Data buffer?.
    • If I have multiple dimensions where this individual mapping needs to be done, Is the below code correct or any changes need to be done ?.

     

    • In the below case where I am adding mapping for all UD Dimensions . Is the code correct .? Do I need to mention the UD Dimensions again in the Source and Destination Buffer.

    Thanks a lot for the Help

    • sameburn's avatar
      sameburn
      Contributor II
      6 months ago

      Hi Kashinath 

      I am pleased we resolved your issue. For your additional use cases, please test these methodically by logging the source and target buffer(s) to confirm you've got expected results for your dataset(s). Without your data model it's quite difficult to fully understand your use case based on your screenshots.