Skip to main content

AIMMS Language

Topics about getting started or leveling up as an AIMMS developer.

  • 662 Topics
  • 1,451 Replies
662 Topics
M
MZwanenburg
asked in AIMMS Language
Read data Excel in an order

Hi all, I want to read data from Excel but it should be sorted customly. In Excel the data is like this:  The result in AIMMS should be this:  I can create this with a text join in Excel and paste the value in the data field in AIMMS but the data changes frequently so I want to automate this with AXLL functions. It is important that the order of a, b and c holds.  Does anyone have an idea to do this? 

592
M
1 year ago
V
ValqueEnthusiast
asked in AIMMS Language
set and subset in the index domain

Hi community!I have a problem about a formulation and I am looking for help!I have defined a set “Input” index i, and two subsets “input1d” index id and “input1s” index is. Here is my formulation of a constraint:Identifier : MassConservation12Index domain : (i,id,is,r)Definition : sum(t, S1(i,t,r))+Stock1(i,r-1)=sum(d, Y1(id,d,r))+sum(s, uu1(is,s,r))+Stock1(i,r)+ZZ1(id,r) Should I modify the index domain in order to make clear that id and is are subsets of i? Thank you!

712
V
1 year ago
C
CarlosOnlineExplorer
posted in AIMMS Language
Export to .aimmspack from Azure DevOps pipeline

Is it possible to export an AIMMS model to .aimmspack file from Azure Devops Pipeline?Goal is to generate the .aimmspack file from the Azure Devops Pipeline after the model source files have changed.  I was hoping to run aimms.exe --export-to without have a user signed in, or storing the private license files in a public place.From Documentation:Through the --export-to option you can instruct Aimms to create an encrypted end-user project either packed to the .aimmspack file specified, or unpacked into a specified folder. When using this commandline option, Aimms will use the export settings as saved by the previous call to the File-Export End-User Project menu. You can use this commandline option, for instance, within the context of a continuous integration server, to automate the deployment of your Aimms application after new commits have been pushed to the version control repository managing the project. Specifying the unpack folder When running an .aimmspack file, Aimms will ask for

3299
luispinto
Administrator
1 year ago
luispinto
Administrator
luispintoCustomer Success Manager
published in AIMMS Language
Publishing, Running and Deleting apps on the CloudNews

I recently published a “how-to” article that provides an example of Python code that can be used to publish a project, run a specific task on it and delete the published project. Use case?“When using a CI/CD pipeline” you may want to test the app as follows: Publish Run scenario Cleanup (including removing the app)  https://how-to.aimms.com/Articles/571/571-publish-run-delete.html

290
luispinto
Administrator
1 year ago
luispinto
Administrator
luispintoCustomer Success Manager
published in AIMMS Language
How to setup a CI/CD pipeline with AIMMSNews

What is CI/CD?CI/CD introduces ongoing automation and continuous monitoring throughout the lifecycle of apps, from integration and testing phases to delivery and deployment. These are desirable characteristics to have in application development and can be implemented with the context of AIMMS. We recently published an article in our How-To describing the required steps to create a CI/CD pipeline for your AIMMS projects. We try to be as agnostic as possible in terms of platforms.Each pipeline can be setup in a way that better suits your companies needs, such as controlling when a new version is published in testing environment and when it will be published in production.  Check out the article here:https://how-to.aimms.com/Articles/571/571-ci-cd-guide.html

490
luispinto
Administrator
1 year ago
C
ChunyangEnthusiast
posted in AIMMS Language
How can I formulate multi-layer optimization?

Here is the problem:“k” is a parameter in optimization problem A, for a specific “k1”, we can get the optimum solution “S1” for problem “A”. Now I hope the solution “S” is closer to a specific solution “S*”, so I will need to change the “k” to minimize |S-S*|. How can I formulate this double-layer problem in AIMMS?

404
C
1 year ago
C
ChunyangEnthusiast
asked in AIMMS Language
Why I can't constrain the objective variable with inequality？

The objective variable is A(t) contains t = 1 to 24. The mathematical program is to maximize the sum of all the elements in A, i. e. Max sum(A(t)), t = 1 to 24. At the same time I hope to constrain the property of the objective variable that the standard deviation SD(A) is no larger than a constant “a”. So I defined a variable “SD(A) = standard deviation of A”. Then a constraint “SD(A) <= a”. When I run the program, it reminds me of “constraint programming constraints cannot be used in combination with real valued variables, only with integer valued variables, element valued variables, and activities. The real valued objective variable is an exception. The mathematical program has both constraint programming constraints and real valued variables.” However, when I revise the constraint from inequality to equality, i.e. SD(A) = a. Then no error arises and I get the answer. Why dose this happen? And How can I deal with it if I want the inequality constraint?

672
C
1 year ago
MattC
MattCAce
asked in AIMMS Language
Hide Thousands Separators in Scalar Objects

Hello all!  Is there a way to hide thousands separators in WebUI? We want to have years displayed in a scalar widget (e.g. 2023), but currently, WebUI automatically adjusts this data (e.g. to 2,023).  Thank you in advance for your help!

321
gabiservidone
Administrator
1 year ago
C
ChunyangEnthusiast
asked in AIMMS Language
How can AIMMS solve different scenarios (initial data) at one run?

I want to run the model with different scenarios (data), can I import all the scenarios once and get the result for each scenario in one run?

934
C
1 year ago
C
ChunyangEnthusiast
asked in AIMMS Language
How can I use part of an index

 Like one day have 24 hours, I need to calculate the variables for 24 periods, but these variables are defined by 25 points, so I define the index t as “25”. For example variable A contains 24 elements, A(1) = B(2)-B(1)…...A(24)=B(25)-B(24).  If I define an index “t” as 25, I can simply define the B as B(t) using t (1 to 25) as the domain. But How can i define A which only contains 24 elements, actually from 1 to 24, can I use part of t domain from 1 to 24? 

332
C
1 year ago
W
waishengEnthusiast
posted in AIMMS Language
Vehicle Routing Problem on the Constraints

Good day, I am currently working a vehicle routing problem for the refinery simulation VRP. I am model runs without error but couldn’t give out the best solution. I would like to request for assistance upon this issue. Thank you.

373
gabiservidone
Administrator
1 year ago
Jess Es
Jess EsGrand Master
published in AIMMS Language
How to use a multi-objective approachHow-To

In this article we will compare a [b]multi[/b]-[b]objective[/b] approach to separately solving single objectives. Let’s take for an example a problem trying to find a healthy diet for a reasonable price. First let’s define our objectives: [list] [*]Minimize calories: I’m trying to lose some weight, so my healthy diet should be low in calories. [*]Minimize price: A reasonable price means that it doesn’t have to be the absolute minimum, but should be within a close range. [/list] Now, let’s use the [b]multi[/b]-[b]objective[/b] feature to solve. [url=https://how-to.aimms.com/Articles/276/276-multi-objective-approach.html]Read more...[/url]

1614
Gertjan
AIMMSian
1 year ago
Chris Kuip
AIMMSian
Chris KuipAIMMSian
posted in AIMMS Language
Dynamically assign value

I recently got the question, how to assign a value to a given parameter; for instance the end user enters the name of a configuration parameter and its new value. This question is similar to obtaining the value of an arbitrary identifier, and runtime libraries can be used to code this generically; see https://how-to.aimms.com/Articles/146/146-value-dynamic-identifier.htmlI created a small example model, whereby three parameters can be changed by naming them in the bottom scalar widget and entering a new value as illustrated below:Demo app after entering a value for AB987.Please find the demo app attached to this post.

340
Chris Kuip
AIMMSian
1 year ago
R
RwitamJEnthusiast
posted in AIMMS Language
How to use parallel solver session in a AIMMS project

We are trying to use multiple solver session to solve a large scale problem. We have taken the case of flow shop problem given in AIMMS. We are trying to change the “Number of parallel workers = 2/3/4”, but after solving it is resetting this value to 1 after solve and the solution time is also not improving. We have used the following for delegate to serverif not ProjectDeveloperMode then    if pro::DelegateToServer(timeout : 108000000,completionCallback:'pro::session::loadResultsCallBack', waitforcompletion:1) then        return;    endif;endif;Kindly help and let us know how to use multiple solver session for a large scale optimization problem. Thanks.

320
R
1 year ago
R
RwitamJEnthusiast
asked in AIMMS Language
How to represent a string parameter values in different lines in WebUI

I have a string parameter as per the following data```optimalfeasibleinfeasible```I would like to show it in the WebUI in the same way but it is coming as ```optimalfeasibleinfeasible```Kindly help. 

391
Madhu Krishnappa
AIMMSian
1 year ago
M
MarvExplorer
asked in AIMMS Language
summation over subset of an index

Hello everyone,I’m new in AIMMS and need help for my thesis. I need to implement the following constraints: t is an index for the period, here t = ( 1,2,3,…,T )How can i set the initial value from E(t=1) = Q How can I implement the E(T+1)  Thank you in advance kind regards  

961
gabiservidone
Administrator
1 year ago
M
mjinExplorer
asked in AIMMS Language
AIMMS Calendar (expressing hours)

I have a question regarding the calendar. We have an old app implemented based on calendar, in which the hours within a day are expressed as 00 ~ 23. But now we need to change it to 01 ~ 24. Please let us know what the easiest way to do it.

371
Chris Kuip
AIMMSian
1 year ago
Diego Perez-Urruti
AIMMS Partner
Diego Perez-UrrutiAIMMS Partner
asked in AIMMS Language
RegexReplace For On-Premise PRO path

Hi Community, I am trying to use the AIMMS RegexReplace function to trim the folder path and keep the data case name. It’s working fine locally but it’s not working when testing in the server.My code looks like this:        block ! Get the full path for the Active Case File            _sp_ActiveCasePathName := FormatString("%s", CaseFileURL(CurrentCase));            !Check for server vs local. Local path won't likely contain the string 'PRO:/PublicDta'            !example server path: PRO:/PublicData/Cases/spot_fw            _bp_IndicateLocalFileName := not (RegexSearch(_sp_ActiveCasePathName,         "PRO:\\\\PublicData"));            ! Text example _sp_ActiveCaseName := "C:\GitHub\spot-fw\Model Folder\data\DataCase_C5AgeTest_Output.data"            ! This Removes the structure             !local: C:\\Location_of_File\With general\ideas-of-how\afilesnamewouldbe\             !in the server: pro:/PublicData/Cases/FW SPOT Testing/            !before the actual file name            if _bp

512
Diego Perez-Urruti
AIMMS Partner
1 year ago
gabiservidone
Administrator
gabiservidoneAIMMSian
published in AIMMS Language
Stopwatch LibraryBlog

Did you know that you can use a library to measure execution time into your project? This library is called stopwatch and can be downloaded here!

580
gabiservidone
Administrator
1 year ago
Marcel Hunting
AIMMSian
Marcel HuntingAIMMSian
posted in AIMMS Language
Improving MIP performance by removing redundant binary variables: a real-life case

Introduction Removing redundant variables usually has no impact on the solving time because a solver like CPLEX will remove most of them during the presolve phase. However, in this post we will see that removing “non-trivial” redundant binary variables can have a positive impact. One of our users modeled a problem related to the unit commitment problem in AIMMS, and they ran into a performance issue with CPLEX. Model In the unit commitment problem we have a binary variable U(t) for each unit to model the commitment status of that unit for period t; U(t) = 1 if the unit is online in period t and U(t) = 0 if the unit is offline in period t. We also have a binary start-up variable SU(t) for each unit which is 1 if the unit starts up in period t and 0 otherwise, and a binary shut-down variable SD(t) ) for each unit which is 1 if the unit shuts down in period t and 0 otherwise. (Please note that in the AIMMS model the U, SU and SD variables are 2-dimensional but I omitted the index for the

730
Marcel Hunting
AIMMSian
1 year ago
F
fwang1986Enthusiast
asked in AIMMS Language
Matrix inverse

Is there any existing library or repository library available to calculate inverse matrix, especially for large scale matrix?

1255
F
1 year ago
F
fwang1986Enthusiast
posted in AIMMS Language
How to link EIGEN https://eigen.tuxfamily.org/index.php?title=Main_Page to AIMMS?

How to link EIGEN https://eigen.tuxfamily.org/index.php?title=Main_Page to AIMMS? Using external procedure or functions?

483
Marcel Hunting
AIMMSian
1 year ago
H
HHHermitExplorer
posted in AIMMS Language
User desktop to cloud database help

Hello, Currently, AIMMS Developer is installed as fat client installed on user's workstations but we would like to move the databased externally so the fat client will connect it to an external cloud provider (IaaS or Paas mode maybe managed by AIMMS).Also, we cannot set up a VPN tunnel for each desktop to reach the external cloud hosted database since it would be impractical and expensive.What services, protocols and port will be necessary to open and secure/reliable solution should we choose to implement ?Thanks in advance !

392
MarcelRoelofs
AIMMSian
1 year ago
R
RwitamJEnthusiast
asked in AIMMS Language
Auto-schedule the deployed AIMMS app

Hi Team,Is there any way so that we can auto-schedule our deployed model. For example, In AIMMS Pro, I want to set the app to run automatically every 15 minutes.Regards

301
Chris Kuip
AIMMSian
1 year ago
V
vixingitEnthusiast
asked in AIMMS Language
Automatically show username

Hello, I want to show a user name automatically for every person that uses my model, for example when Jim opens he aimms project, I want the model to detect it’s Jim and  save it in parameter and show it in page my question is how can we detect user infos when the model is opened ?  Thank you

644
V
1 year ago
Click here to get AIMMS Community Edition
Terms & Conditions

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator