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

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…