Solved

Hi there,I’m having an issue with AIMMS which is preventing the advanced text editor from working.When I launch AIMMS I get a Windows pop-up asking to install the Microsoft .NET framework 3.5. Then in AIMMS I get the error:Unable to locate the SyntaxEditor .NET assembly, falling back to ordinary editor.However, my machine is already operating the .NET framework 4. I’m using a work machine so am unable to roll back/install the older framework.I’m running Aimms-4.76.1.1-x64-VS2017.Has anyone had this issue?Any ideas on how I might be able to get it working?Thanks for your help! 

In our team, we are working on a linear energy system model which is expanding every day. We use the LP Gurobi solver with multi processing. Currently, it has 250M non-zeros (after presolve) and we think it will grow to more than a billion. If the computational capacity (let's say several hundreds GB of RAM) is present, is there any limitation on the problem size on AIMMS side?In particular I am interest in any limitation on number of variables, constraints, or non-zeros? or any limitation on the capacity of committed RAM or number of CPU cores for parallel computing? 

It is probably very simple, but i cannot figure it out and i need to get it done asap. Really appreciate any help!I have created a project that runs and gives me solutions. Now, i need to create another version of my model with major changes, but to make it faster i would like to “save as” the entire current project and then start making my changes. the “save as” menu only makes another copy of .ams file within the current project, but doesn't make an entire new project. i also tried to export a section, but the “Export” menu is not active.could anyone advise on how?

I created a very simple pie chart using a parameter with one index with 2 elements, named “Actual and “Penalty”.I was expected that the pie chart showed me the names “actual” and “penalty” inside the wedges, like shown in the article: https://documentation.aimms.com/webui/pie-chart-widget.html I also tried an elementtextidentifier to the set I use, although I would expect this does not make sense since the element are already named.I can’t find anything related in the pie diagram options or do I miss something?

Hello, We load back job data (optimization infos) from AIMMS PRO to the user session. I would like to display the status of the job. I only found the status code parameter but nothing about what is the status code list and meaning. Can somebody help me with that?Thanks, Zsófi

Is it possible to initialize local parameters, which have the property RetainsValue set? The first time, that the procedure/function is called, I would like the parameter to be initialized by a certain value. Afterwards, when the procedure/function is called again, I would like the parameter to keep the value from the previous procedure call.If I set Initial data for the parameter, the behaviour of RetainsValue is lost and the parameters is initialized with that value in every call to the procedure.

I find that unit conventions are an effective way to display data in different units. E.g. capacity in #items/day, with accompanying cost €/day, are relevant numbers for location specific KPIs. On a higher level, we can change convention to e.g. #mio Items/year, or mio€/year.However, I don't want to apply the selected convention on all my model identifiers. E.g expressing cost per item as €/item, and not as mio€/mio Item when the yearly convention would be selected.Is there a way to override the conventions in model identifiers, and thus explicitly define what uom to always display?Thanks!

Hi All,For a project we are implementing a user is making changes to a relatively large table. The user has the possibility to store these changes in a database.However, when a user closes his/her browser after having made these changes and forgets to store the changes in the database the changes have to be made all over again. Is there a way to raise a warning when closing the browser? In this case that would refer to a user that has made changes, but has not stored them in the database.I know using a uponleave procedure works when navigating to a different page, however when closing a tab no warning is raised using such a uponleave procedure. Furthermore, I have seen multiple sites raising a warning when closing the tab, so curious to see if this is possible to do in the AIMMS WebUI as well! 

Hi community,I have a three-dimensional parameter I would like to import. I know how to import one- and two-dimensional parameters, but do not know how to do this one. The data is stored in excel (I have attachted a snapshot as illustration of the structure of the data), I can extract (with some formulas in excel) the range (AM3:AO32) from which i would like to import the data. I also know the number of products (6), number of locations (5) and number of time periods (3). Can someone help me out with this?

I would like to visualize the opening and end stock in one line. This means for exampleOpening Stock Week 1: 100 (t = 1)End Stock Week 1: 80 (t = 2)Opening Stock Week 2: 120. (t = 2) This means on the x-axis (t = 2) has 2 values 80 and 120. I would like to see this jump without creating dummy x-axis points which are very close to t = 2.Is this possible?

Hi, i found something strange in my MILP model.I read my input from an excel file to fill my parameter. The input looks like this: I retrieve this from Excel by the following lines:And eventually in AIMMS it looks like this:What is so special about this column 7 and 8 that they are moved to the left? What can cause the order of the column to be changed without me noticing? Note: Also in my set DiscountLevel, the order is changed: 

Hi.I am working to develop a tool that reads some input data from an access database, solves an optimization problem, and then exports results to an output access database. The data import process worked fine when I was accessing the user interface (UI) in page manager. Then, I created an .aimmspack file for deploying the tool for end-user use. Now, when I run the tool from pack file (end-user UI), I get this error during input data reading (image attached). Could someone please help with this error? Could this error be due to me missing to include something during .aimmspack file creation? I have not included the input access database file while creating the pack file. Referring to the image attached, ‘RPS’ is a group in input access database file. Thanks for your help.

Hello! We used to read csv files using a tool called “FFRead” provided by AIMMS. The tool allow us to merge multiple tables of csv data in the same file — below is the content of such a file:I,Table1,City,PopulationD,Table1,Paris,45D,Table1,Lyon,47I,Table2,Country,PopulationD,Table2,UK,76D,Table2,France,89 As “FFRead” is not actively maintained, we are switching to “DataLink” and “CsvProvider”. Does these new tools provide the possibility to read multi-table csv data? Or we must create a new csv file per table?Thank you;Amritbir Gill

Hello all,I am trying to create a subset of a main set for a constraint. See the attached figure of the constraint*. The index k should be a subset of its set. The main set consists for example of three classes {1,2,3}, then its subset should consist be{1,2}, so the main (ordered) set minus the last element, as it is used in the constraint by (k+1) on the right-hand side. Can anybody help me out how to formulate this?* I am aware on the non-linearity

We have 2 aimms licenses, we would like to place them on the same server, is it possible to use one license for each project? Is it possible to manage ram memory used by the program being run by each license?

I have a parameter over weeks with historic and forecast info. I want the historical week to be a dotted line and from the current week onwards a solid line. I use an annotation ‘dash’ and created a string parameter that have dash for the historic weeks. I added this as annotation the parameter, but if I use this all the weeks are dotted. (When I remove the annotation the whole is solid, as it should be). So is it possible to change the line over the axis?

I would like to access via SQL queries the CDM database while using AIMMS Cloud.  Is it possible? How can I do it? 

Since I am now missing the possibility of the outer index area, looking for other approaches to get similar functionality. From @Gertjan I already understood that you could create a couple of widgets and use widget actions to switch between them. This would be a possibility to precreate a couple of the possible layouts. However, if you have a 5 dim identifier, this becomes quite a bit already...I was wondering, is it maybe possible to change the pivot information from within AIMMS code? Than I could create a widget action that shows popup where you can re-arrange the pivot information (and also create the element parameter/sub index selections for the outer-index areas). I have not seen that many references to the widgets in the webui library, but maybe there is some way that this is possible?

Hi all, Quite new to this WebUI thing in AIMMS, not so new to AIMMS itself (have done some things with AIMMS before….. ). (Edit: after posting the question, I see the forum classifies me as an AIMMS newcomer ….  ) I am starting to understand the whole concept with rows/columns in the layout, but not sure how to solve the following problem:I have set the maximum number of columns on the page to 11 I have created two selection boxes (each 2 columns) and two labels to describe the selection box (also each 2 columns) I then added a large table (10 columns) Finally, I added another label of 2 columns, defined after the tableBecause there are still 3 columns free after the combination of 4 widgets (2x selection and 2x label), AIMMS will place the final label not below the table, but still on the first row, behind the other widgets as you can see in the image below: Is it possible to work with ‘spacer’ widgets to ensure a certain logical placement of the widget? How can I ensure in the webui

I am a research professor in China. For research purpose, I tried to apply a free AIMMS academic license. However, I had registration failure when I submitted the application form.  Could you please advise? Thank you.

I have a resolution type of issue in the WebUI. I have a linechart with 168 elements on the x-axis (all hours of the week), on a linechart of 12 colums. The data is visible in the chart, but the axis labels won't be displayed. If I reduce the number of x-elements to 150, the labels are visible again.I have tried modifying the element text of my domain set to a string parameter which only has a value every nth element, but that does not solve the issue.Is there a way in which I can show at least some labels on my x-axis when the widget size is insufficient to display them all?Thanks!

HiI am getting the following error while executing my code in AIMMS.“spreadsheet::RetrieveTable(BCLOAD.xlsx, Load_Base(h,y,a), B3:CM8786, A3:A8786, B1:CM2, Load, 1) unable to get a handle to the workbook: Could not open Excel.”I believe it is happening after some automatic updates on my Microsoft office. Previously it was working fine.I tried to reinstall my office, change my excel file name, or even copied the project folder to my PC from the google drive. None of them resolved the issue.It would be grate if you can help me with this issue.

Hi,as the title indicates I’d like to delete all elements from a set prior to each execution. Otherwhise elements from the previous execution are messing up my results. Basically I have a set that will only contain elements under a certain condition, but if it doesn’t it still keeps the elements from the previous execution right now. I tried to fix this by calling empty MySet in the MainExecution, MainInitialization or  PostMainInitialization procedures. This just gives me an error saying “The defined domain set “MySet” cannot be emptied”. I don’t quite understand what’s causing the issue here since the set should already be defined, especially when PostMainInitialization gets run after the initialization completed. Can anyone help me out with this?Thank you!  

All,I have just begun supporting an AIMMS Pro implementation for my customers, and a separate cybersecurity team found that the traffic from the AIMMS Pro web server is unencrypted:Unencrypted Network Communication: AIMMS Pro Launch Page: When accessing the web frontend used to launch the application, traffic is transmitted using an unencrypted network protocol.   Unencrypted Network Communication: Websocket: The application establishes a websocket to communicate with its server using an unencrypted network protocol.Looking through the support/architecture documentation it appears that AIMMS Pro uses it’s own web services to host the page, so I’m trying to see what effort is involved in changing these settings, and what the implication is on the client side as well. 

Hi,I would like to know if is possible to create a direct link from AIMMS to PowerBI and if not, if is it being planned?