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
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.
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 –
The blue print view for the constraint is as below –
The blue print view for PP_Optimization module is as below –
The action configuration is as below –
@samaplanThanks for your inputs. These are really helpful.
Sourabh Kulkarni
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
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…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…