Optimization Tooling

For one of our AIMMS apps, we read in a file from the ADLS on startup. This happens in a procedure that is part of PostMainInitialization. We call dex::dls::ListFiles to determine which file to read, but the API call fails.Presumably, this problem occurs because parameter StorageAccount is only initialized in procedure Initialize in the PostLibraryInitialization of DEX. This post lib is only run after our PostMainInitialization is run. Is there a way to automatically run a procedure on start-up of the application, that is run after the PostLibraryInitialization of DEX? Or is it possible for you to change DEX such that StorageAccount is initialized in the LibraryInitialization instead of the PostLibraryInitialization?  

Hi all!  For an on-premise AIMMS PRO server, does anyone know if there's a way to get a report of the last time each user logged in or the last time each user opened a WebUI session? I know it's possible to search and parse logs (at least over the available history), but wondering if there's an easier way.  The AIMMS Control Panel can create a session list by user (Session List tab), but it only appears to show solver sessions (and some of our users don't click Solve). For context, trying to find a robust way to identify AIMMS PRO user accounts that are no longer used

I use AXLL::ReadSet to read the set element from Excel:And in excel the rank is  However, the data in the set looks like this (the data is in a wrong ranking):Sometimes, it ranks like this:Even though I define the elements directly:Still, the data looks like this:

Hi, In the map widget there is the option to set Dynamic Arc Width, could you explain a bit more on how it works? E.g. like is it a min-max scaler? Background for asking is that in small examples/models it works reasonably well, but in ‘bigger’ examples it flattens out a lot and the arc sizes are in our case not really visually differentiating. If we understand a bit more behind the scaling, we could maybe make some fine-tuning to get the visual representation we would like to see.

Today, during a short customer meeting, I got questions on how to read in data, when that data is presented in an Excel workbook; whether to continue to use a single sheet containing multiple tables, or put each table in a separate sheet - a data sheet; and if so; to continue using AXLL, or switch over to AimmsDEX. Illustrative examples were appreciated.For an Excel sheet containing multiple tables and scalars; you will need to use AXLL. Excel data sheets are one of the de-facto industry standards for exchanging data between programs. In this article, I'll show three ways available with AIMMS to read data sheets in an Excel workbook:Via AXLL library Via AimmsDEX library, using manually created mapping files, Via AimmsDEX library, using annotations to relate data columns to AIMMS identifiersThe running exampleThe data sheets are: 

What is the difference on the program status of “Found Solution” with Optimal solution. Does “found solution” status shows the feasible result not the optimal one? Please explain.

I am trying to develop a model and store the output iteratively. The code I have written is given below. I am trying to store the output “poFGAllocation(sr,d,p,b,f,n,a,s,l)” iteratively. Model is running and showing optimal solution. However, the output parameter returns empty dataframe. pLoopCount is a parameter with initial value 1. while (pCardFG > 0) do for sr do pr_Read_Input_Data; solve mpMaximizeWagonCap where MIP_absolute_optimality_tolerance = 0.05; showProgressWindow(); !vFGAllocationTonsLoop1(xy,sr,d,p,b,f,n,a,s,l) := vFGAllocationTonsLoop(sr,d,p,b,f,n,a,s,l); poFGAllocation(sr,d,p,b,f,n,a,s,l) := vFGAllocationTons(d,p,b,f,n,a,s,l); sFGLoaded := sFGLoaded + {f| sum[(d,p,b,n,a,s,l),vFGAllocationTons(d,p,b,f,n,a,s,l)] >= 0.99}; sFG_ID := sFG_ID - {f| sum[(d,p,b,n,a,s,l),vFGAllocationTons(d,p,b,f,n,a,s,l)] >= 0.95}; endfor; pr_Write_Output_Data; execute("cmd.exe /k 1inter

Storing data in so-called cases is the proprietary way of AIMMS to store snapshots of data.For instance, to limit the size, but also to permit loading data for just a selection of identifiers, so-called Case Content Types can be used. Consider a simple application, having scalar parameters a, b, c, and d.  c is the only defined parameter and has definition a * b.Filling in 3,4, and 5 for a, b, and d respectively results in the following screen shot:  With the WebUI data manager, and as Case Content Type: { a, b }, we can save the case.  And this will just store the data of parameters ab, in case ab.data: Now closing the app, and restarting it, we can load this ca

Dear I want to import data to AIMMS from Databricks. when I import data to Power BI, we are using the following strings: could you help me to configure AIMMS to import the data ? Thanks

Hi everyone, On June 19, from 16:00 to 18:00 CEST, the AIMMS virtual user meet up is planned. This session is for both SC Navigator and AIMMS platform users. It would be great if you can join, so please save the date.  Event details:When: Wednesday, June 19, 2024 from 4 to 6 PM CET Where: Online Cost: FREEWhat to expect:Roadmap update: Learn which new features are released and which ones to expect. Peer sessions: Connect with peers to share knowledge and discuss common topics.An official invite will follow soon.

Hi guys, I’m a student from the university of HEC in Belgium and I need your help for one project that I’m working on for one of my courses. In fact, I have received a database from Excel that I have exported on AIMMS (which has been done succesfully). Then I’ve realized my parameters, constraints, … in order to optimize the function that the teacher gave to us. But now, the teacher expects to us to export the AIMMS file to Excel to realize our analysis (so once all the values have been computed, we have to export these numbers to Excel in order to analyze these numbers) and I don’t understand how can I export the AIMMS file to the Excel. Can you please, try to help me? Thanks for the answers :)

We are in the process of transitioning from WinUI to WebUI. Under WinUI, our users have saved many cases to their laptops or a shared drive. I don’t know why the proserver wasn’t used, but it wasn’t. As we transition to WebUI, though, we’ll need to store cases on the proserver. The question is, how can we move our saved cases to the proserver so they can be accessed in WebUI? I tried copying them but the format is clearly different. It’s doesn’t seem i can just copy the .data file out to a specific folder on the server. How can we move these case files to the server? It doesn’t need to be an ongoing thing. I only need to upload them once.I appreciate any guidance.

Hello,Is it possible at all to recover unsaved development after an AIMMS / system crash? Thanks!Barry

Customers and users frequently bring up ‘latency’ and ‘bandwidth’ effects when using our Cloud SaaS.This post is intended to provide clarity around this topic based on what we hear from customers using the AIMMS Cloud Platform or SC Navigator.First, what are we talking about?DefinitionsLatency refers to the delay or lag between when a user performs an action and when they receive a response from the application. It is influenced by factors such as the physical distance between the user and the server, the network infrastructure, and the speed of data transmission. Higher latency can result in slower response times and can be frustrating for users, especially when real-time analytics or time-sensitive decisions are involv

Dear Community, I've noticed a growing interest among clients in leveraging AIMMS' Rest API and ADLSG2 (Azure Data Lake Storage Gen 2) services. To assist you on this journey, here are some helpful pointers: References: Developing an AIMMS Service: Follow this guide to develop an AIMMS service and integrate it with your applications. Develop an AIMMS Service Setting up an Endpoint in AIMMS: Learn how to configure an endpoint in AIMMS to interact with external services. Creating an AIMMS Server app

app is working well in development environment. after publishing app on AimmsPro, I see error as page id not found.  

Based on an exercise we conducted with a specific customer recently, we would like to offer a framework for building a potential business case for making the switch from PRO On-Premise to PRO Cloud SaaS.Historic contextIn 2011 AIMMS launched AIMMS PRO, a deployment platform for AIMMS applications. It ran on servers inside our customers’ data centers or cloud tenants.It met customers’ needs for:Easily and quickly distributing AIMMS apps to end-users. Lower Total-Cost-of-Ownership (TCO).In 2016 AIMMS launched the AIMMS Cloud SaaS, delivering AIMMS PRO as on-demand cloud-powered Software-as-a-Service. In addition to the needs listed above, it met customers’ needs for:Security, reliability and scalability Not having to ‘manage IT’After that, all new AIMMS customers opted for this new SaaS solution, the AIMMS Cloud SaaS.Be

Recently one of our customers encountered a REST API that didn't accept Json UTF8 files starting with a Byte Order Mark (BOM). By default, the PUT files created by AIMMS are UTF8 files with a BOM at the start to mark these files as UTF8 files.There are some ways to circumvent this issue:Set the hidden AIMMS Project Setting "Default output character set” to UTF8NoBom. Use the function dex::ConvertFileToEncoding(inputFile, inputEncoding, ouputFile, outputEncoding, noBOM) to convert a file. The .json files created using dex::WriteToFile(dataFile, mappingName, pretty) are UTF8 files without a BOM.

Dear All,I have a linear programming problem (from a book of optimization in power system) with uncertain parameters as:max z = 750x1 + 1000x2subject to:x1 + x2 <= ax1 + 2x2 <= b4x1 + 3x2 <= cx1,x2 >= 0where a, b, and c are uncertain parameters with the probability function as:How to implement this optimization problem in AIMMS?Thank you.

In the realm of data handling, creating large CSV files efficiently is crucial. This article explores four distinct methods to generate a CSV file with 10 million records, comparing their performance in terms of execution time and memory increment. FmtPut Method: Time: 44 seconds Memory Increase: 1276 Mb This traditional approach uses format-based output to write data to a CSV file. While reliable, it’s not the most efficient in terms of memory usage. See FormatString PurePut Method: Time: 36 seconds Memory Increase: 2533 Mb A method that writes data directly, PurePut is faster than FmtPu

Dear Team,I have a problem. I need some helps. I have several coils with weight. I have to load coils on wagons. There are two types of wagons. The capacity of two types of wagons are 64 and 67 respectively. I have to make rakes by joining wagons. There are three types of rakes. In one rake type, 1st type of wagon can be used. It takes 4 wagons to make a rake. In rake type 2, 2nd type of wagon can be used and 5 wagons are required to make a rake. If we club two different types of wagons, then also we can make rake. It takes 3 wagons to make a rake. My objective is to make full rakes and utilize all the coils with minimum cost.  I have designed a variable v_(i_Rake_Type,i_Wagon_Type,i_Wagon,i_Coil). The constraint is sum[(i_Wagon_Type,i_Wagon), v_WagonType(i_Rake_Type,'Wagon_1',i_Wagon)] = 4*sum[i_Wagon_Type, v_RakeTypeUsed(i_Rake_Type,'Wagon_1')];I am finding it sometimes problematic. In the last types of rakes, we need to use two different

I am trying to define a variable with following index domain (i, v in Vehicles_i(i),j, j1 in Nodes_J(j))I am getting a message ', )' is expected.What is the error in this definition?When I am defining as (i, v in Vehicles_i(i),j, j1)  or (i, v, j , j1 in Nodes_J(j)). It does not give any error.

Dear Team,I am facing one problem while writing a constraint. Let's say, I have three boxes with several items. Say box 1 has 4 items, box 2 has 6 items and box 3 has 9 items. I am processing the items day wise considering time as a constraint. I want that, if I am selecting a particular box, I will process all the items of that box 1st then will move to the next box. What I am getting that Day1-box1- 2 itemsDay1-box2-3 itemsDay1-box3-2 itemsDay2-box1-2 items.I do not want it. I want, choose a box on day 1, process all the 4 items based on the available time. I have written a constraint to handle it, which is like sum[d, v(d, boxnumber)] >= p_items(boxnumber) - v_Penalty(boxnumber)It means, I am trying to get the item number in a box while minimizing the penalty in the objective function.  Kindly help if I am doing anything wrong.

Wanted to share an exchange I had with a customer since it may be useful for others: ---------- question ---------Dear Aimms Support, Luis,We have the following case:In the WinUI we have some tables where we have a total row and below that the categories of that total row. For example we have the "Total days" which consists of the sum of other lines.To make it easier to distinguish between the categories and the total, we would like to add a tab/space before the categories. If I add this to the text of the identifier, the spaces will be removed in the WebUI.So my question is, is it possible to add spaces at the beginning of the identifier text? If not, what are the other options in this case?Kind regards, ---------- answer ---------Hello!Yes, you can do this.Here is an example project: Procedure pr_naming { Body: { webui::IdentifierElementText('p_test') := "t