Skip to main content

    Featured Topics

    How idea submission works

    We invite you to share and vote on ideas to improve and expand functionality of AIMMS products. This helps us to know what users want and need.Before...

    Ideas pipeline

    Filter by idea status

    Filter by product

    113 Ideas

    sandervlot
    AIMMS Partner
    sandervlotAIMMS Partner

    Restrict general access to Azure Storage for AIMMS Cloud apps (and provide more granular access)On Backlog

    By default, the access key of the Azure Data Lake Storage is available for all deployed AIMMS apps in an AIMMS Cloud tenant, through dex::dls::StorageAccessKey. With this key, AIMMS apps can grant themselves full access to the Storage Account. However, it isn't always desired that all data in the Storage Account is visible to all deployed AIMMS apps. Actually, I think nothing should be visible by default. Only if an admin/super user determines that an app is allowed to have access to a certain filesystem/container/directory, it should be granted (principle of least privilege).This leads to the following 2 requests: First of all, AIMMS apps shouldn't - by default - have access to the general access key, since this undermines any other attempt to restrict access through (for example) SAS tokens. Second, it would be nice if AIMMS could provide functionality to distribute SAS tokens with limited access to specific AIMMS Cloud apps. This is something I could also build myself by the way (though only if point 1 is addressed), but it would be nice if AIMMS could provide this. Curious to hear your thoughts! 

    1
    MarcelRoelofs
    AIMMSian
    Forum|Forum|2 years ago
    MarcelRoelofs
    AIMMSian
    MarcelRoelofsAIMMSian

    Standardizing data exchange with AIMMSImplemented

    The DataExchange library (https://documentation.aimms.com/dataexchange/index.html) is intended to offer support in AIMMS for data formats, such as JSON, XML and CSV, that are commonly used in web services. The basic mechanism to read and write data using the DataExchange library is to provide a mapping that maps data in any of these formats onto identifiers in an AIMMS model. Although creating such a mapping is not very difficult, it may amount to a lot of work. In this post I want to explore if and how we can provide some kind of standard format, that is generated by the DataExchange library itself, and can be used directly in most use cases for web services. More specifically, I'm looking for feedback on what follows below.Let's start with a list of possible web services that we could consider:Calling a web service from within an AIMMS model that runs a Python/R script with data from within the model.  Calling an (AIMMS-provided) web service that runs an AIMMS model on our cloud platform, with data provided from the calling program/service Calling a web service to store data from a model, or retrieve data needed for a model (such a web service could, for instance, replace the current database interface in AIMMS and prevent all kind of problems with, for instance, latency that our current database interface suffers from regularly, as the web service could be placed close to the database server)Let's focus on the last use case, and explore how most of our customers use relational databases (as we do ourselves as well in AIMMS SC Navigator). Most customers store values from one or more identifiers with the same domain in a single table. In order to be able to store data for multiple scenarios, typically one additional column is added to the primary key of all tables to store the scenario key. Typically, models read data from such tables for one or more scenarios, and add the complete data for a new scenario, or replace the complete data for an already existing scenario. Changing individual rows or rows, has quite some commonality with CDM and are less suitable for the regular database interface we have in my opinion. In SC Navigator, we have an additional layer of abstraction, the dataset, which collects data from multiple tables holding functionally similar data into a single dataset instance. The model data is then filled by mixing and matching data from instances of multiple datasets, each of which could have been created by any of the SC Navigator apps, or, with a 'database' web service, even by external applications/services. Through model annotations we can indicate in the model the data of which identifiers should be stored in a single table, and to which dataset such a table would belong. From such a collection of annotations we could automatically generate a database schema (like in tools such as Mendix), and use DataExchange functionality to write data to these generated tables either directly, or via a webservice. The big benefit is that the entire data exchange with a model is standardized, and we can make sure that the data exchange with the database will take place in a performant manner, by proper normalization of all tables and the use of the appropriate indexes on the database tables. We could even let CDM operate on such generated tables, where one would lose the history of changes that CDM currently provides because only the latest value will be stored, but where individual changes committed by one client could still be passed to other clients as CDM currently does.To transfer the data as JSON, we could generate a mapping from those annotations that generates JSON as in the following example:{ "dataSets": {   "DataSet1": {     "instance" : "data of 07-09-2020"     "tables": {       "Table1": {         "rows": [                 { "i":"i1", "j":1, "pn": 10.0, "ps": "a value"},                 { "i":"i1", "j":2, "pn": 20.1, "ps": "another value"}         ]       },       "Table2": {         "rows": [                 { "i":"i1", "j":1, "k":3, "qn": 10.0, "qs": "a value"},                 { "i":"i1", "j":2, "k":4, "qn": 20.1, "qs": "another value"}         ]       }     }   },   "DataSet2": {     "instance" : "data of 07-09-2020"     "tables": {       "Table3": {         "rows": [                 { "i":"i1", "rn": 10.0, "rs": "a value"},                 { "i":"i2", "rn": 20.1, "rs": "another value"}         ]       },       "Table4": {         "rows": [                 { "i":"i1", "k":3, "sn": 10.0, "ss": "a value"},                 { "i":"i1", "k":4, "sn": 20.1, "ss": "another value"}         ]       }     }   } }}Such a "standard" JSON format to exchange data is quite suitable for exchanging data with an AIMMS model-based webservice and can be easily generated from other applications/services, but also with Python webservices, as the JSON content of the individual tables can be directly read into or generated from Python Pandas. And it matches directly the format of the generated database table I proposed above (with potentially some metadata added in additional fields). So, to summarize the benefits of my proposal:it standardizes all data exchange with the model, database and external web services. This fits our guidance principle, where AIMMS will provide as much guidance as possible to create good applications and follow best practices for modelers the work to create mappings to exchange data with various services will dramatically reduce it would alleviate modelers from the task of manually creating a performant database schema and the associated mapping in the model it will make sure that, because of the standardization, we can much more streamline the support AIMMS have to give on data exchange with databases.Please let me know your reactions.

    7
    MarcelRoelofs
    AIMMSian
    Forum|Forum|2 years ago
    C
    AIMMS Partner
    cqmuser_gbsAIMMS Partner

    WebUI Table download .csv and .xlsx column namesDeclined

    Hello,The column names when downloading the .xlsx file from a table in the WebUI are different when downloading the .csv file. The .xlsx file contains the identifier names, whereas the .csv file contains the text of the element parameter, which I think is better. One way or another, the column names are not consistent with each other, could you have a look at this minor problem?Kind regards and thanks in advance,Martijn

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    sandervlot
    AIMMS Partner
    sandervlotAIMMS Partner

    Always show library prefix in WebUI widget identifier specificationOn Backlog

    Hi, in the AIMMS models I’m working with, the parameter name + index domain is typically too large to keep showing the library prefix in the WebUI identifier specification.I would like to see the library prefix always, to avoid picking the wrong identifier. Even if that means that I can see less of the par name and index domain (I don’t think I really need to see the index domain in this screen). Can you consider adding this functionality to AIMMS?   

    4
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    Jonathan Smith
    AIMMS Partner
    Jonathan SmithAIMMS Partner

    Please add UOM to Warehouse tableDeclined

    We would like our model’s base unit of measure to be “Unit”. However, since we measure warehouse capacity in cubic feet (not units) we must specify the model base unit as “Cube” since we cannot specify the UOM on the Warehouse table.

    4
    Paul
    Forum|Forum|2 years ago

    Extended GMP Get functionsImplemented

    In Generated Math Programs one can adjust (Set) or retrieve (Get) e.g. coefficients, right hand sides etc. For the “Set’ part, we have a number of Multi functions that allows you to adjust more than 1 row, column, coefficient in 1-go. We are wondering whether similar functionality for Get would be valuable and what your use case is. Can you let us know by voting and commenting below?We are specifically thinking about the following functions that are currently element based (you might think of others as well):GMP::Coefficient::Get GMP::Row::GetRightHandSide GMP::Column::GetLowerBound GMP::Column::GetUpperBoundThe multi routines will use indices in the sets of column numbers and row numbers as arguments (these sets can be obtained by using GMP::Instance::GetColumnNumbers and GMP::Instance::GetRowNumbers). The data will be stored in a parameter using the same indices. See also:Coefficient: https://documentation.aimms.com/functionreference/algorithmic-capabilities/the-gmp-library/gmp_coefficient-procedures-and-functions/index.htmlRow: https://documentation.aimms.com/functionreference/algorithmic-capabilities/the-gmp-library/gmp_row-procedures-and-functions/index.htmlColumn: https://documentation.aimms.com/functionreference/algorithmic-capabilities/the-gmp-library/gmp_column-procedures-and-functions/index.html  

    4
    Marcel Hunting
    Forum|Forum|2 years ago
    Pieter
    AIMMS Partner
    PieterAIMMS Partner

    SCN: Only relax Min or Max capacities in the Infeasibility AnalysisOn Backlog

    As an end user I need the possibility to only relax Min or Max capacities in the Infeasibility Analysis, (instead of both), so if the issue is with the Min capacity, I can see these issues and not relax the Max capacity.

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    Pieter
    AIMMS Partner
    PieterAIMMS Partner

    SCN: Data validation in table instead of one string parameterDeclined

    As an end user I need the data validation in a table instead of one large string parameter, so I can easier review and fix errors in the template.In the data validation screen after loading the data, the errors and warnings are shown in one large string parameterThis makes it difficult to extract the right customer/location/products and to make mass changes in the Excel template. I think a table format would work much better for users.

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    A
    ArikeDistriconExplorer

    Closing dialog page procedureOn Backlog

    Hi! Is it possible to add a procedure to close your open dialog page? So you could create a button/item/widget action on the dialog page that can close the current dialog page. 

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    A
    ArikeDistriconExplorer

    Opening a dialog page on a dialog pageOn Backlog

    Hi! I'm curious if it's possible to add functionality that enables opening a new dialog page while you're already on one. For instance, consider having a table within a dialog page and wanting to trigger the opening of a smaller dialog page through a widget action. This behaviour should be similar to the dockable page logic found in WinUI.

    2
    Madhu Krishnappa
    Forum|Forum|2 years ago
    A
    ArikeDistriconExplorer

    Horizontal scrolling in gantt chartOn Backlog

    Hello, I have noticed that it is not possible to scroll horizontally in the Gantt chart. Is it possible to add horizontal scrolling to the Gantt chart widget in the webui?  

    2
    Madhu Krishnappa
    Forum|Forum|2 years ago
    Diego Perez-Urruti
    AIMMS Partner
    Diego Perez-UrrutiAIMMS Partner

    Automatic Widget Renaming in JSON fileDeclined

    It appears that renaming a widget changes its name attribute, but not the original name of the widget in the underlying JSON file. And it appears the CSS refers to the latter, whcih might lead to undIf you dig into the webui.json file, you'll see the widget object for the “Diego” Table as:"widgets/Diego_Table"with attribute: "name": { "literal": "TA_Diego" },Would it be possible to make it so that the “rename widget” functionality also updates the original widget name in the JSON file?Maybe there is a good reason why it doesn’t so just submitting it here as an idea 😀

    5
    Madhu Krishnappa
    Forum|Forum|2 years ago
    G
    Guus KattenbeltEnthusiast

    Two step verification login access for PRO portalImplemented

    Hi all, Data security is always top of mind for a lot of companies of course and therefore also when using AIMMS apps. Therefore I would like to pitch the idea of a two-step verification method for the PRO portal.We as a company are working with SAML access for the PRO portal for our own employees and therefore securing two-step verification. But we also work together with consultants. They also need access to the PRO portal, but can’t get a company identity. The only option there is now is creating a user profile for them with only a password as a security measure. Therefore I would like to see two-step verification as an option for the PRO portal, such that any data accessible through the Apps in the PRO portal is more secure.

    6
    Jan-Willem
    Forum|Forum|2 years ago
    G
    Guus KattenbeltEnthusiast

    PageGetUsedIdentifiers for WebUI (for a batch change function)Discussion ongoing

    In short, we would like to get the function that is also available for the WinUI. This will allow us to create more general procedures to work with tables in the WebUI   We have an application where we use a lot of tables on different pages, like the one below. To make it easier to edit the data, we are using both an excel up and download as well as a batch change procedure. The batch change procedure we have right now works like this: take the value that is in the first month or year and copy it to the rest of the months/years. But as we have a lot of tables, it would be more convenient to be able to extract the parameters that are used on a certain page or even better, in a certain table, especially in combination with the currentpage parameter that is coming.    

    9
    G
    Forum|Forum|2 years ago
    gdiepen
    AIMMS Champ
    gdiepenAIMMS Champ

    Add support for fuzzy matching/searching when have searchbox for identifier in webuiDiscussion ongoing

    Especially when models become big and you have quite some identifiers, the standard search widget (e.g. when adding identifiers to a widget, or finding the identifier to be used as identifier for side panel in a page) can be tricky to work with.One of the problems is that the match is based on exact match of your search-expression with a part of the identifier name. Especially if you have some identifiers that share a same start, it might become more difficult to find them, partially because of the second problemThe second problem I have is that the width of the window of the of the matching identifiers is not too wide. Over the years, I started to give my identifiers relative describing names. Combined with for example the fact I might use additional prefixes to group more identifiers together, the names can become relatively long. This means for sure I will not see the indices of the matching identifiers anymore, but sometimes not even the last characters (on the other hand, why use super cryptic short names for your identifiers if you can have names that make it directly clear what data they represent) It would be very nice if besides the current default behavior of searching based on returning matches based on occurrence of the exact search key in the identifier name, you could also have an ‘advanced’ way of searching, namely by using fuzzy searching. This way, you search for an identifier likepAwesomeIdentifierHoldingDemandDatabased on a search strings like“Awme Demand” “demand awesome” or any type of fuzzy matching combination.I have changed my way of working both in my editor and in the terminal to be based on fuzzy matching (using the tool FZF) and it makes finding things a lot easier if you know a couple of items in the name, not necesarily in the right order.It could be a setting in the developer version of AIMMS to indicate that during development you want to keep using the old way of searching, or using a fuzzy matching.   

    1
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    A
    ArikeDistriconExplorer

    Customize shortcuts in the webuiDiscussion ongoing

    Hi! Is it possible to customize keyboard shortcuts on the webui? For example, is it possible to run a procedure by pressing ctrl-shift-enter?

    1
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    ColinLodewijks
    AIMMS Partner
    ColinLodewijksAIMMS Partner

    Customize dragging tooltipDeclined

    Almost all widgets offered by the AIMMS WebUI support tooltips. Currently, it is only possible to customize the static tooltips. So in for instance a Gantt chart, we can only customize the static tooltip which gives information about the task that is selected. When dragging a task, either the new start date or duration of the task is displayed. In some applications it might be more user-friendly to display the new end date of a task instead of displaying the duration.

    4
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    R
    AIMMS Partner
    RichardAIMMS Partner

    Can we combine the legend and multiselect widgets?Declined

    Hi,In many (webUI) applications, I have a chart which shows data dependent on a selection (usually through a multiselect widget). Also in many applications, I have or want a legend widget to display what means what. These two widgets are so similar in terms of contents that it would be really neat to be able to combine them; e.g. show the colored boxes in the multiselect widget.I think the above suggestion would be very valuable but might take a while to release. In the meantime, is there any way to style the mutliselect through css to mimic the same behavior?A final question; what is the best way to style a graph - legend if you want to use custom colors? After fumbling around with annotations, I can get the job done, but I feel that the way to link the legend with the graph is cumbersome, which makes me wonder if I am doing something wrong. Tips are welcome!Thanks - Richard

    5
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    A
    asskildtExplorer

    Tab to go right on the same rowOn Backlog

    Hi,In an input table in WebUI there is currently an action related to Enter key, where the active cell is going down while pressing Enter and thus enable quick and smooth input in the same column. However, there is no similar possibility to move horizontally on the same row, meaning you currently have to press Enter or click out of the cell, and then navigate by arrows or mouse click for next input cell on the same row. It would be highly beneficial of you could press Tab key to move right in the tab on the same row (and possibly Shift + Tab to move left), similar to Enter is moving to the next cell in the same column  Geir 

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    sandervlot
    AIMMS Partner
    sandervlotAIMMS Partner

    Add extra input arguments to webui::requestPerformWebUIDialog onDone procedureOn Backlog

    I’m using the webui::requestPerformWebUIDialog a lot, for example for saving specific voyages. I would like to be able to add extra input arguments to the onDone procedure, such that I don’t need messy global parameters for that. Also there is a risk that other developers call the onDone procedure directly without initializing eVoyageToSaveUI properly. Also see example below.Can you add support for an extra (string) input argument for the onDone procedure, for example by adding a onDoneArgument to the arguments of webui::requestPerformWebUIDialog?

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    alberteszter
    AIMMS Partner
    alberteszterAIMMS Partner

    Showed dates on Gantt ChartsDeclined

    Hi, I have a question about the visible dates on the Gantt Charts in AIMMS. I have set a left and right bound and between these bounds I would like to get more visible dates in the defined interval. For example, I have this Gantt Chart. I would like to see weekly intervals instead of monthly. Thanks for your help!

    5
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    gabiservidone
    Administrator
    gabiservidoneAIMMSian

    Show/Not show Widget HeaderDeclined

    I was wondering if anyone else miss the ability to hide and unhide the widget header. Use case: when using a side panel, the scalar widget is added without a header, so to create titles I added also a label widget. Use case 2: hide the title of a chart.

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    MathFour
    AIMMS Partner
    MathFourAIMMS Partner

    Can we "store focus" for a range in a table?On Backlog

    In trying to convert (as much as it makes sense) a project from WinUI to WebUI, I have noticed that in WinUI you can highlight a range of a table and, with some coding, get things like the sum or average. Is there a way (now or will there be in the future) to highlight and "store the focus" of a range from a WebUI table?

    3
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    Jonathan Smith
    AIMMS Partner
    Jonathan SmithAIMMS Partner

    Please add documentation explaining the Infeasibility AnalysisImplemented

    I could not find any documentation in the SC Navigator Product Manual explaining the infeasibility analysis feature. The only explanation I found was a video in the Strategic Network Design e-learning course.

    2
    gabiservidone
    Administrator
    Forum|Forum|2 years ago
    Sree
    SreeEnthusiast

    Automatically add slacks and resolve an infeasible modelImplemented

    AbstractA functionality within the modeling language to relax a constraint and/or variable bound and re-solve will save development time as well as provide control to the decision-maker(s) when a particular instance of a math programming model is infeasible. One candidate solution is to introduce a suffix for constraints that allows for this functionality. MotivationAn instance of a math programming model can be infeasible due to a particular set of parameter values. It may be that not all parameters are certain or that not all constraints and/or variable bounds are hard. Tools like Irreducible Infeasible Set (IIS) in MIP solvers help the expert understand and debug the model formulation. They do not necessarily offer a practical way to parse the information and report the finding to the end-user/decision-maker. In practice, adding a set of slack variables (note: for a lack of better terminology, using the term slack here to denote the slack required in a constraint to make it feasible; not to be confused with slack variables in linear programming) to constraints and setting up a feasibility problem (to minimize total slack required or other appropriate measure) is more approachable to provide control to the end-user. However, this requires the following.Slack variables are declared and added to the relevant constraints. Identifiers are declared and used as bounds for variables. An appropriate objective is defined to setup the feasibility problem. Math program is setup to exclude the variables while solving for the original objective and include the variables while solving for the feasibility problem either by manipulating the definition of a subset of AllVariables (corresponding to the slacks) that defines the math program, or fixing the slack variables to zero and relaxing them. All the information required to define the feasibility problem may not be available at the time developing the first math programming model and during subsequent iterations. It can be time-consuming during development or lead to errors while manually updating the model. Further, it may destroy the structure of the problem to develop advanced algorithms later on (at least when using the approach of fixing the slack variables to zero and then relaxing them later). Solution CandidateAdd a functionality in the AIMMS modeling language to relax a constraint or variable bound by introducing a new suffix for constraints and variables. Maintain a one-to-one feasibility model behind the scenes and solve it when requested. MIP solvers like CPLEX and Gurobi already support this natively (GRBModel.FeasRelax() - Gurobi Optimization and IBM Documentation - IBM Documentation). Alternatively, generate a model with slacks as a runtime library somehow and generalize it for other types of math programs. The suffix denoting the relaxation could consider non-binary values to also represent a priority order or even the objective function coefficient corresponding to the constraint/variable bound for the feasibility problem.

    7
    Marcel Hunting
    Forum|Forum|2 years ago

    Filter by product

    • All products
    • AIMMS Language
    • AIMMS Libraries
    • AIMMS PRO On-Premise & AIMMS Cloud
    • Algorithmic Capabilities
    • Integrations and Data Exchange
    • SC Navigator
    • WebUI
    Terms & ConditionsAccessibility statement

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

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