DimensionAttributeValueSetStorage.addItemValues error

(0) Share

Report

Posted on by waytod365

351

Hi all,

I have a parameter form lookup [Business unit, costCenter, project,,,,,,

 DimensionDefault DimensionVlaueName()
    {
        DimensionAttributeValueSetStorage   valueSetStorage = new DimensionAttributeValueSetStorage();
        DimensionDefault                    result;
        DimensionAttributeValueSet      dimAttrValueSet;
        DimensionAttributeValueSetItem  dimAttrValueSetItem;
        DimensionAttributeValue         dimAttrValue;
        Description255                  backingname, dimensionValueName;
        ;

        dimAttrValueSet = DimensionAttributeValueSet::find(ProjTable::find(this.ProjId).DefaultDimension);

        while select  DimensionAttributeValue from dimAttrValueSetItem
        where  dimAttrValueSetItem.DimensionAttributeValueSet   == dimAttrValueSet.RecId
        {
            backingname     = DimensionAttribute::find(DimensionAttributeValue::find(dimAttrValueSetItem.DimensionAttributeValue).DimensionAttribute).Name;
            dimAttrValue    = DimensionAttributeValue::find(dimAttrValueSetItem.DimensionAttributeValue);

            if(backingname == LIParameters::find().Branch) //description of the financial dimension
            {
                valueSetStorage.addItem(dimAttrValue);
            }
        }

        result = valueSetStorage.save();

        return result;
    }

As i mentioned above code mergedimension, its come as expected value but, getting error after update value.

Error :

Function DimensionAttributeValueSetStorage.addItemValues has been incorrectly called.

How to resolve this error.

Thanks

I have the same question (0)

All responses (18)

Answers (2)

Suggested answer

GirishS 27,827 Moderator on at

Like (1)

Report

Hi waytod365,

This error will be thrown when "DimensionAttrtibute" value RecId returning 0. So from your code dimAttrValue.DimensionAttribute is 0.

Refer to the class DimensionAttributeValueSetStorage - additem() - Inside addItem() method they will be calling addItemValues - On the addItemValues method you can see if dimAttrValue.DimensionAttribute is equal to 0 then the above error will be thrown.

Thanks,

Girish S.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks for your replay Girish S,

As you mentioned addItem() how to overcome if not equal zero ? would be great if you could example.

Thanks

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

Can you explain me the functionality you are doing?

Thanks,

Girish S.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks , I have a custom form and project id field has relation with a ProjTable.

Parameter form : Lookup [BusinesUnit, CostCenter, Project, Worker, ItemGroup]

Based on a parameter description(lookup) i want to update my custom dimension.

Etc : If i select parameter form costCenter then in my custom i select it project id : 00002. (00002 against costCenter there in project table then update to costcenter in my custom dimension ). so that what to be done?

Thanks

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report
So the code should look something like below. Check if its work for your scenario.

DimensionAttributeValueSetStorage valueSetStorage = new DimensionAttributeValueSetStorage(); DimensionDefault result; DimensionAttributeValueSet dimAttrValueSet; DimensionAttributeValueSetItem dimAttrValueSetItem; DimensionAttributeValue dimAttrValue,dimAttrValue1; Description255 backingname, dimensionValueName; DimensionAttribute attribute; dimAttrValueSet = DimensionAttributeValueSet::find(ProjTable::find(this.ProjId).DefaultDimension); //get the DimensionAttribute from the parameer form. select * from attribute where attribute.Name == paramterControl.value(); while select DimensionAttributeValue from dimAttrValueSetItem where dimAttrValueSetItem.DimensionAttributeValueSet == dimAttrValueSet.RecId { //backingname = DimensionAttribute::find(DimensionAttributeValue::find(dimAttrValueSetItem.DimensionAttributeValue).DimensionAttribute).Name; //get the current dimension value. dimAttrValue = DimensionAttributeValue::find(dimAttrValueSetItem.DimensionAttributeValue); //get the new dimension value based on the dimension attribute(Cost centre, Business unit etc). dimAttrValue1= DimensionAttributeValue::findByDimensionAttributeAndValue(attribute, dimAttrValue.DisplayValue,false,true)); if(backingname == LIParameters::find().Branch) //description of the financial dimension { valueSetStorage.addItem(dimAttrValue1); } } result = valueSetStorage.save(); return result;

Thanks,

Girish S.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks for your answer ,

I tried above your code but, its getting error when i select project id and parameter form i set BusinessUnit.

error :

Unable to return DimensionAttributeValue record for Dimension BusinessUnit with value 011 as no record exists in table OMOperatingUnit through view DimAttributeOMBusinessUnit.

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report

I think you need to check the requirement with functional. I will explain you the issue when you are updating "DimensionAttribute" name for the Project.

Lets assume you have project "Project A" with dimension value like - Dimension attribute name : "Business unit" - Display value : "086".

Now you have given "CostCenter" in parameter form - On the custom form you are giving "Project A".

As per your code it will check in "DimensionAttriuteValue" table with DimensionAttribute as "CostCenter" and display value as "086". There wont be any such combination in DimensionAttributeValue table.

Refer to the form for financial dimension setup - General Ledger >> Charts of accounts >> Dimension >> Financial dimension. On this form you will see all the Dimension attribute names with the display values. Select one dimension name and click on "Dimension value" from action pane - So only values available in the form will be used against the dimension name.

Also the dimension values will be auto - populated in the above form from navigation path Organization administration >> Organizations >> Operation unit. Restriction will be you can create display value with value 086 only once. Already 086 value is assigned to "Business unit" .So you cannot create one more record with 086 and assign it to "CostCenter".

I guess you need to check these requirement with functional and explain about the issue for updating dimension attribute name.

Hope its clear.

Thanks,

Girish S.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Thanks for your valuable suggestion girish,

I understood, what is your point of view in it. ? an alternative way ?

Thanks

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Okay then, My suggestion will be, In the parameter form add a field "Display value" below the Dimension attribute name.

Lookup of the display value will show only values related to the Dimension attribute name. Suppose you have selected "Cost center" then Display value lookup will show only the values that belongs to "Cost center". This way you can restrict user to select only display values that are available in the "DimensionAttributeValue" table.

Later based on the selection you can create new dimension value combination using "DimensionAttributeValueSetStorage" class and update the values against the project id.

Thanks,

Girish S.

Was this reply helpful? Yes No
waytod365 351 on at

Like (0)

Report

Okay thanks, i can give it to display name against display value. then as you mentioned your code anything need to change if so, give me as well.

Thanks

Was this reply helpful? Yes No

Join the conversation

Community site session details

DimensionAttributeValueSetStorage.addItemValues error

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

DimensionAttributeValueSetStorage.addItemValues error

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates