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

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!