Optimizer Error message

Hi,

I am building a small optimization model, I am getting "Constraint does not exist" error message. I am not able to identify why I am getting this error. can anyone please help?

Thanks,

Sourabh

Accepted answers

samaplan

This error was generated because a line item referenced in the constraint referenced multiple levels of non-dimensionalized line items. Optimizer works best when relationships are defined in lists and parent hierarchies with dependencies limited to one level removed. Modeling with parent hierarchies and lists items will allow your input line items to be defined by simpler formulas -- let Anaplan do the work!

You can troubleshoot this error by temporarily removing the formula from the line item and running the Optimizer action. If Optimizer is then able to solve the problem, the issue can be isolated to that line item and you can look at simplifying/flattening its formula.

In our case, a second error came up in how the syntax of a constraint was phrased. After changing the syntax, the Optimizer ran successfully.

All comments

sourabhvk

I am developing a small production optimization model. I am getting following error.

Can anyone please help me to resolve it?

My model details are as below -

My objective function is to maximize the profit. Profit is calculated as Total Price – Total Cost. Price is assigned to End items while the Cost is assigned to Components.

The production plan is constrained by work center capacity. Apart from capacity following are other constraints –

End Product Production Quantity Constraint - PP_Optimization.No of End Items <= End Product Demand.demand
Component Production Quantity Constraint - PP_Optimization.No of Components - 1 * PP_Optimization.Total Component Demand = 0

The blue print view for the constraint is as below –

The blue print view for PP_Optimization module is as below – Optmization module.png

The action configuration is as below –

Action configuration.png

samaplan

In our case, a second error came up in how the syntax of a constraint was phrased. After changing the syntax, the Optimizer ran successfully.

sourabhvk

@samaplanThanks for your inputs. These are really helpful.

Thanks,

Sourabh Kulkarni

manas.malhotra@in.ey.com

I have faced lot of such issue and realized that if we do complex calculation and use output in the constraints creation , was getting the issue you specified.

Best is keep all the variable on side of the equaiton and all the constants on other side,

such issue would not appear

Regards

Manas Malhotra

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…