Tech Blog

Tips and Tricks for AIMMS Users

Author Archives: Guido Diepen

About Guido Diepen

Former Optimization Specialist at AIMMS, now Senior Consultant Advanced Analytics at Deloitte.

Using implicit identifier set in pivot table

Posted on July 24, 2013 by Leave a reply

Screenshot Pivot TableOne of the nice things of the pivot table in AIMMS is that you can easily display a large number of identifiers. Especially after the feature to select specific elements of a set to be displayed, this really allows for end-users to perform so-called slice-and-dice to get insights in data/results.

Normally, if you want to display multiple identifiers in a page object in AIMMS (for the ones that support this), you have to explicitly add each of these identifiers in the contents tab of the page property. Especially when the number of identifiers is large, this can take quite some time. Fortunately, the pivot table in AIMMS also has the option to work with a so-called implicit identifier set.

Continue reading »

This entry was posted in Beginner on by .

Using progress bar in AIMMS

Posted on May 23, 2013 by Leave a reply

Estimation - Credits: XKCD

Estimation – Credits: XKCD

Whenever your projects become larger, certain steps in the execution might start to take some more time. For example, if your project needs to retrieve its input from multiple sheets in multiple Excel spreadsheets, it can take a couple of seconds before all the input data has been read.

For most users, it is actually not a big problem if execution of certain steps in your project take some time, as long as they know that something is actually happening. If you don’t provide any feedback to the user about what is currently happening, the user might think that the application is hanging.

One possibility you have in AIMMS is to use a progress bar dialog indicating the progress via a graphical progress bar combined with a string describing the status.

Continue reading »

This entry was posted in Beginner on by .

Using calendars in AIMMS

Posted on April 24, 2013 by Leave a reply

calendarFor a lot of problems you will need to work with some time based notion during the modeling. For example, with a transportation problem the main decision could be how much to transport from each depot to each customer for every day in a given time horizon.

Of course, it is possible to just create a set Days in AIMMS and give this exactly the same number of elements as there are days in the time horizon you are considering. However, this would require you to manually keep track of which of these elements are working days and which ones are weekend days. Also, you would have to take care of the fun details regarding leap years. Fortunately, in AIMMS you have the possibility to work with a Calendar, which makes working with time related things a lot easier.

Continue reading »

This entry was posted in Beginner on by .

Monitoring identifiers for changes

Posted on April 10, 2013 by Leave a reply

monitorWhenever you changed the values of some identifiers and close your AIMMS project, the default behavior of AIMMS is that it will ask you whether you want to save the unchanged data. This behavior depends on which data categories and case type are currently active.

There can be situations where it is useful to not have this check based on a case type / data category, but just check whether a give subset of all identifiers in your model have been changed since the last time you checked. With AIMMS 3.12, we have introduced the data change monitor functionality which allows you to achieve exactly this.

Continue reading »

This entry was posted in Advanced on by .

Animation with colors in AIMMS

Posted on April 02, 2013 by Leave a reply

screenshot-pivttable-heatmapIn the first post of this year (Happy New Year) I showed how you can use the network object in AIMMS to create an animation of exploding fireworks. In another recent post (Using colors for feedback in pivot table)I showed how you can use the pivot table in AIMMS to display a heat map.

In this new post, I will show how you can use the user color related functions UserColorAdd and UserColorDelete in AIMMS to create an animation of the heat map that is displayed on the right.

The goal is to create an animation that will morph the picture such that each point that starts out as green ends up as red and vice versa.

Continue reading »

This entry was posted in Beginner on by .

First AIMMS Hangout

Posted on March 22, 2013 by Leave a reply

AIMMS_HangoutAfter my questions on both the AIMMS Google Group and on this Blog about participating in an AIMMS Google Hangout, I got two replies from Yawen and Thiruselvan that they were willing to be the guinea piggs.

We just finished the first AIMMS Hangout and I would like to thank both Yawen and Thiruselvan again for being the guinea piggs!

In the rest of this post I will provide some more details about the questions and pointers that might be helpful.

Continue reading »

This entry was posted in Beginner on by .

Using project local solver configuration

Posted on March 20, 2013 by Leave a reply

preferencesIn an earlier post Change default solver used for each type of mathematical program I showed how you can modify the default solver that AIMMS will use for solving each type of mathematical program.

I did not only demonstrate how you can modify these defaults via the solver configuration screen (which you can access via the Settings menu), but also showed how you could temporarily overrule this default by modifying the contents of the predefined CurrentSolver element parameter or by using a where clause with the solve statement.

Normally, the list of solvers available via the solver configuration screen is the same for all projects opened with the same version of AIMMS. In this post, I will show how you can overrule the solvers that are available for your current project.

Continue reading »

This entry was posted in Beginner on by .

Dealing with model is infeasible or unbounded error

Posted on March 12, 2013 by Leave a reply

infeasible-triangleUnfortunately, when modeling things hardly ever go as planned at the first try and more than once you end up with results that you did not expect. At first glance everything in the symbolic model (i.e. the variables, constraints, and parameters in the model tree) might look OK, but still you are getting results that do not make sense or the solver concludes that your model is either infeasible or unbounded.

Luckily, for these cases, AIMMS provides a couple of tools that allow you investigate what is actually being sent to the solver (i.e. the complete generated problem). Investigating the information from these tools, allow you to figure out what part of your model is causing the unexpected results.

Continue reading »

This entry was posted in Beginner on by .

Using colors for feedback in pivot table

Posted on February 28, 2013 by Leave a reply

screenshot-pivttable-heatmapThe saying is that one picture says more than a thousand words. When presenting some data to an end-user in your AIMMS project, you have the possibility to use the different page objects AIMMS provides. Besides presenting the data in a graphical manner, you often also present the data in some sort of a table.

Especially when you are displaying large datasets with lots of numbers, it might be difficult to quickly see the information in this data from a table. The pivot table object in AIMMS has a feature that allows you to use some colors to provide a graphical feedback to the user regarding the data that is displayed.

Continue reading »

This entry was posted in Beginner on by .

Quickly determine on which pages an identifier is used

Posted on February 08, 2013 by Leave a reply
Search for identifiers

Search for identifiers

In December 2011 I wrote the blog article about Determining where each identifier is used in your project. This article showed how the function ReferencedIdentifiers could be used to obtain information about which identifiers referred to which other identifiers.

In the same article, I also explained you could use the functions PageGetAll and PageGetUsedIdentifiers (or alternatively the function IdentifierGetUsedInformation that was introduced in AIMMS 3.12 FR2) to get information about which particular pages have references to an identifier.

Although this approach is useful if you want to get information for all of the identifiers, it is a bit cumbersome to just quickly get the information about which pages are using one specific identifier.

Continue reading »

This entry was posted in Beginner on by .
  • Customer Reviews

    Read more AIMMS reviews
  • Review AIMMS on G2 Crowd
  • Recent Posts

  • Categories

  • Google Analytics