Optimizer OR

FabianEbner · 2025-02-07T10:42:46+00:00

There was an error rendering this rich post.

Dear Community,

is there a possibilitly to use the logical OR in a constraint for the optimizer? I am trying to compare a variable to a constant. The constraint should default to TRUE if the varible equals zero or is the variable equals the constant. I came up with a non-linar equation (x * (x-y) = 0), but I do not know how to convert it for a linar contraint.

Thanks for your help!

Accepted answers

devrathahuja

Hi @FabianEbner ,
You can create it as follows-

The C3 takes care of either empty or full truck. V2 in the optimizer action should be set to Binary as 0/1. Here's the output-

So demand is 1500, Capacity is 1800 but since truck 3 is 600 we have that empty & it can max serve 1200 of demand only.

Hope this helps!😊

All comments

devrathahuja

Hello @FabianEbner,
Constraints can only have the 3 operators mentioned (< =, =, > =)

The constraint mentioned by you can have infinite solutions where x=0, may I check what is the use case that you're trying to solve for here?

FabianEbner

Hello,

thanks for the answer. I am working on a demo use case to optimize shipments. In my simple example, I want to allocate products into trucks. Trucks should only drive if they are at maximum capacity, but to find a solution it needs to be possible for some trucks not to drive. So I need a constraint, which says that the product inside a truck has to be equal to the maximum capacity, or to zero. The objective function tries to maximize the amount of product shipped.

devrathahuja

Hi @FabianEbner ,
You can create it as follows-

The C3 takes care of either empty or full truck. V2 in the optimizer action should be set to Binary as 0/1. Here's the output-

So demand is 1500, Capacity is 1800 but since truck 3 is 600 we have that empty & it can max serve 1200 of demand only.

Hope this helps!😊

FabianEbner

Thank you for your great expanation. This makes a lot of sense and was very helpful!

Quick Links

Can you help?

Unanswered questions

Actuals and Forecast input in same module
Hi community, I am going through something as below. I have a module inp01 which I want to use for end user input for forecast. In the same modules I have actuals periods and forecast periods. Users want to see actuals when entering forecast. This means I need to pull actual from a module dat01 into this input module and…
Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…
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…