07-17-2024 07:09 AM
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.
Solved! Go to Solution.
07-17-2024 01:16 PM - edited 07-17-2024 01:26 PM
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 🙂
07-17-2024 01:16 PM - edited 07-17-2024 01:26 PM
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 🙂
07-18-2024 11:31 AM - edited 07-18-2024 11:32 AM
Hi @sameburn ,
thanks , it is working as expected. I have some other doubts related to this.
Thanks a lot for the Help
07-19-2024 02:35 AM
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.