Optimization Tooling

Dear All,I want to perform a complex calculation in AIMMS. For example, the given data is the impedance (Z) with Z = R + iX. In a constraint, the impedance must be transferred into admittance (Y) where Y = 1/Z. Is there a method in AIMMS to do this? Thank you very much.

Hi, can you help me check this command, I want to generate the detailed infeasibility analysis report from AIMMS. How and where to declare “CPLEXParameter” and “generate InfeasibleAnalysisReport”? Is this the correct approach? if not please assist me.Thank you for your help.

I am facing runtime issues for one of my AIMMS project. I am thinking to pass an initial solution to the model before we call solve statement.  As per the documentation, I have activated the following. CPLEX X.X: Specific solvers > CPLEX X.X > General > Advanced start > Use advanced basisI have stored the initial solution in an .xlsx file. I would like to assign this value to the variable. How to do it. I am not getting the options or idea. Where to assign or how to assign if I would like to assign an initial solution to the following variable.   

Hi every oneI would like to implement a cost function VS CPU time curve similarly to the following figure. How we can do it?thanks for your support 

When a ‘print’ button is pressed, an error message pops up as shown below: Code under the procedure as shown: PR_Verify_PDF_Printer;PrintStartReport(sp_WeeklyReport_Cover_Title);! Print coverPrintPage("r::Weekly Report Cover");! Print summaryPrintPage("r::Weekly Report Summary");for i_WeeklyReport_PrintableMonth do    ! Set month    ep_WeeklyReport_Month := i_WeeklyReport_PrintableMonth;    ! Generate report    pr_WeeklyReport_GenerateReport;    for i_Report_PrintableAffiliate do        ! Set affiliate        ep_WeeklyReport_Affiliate := i_Report_PrintableAffiliate;        ! Generate Affiliate report        pr_WeeklyReport_GenerateAffiliateReport;        ! Print page        PrintPage("r::Weekly Report");        if p_WeeklyReport_PrintExtraGraphs then            ! Print page 2            PrintPage("r::Weekly Report 2");        endif;    endfor;    ! Print monthly totals page    PrintPage("r::Weekly Report Month Total");    pr_WeeklyReport_ClearTotals;endfor;PrintEndReport(); What might

Hi all, We currently have an AIMMS Pro on-premise installation which we need to upgrade to a newer AIMMS Pro version. We would like to upgrade to AIMMS PRO 24.4.2.1. The reason is we're in a bit of a hurry to finish the upgrade and want to minimize the risk (as we’re coming from a relatively old version), so we do not want to upgrade to a higher version to avoid having to migrate the AIMMS PRO database at version 24.5.1.However, on the AIMMS download website we seem to only be able to download the latest version of AIMMS Pro, even though in the past it was possible to also download older versions (and of course it is also possible to download older versions of AIMMS Developer).Can someone help us in finding the executable for AIMMS Pro 24.4.2.1? Thanks!Meike

I want to share an issue I recently had with using the DLS (ADLSG2) Library in case you come across it.To use this locally (developer mode) you need to generate a SAS Token.I did this but in a lazy way (I selected all permissions!).Then you try using to then use the functions to communicate with ADLS2, you will get an error regarding "Signature fields not well formed.". This is apparently (to be confirmed) caused by the token being either too big or maybe some conflict with permissions.In anyway, to resolve this, when generating your SAS Token be mindful and actual pick the ones you need - not simply all of them.

May I know what are steps should I follow to extract the results from AIMMS to other formatted file, ex: from AIMMS to EXCEL / AIMMS to WORD but not by manually. Is there any ways for it? 

Today I got a question on support whether the unit of a constraint influences the shadowprice; for instance, what is the consequence of using [ton] instead of [kg] on the unit of constraint for the shadowprice.A small example illustrates the effects: Variable x {    Range: free;    Unit: kg;}Constraint limX {    Unit: ton;    Property: ShadowPrice;    Definition: x <= 5[kg];}Variable o {    Range: free;    Unit: kg;    Definition: x;}  The base unit of Mass is kg. Running the model, the shadowprice returned for limX was 1; indicating that increasing the rhs by 1 unit (kg), will increase the objective by 1. Then I changed the unit of limX to ton, and solved the model again.The shadowprice returned was 1000; indicating that increasing the rhs by1 unit (ton), increased the objective by 1000. See also: https://documentation.aimms.com/language-reference/optimization-modeling-components/variable-and-constraint-declaration/constraint-declaration-and-attributes.html#constraint-levels-bounds

Hello, I have a question regarding AIMMS. I plan to do lab scheduling that will assign classes to a lab venue at a time. Each class will be taught by a different demonstrator, which I already specified in the parameter (Demo_Lab) as shown in the picture. However, whenever I included it in a constraint named Demo_Gap with an index domain (l,t), AIMMS did not follow the Demo_Lab parameter. AIMMS gave the results with a demonstrator randomly assigned to any class (you can refer to the final image). May I know how this is possible to happen? The parameterThe data. The demo gap constraintThe result shows AIMMS just assign demo to any classes without consider the mentioned parameter  

Greetings comunity; recently i was trying to work on MOPTA solution and we have a problem with multidimensional paramaters edit in web UI; is there a way to edit a widget table with multidimensional data.Thanks for help

Hi,I have a problem with seeing detailed results in my AIMMS program. There are no errors and I get the result for the total cost minimization, but I cannot see any detailed data. Can anyone help me with that? Link to Google Drive with data and program:https://drive.google.com/drive/folders/1QvAuq8sTMautsUEm-3i42Si_1ObSICBe?usp=sharing

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:I have ever encountered this problem before, and I was told to define the set as a subset of Integers and use Order by. However, I hope the data in the set is treated as element rather than value. So for a set Time := {1,3,5}, Time(1+1) := 3.What wrong with 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: Sheet1andSheet2These data sheets have:No makeup. The first row contains the names of the columns. Each subsequent row contains a record of data.The data in the

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 1interProcessData.bat", wait: 1, minimized:1); pLoopCount += 1; endwhile;Kindly help if I am doin

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 case again.  This will result in the following screen shot: Note:The parameters a and b got their values, because they were stored in the case. The parameter c got its value, because it is a defined parameter. The parameter d did not get a value; it was excluded from the case content type. The following annotated code shows how t

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.