Forum Discussion

Kashinath's avatar
Kashinath
New Contributor II
6 months ago

Data Buffer Mapping Related issues

Hi Community. I have a rule that is using DataBuffer to copy data from 1 cube to another.The cubes have seperate dimensions. I have used DataBufferConvMapItems to map individual base dimensions . B...
Finance
TheJonG's avatar
TheJonG
Contributor III
5 months ago

Hi - so I am having a bit of trouble following what the main issue is - is the Convert Data Buffer not working AND the UD5 is not copying correctly? 

Are you getting the error after the Convert Data Buffer or on the Set Data Buffer? Is E#190 within the dimension that is assigned to the Finance Cube?

For the UD5#Top to UD5#None conversion, you could do this fairly easily by moving UD5#Top to the source data buffer script which would move it to the common members and then change the common members to None. You could also do this by specifying UD5#None is the DestinationInfo script.

Dim sourceBuff As DataBuffer = api.Data.GetDataBufferUsingFormula($"FilterMembers(Cb#Sales:S#Actual:U5#Top)",DataApiScriptMethodType.Calculate,True,DestinationInfoNone)

					Dim dcPK As DataBufferCellPk = sourceBuff.CommonDataBufferCellPk
					dcPk.UD5Id = DimConstants.None				
					sourceBuff.CommonDataBufferCellPk.Equals(dcPK)