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

ERROR 16020 |-- Anaplan API: Invalid key path
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…