I created one custom entity for importing data and write a custom method for create default dimension for corresponding imported finance dimension values.Here my problem is that where i can call this method.
private int generateDefaultDimension() { DimensionAttributeValueSetStorage valueSetStorage = new DimensionAttributeValueSetStorage(); DimensionDefault result; int i; DimensionAttribute dimensionAttribute; DimensionAttributeValue dimensionAttributeValue; SalesTable salesTable; SalesLine salesLine; str dimValue; IMPDSalesLineStaging salesLineStaging; container conDim; select firstonly salesLineStaging where salesLineStaging.SalesId == this.SalesId && salesLineStaging.ItemId == this.ItemId; container conAttr = ["cashFlow", "department", "Doctor_Technician","Family","Section","Type","Unit","Worker"]; container conValue = [ salesLineStaging.CashFlow,salesLineStaging.Department,salesLineStaging.Doctor_Technician,salesLineStaging.Family,salesLineStaging.Section,salesLineStaging.Type,salesLineStaging.Unit,salesLineStaging.Worker]; //container conValue = [this.CashFlow,this.Department,this.Doctor_Technician,this.Family,this.Section,this.Type,this.Unit,this.Worker]; for (i = 1; i <= conLen(conAttr); i ) { dimensionAttribute = dimensionAttribute::findByName(conPeek(conAttr,i)); if (dimensionAttribute.RecId == 0) { continue; } dimValue = conPeek(conValue,i); if (dimValue != "") { dimensionAttributeValue = dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue,false,true); valueSetStorage.addItem(dimensionAttributeValue); } } result = valueSetStorage.save(); return result; }
Hi, I have done same requirement few years ago and called the method in mapEntityToDatasource method of data entity.
Please check code I shared in below thread and call your method. Let us know if any issues.
community.dynamics.com/.../modified-field-in-entity-not-working
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156