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 any way I can give individual mappings of the base members instead of copying parent data.

For example :Suppose BGBAL and EBAL are base members of F#SF_Movement.

Map F#BGBAL in source Dimension to  F#BegBal in Destination

Map #EBAL in Source Dimension to  F#EndBal. in Destination

Is such data mapping possible ?.

Thanks for the help.

 

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.