Solved

Hi, I am modeling a multi-commodity network flow. Bing chat suggested the page https://documentation.aimms.com/aimms3/application-development/modeling/network-flows/multi-commodity-flows.html, but it is a deprecated link. Can you provide any such example?

Hello! We are working on a project where data files are stored in central storage following an optimization. We would like users to be able to view and load those case files into a session at a later point in time. We store these data files in a PublicData folder for all users to use. However, regular users are not able to see any of the folders/items, no matter what the permissions of a file/folder are. Am I missing something regarding how central storage viewing works?  Looking forward to your answer!

Hi all, I want to read data from Excel but it should be sorted customly. In Excel the data is like this:  The result in AIMMS should be this:  I can create this with a text join in Excel and paste the value in the data field in AIMMS but the data changes frequently so I want to automate this with AXLL functions. It is important that the order of a, b and c holds.  Does anyone have an idea to do this? 

Hi community!I have a problem about a formulation and I am looking for help!I have defined a set “Input” index i, and two subsets “input1d” index id and “input1s” index is. Here is my formulation of a constraint:Identifier : MassConservation12Index domain : (i,id,is,r)Definition : sum(t, S1(i,t,r))+Stock1(i,r-1)=sum(d, Y1(id,d,r))+sum(s, uu1(is,s,r))+Stock1(i,r)+ZZ1(id,r) Should I modify the index domain in order to make clear that id and is are subsets of i? Thank you!

Dear AIMMS Team,Trust this meets you well? Kindly assist on the problem explained below and find attached the AIMMS file I am working with.   I have a variable StateofCharge(t) in which t is 1 to 24.  I want to place StateofCharge(t) at t = 1 or StateofCharge(01) on the conditional statement below. if ( (Charging_Power_kW(01) + SoCMin) > SoCMax) then     SocMax      elseCharging_Power_kW(01) + SoCMinendif;Note: Charging_Power_kW(01) is put as the value of variable Charging_Power_kW(t) at t=1 While StateofCharge(t) at t = 2,….24 should have the conditional statement below. The index t in the statement applies only from t = 2,….24. If Energy_Difference_kW(t) > 0 then      if (StateofCharge(t-1) + Charging_Power_kW(t)) > SoCMax       SoCMax       else       StateofCharge(t-1) + Charging_Power_kW(t)     elseif (Energy_Difference_kW(t)) < 0 then       if (StateofCharge(t-1) - SoCMin) > Discharging_Power_kW(t)       else        SoCMinendif; Also, if I have a parameter/variable

The objective variable is A(t) contains t = 1 to 24. The mathematical program is to maximize the sum of all the elements in A, i. e. Max sum(A(t)), t = 1 to 24. At the same time I hope to constrain the property of the objective variable that the standard deviation SD(A) is no larger than a constant “a”. So I defined a variable “SD(A) = standard deviation of A”. Then a constraint “SD(A) <= a”. When I run the program, it reminds me of “constraint programming constraints cannot be used in combination with real valued variables, only with integer valued variables, element valued variables, and activities. The real valued objective variable is an exception. The mathematical program has both constraint programming constraints and real valued variables.” However, when I revise the constraint from inequality to equality, i.e. SD(A) = a. Then no error arises and I get the answer. Why dose this happen? And How can I deal with it if I want the inequality constraint?

Hello all!  Is there a way to hide thousands separators in WebUI? We want to have years displayed in a scalar widget (e.g. 2023), but currently, WebUI automatically adjusts this data (e.g. to 2,023).  Thank you in advance for your help!

I want to run the model with different scenarios (data), can I import all the scenarios once and get the result for each scenario in one run?

 Like one day have 24 hours, I need to calculate the variables for 24 periods, but these variables are defined by 25 points, so I define the index t as “25”. For example variable A contains 24 elements, A(1) = B(2)-B(1)…...A(24)=B(25)-B(24).  If I define an index “t” as 25, I can simply define the B as B(t) using t (1 to 25) as the domain. But How can i define A which only contains 24 elements, actually from 1 to 24, can I use part of t domain from 1 to 24? 

I have a string parameter as per the following data```optimalfeasibleinfeasible```I would like to show it in the WebUI in the same way but it is coming as ```optimalfeasibleinfeasible```Kindly help. 

Hello everyone,I’m new in AIMMS and need help for my thesis. I need to implement the following constraints: t is an index for the period, here t = ( 1,2,3,…,T )How can i set the initial value from E(t=1) = Q How can I implement the E(T+1)  Thank you in advance kind regards  

I have a question regarding the calendar. We have an old app implemented based on calendar, in which the hours within a day are expressed as 00 ~ 23. But now we need to change it to 01 ~ 24. Please let us know what the easiest way to do it.

Hi Community, I am trying to use the AIMMS RegexReplace function to trim the folder path and keep the data case name. It’s working fine locally but it’s not working when testing in the server.My code looks like this:        block ! Get the full path for the Active Case File            _sp_ActiveCasePathName := FormatString("%s", CaseFileURL(CurrentCase));            !Check for server vs local. Local path won't likely contain the string 'PRO:/PublicDta'            !example server path: PRO:/PublicData/Cases/spot_fw            _bp_IndicateLocalFileName := not (RegexSearch(_sp_ActiveCasePathName,         "PRO:\\\\PublicData"));            ! Text example _sp_ActiveCaseName := "C:\GitHub\spot-fw\Model Folder\data\DataCase_C5AgeTest_Output.data"            ! This Removes the structure             !local: C:\\Location_of_File\With general\ideas-of-how\afilesnamewouldbe\             !in the server: pro:/PublicData/Cases/FW SPOT Testing/            !before the actual file name            if _bp

Is there any existing library or repository library available to calculate inverse matrix, especially for large scale matrix?

My license is invalid. How can I get it again ?

Logging on to AIMMS license server failed.May I ask if my account is due?How can I solve the problem? 

Hi Team,Is there any way so that we can auto-schedule our deployed model. For example, In AIMMS Pro, I want to set the app to run automatically every 15 minutes.Regards

Hello,I am working on a model and tried to use WebUI to analyze some results.However, when I tried to open the WebUI, the system says it failed to load all objects with the error message below. awf.data.aimms.session: Running requestGetIdentifierValues for [object Object] has resulted in an error: Unable to retrieve values for all identifiers (code=400) I re-started the AIMMS project, but it didn’t help.Anyone know potential reason for this error?It would be very appreciated. Thank you Best,

Hello, I want to show a user name automatically for every person that uses my model, for example when Jim opens he aimms project, I want the model to detect it’s Jim and  save it in parameter and show it in page my question is how can we detect user infos when the model is opened ?  Thank you

I have an AIMMS project. I have downloaded .lp file from the AIMMS project. Is there any way so that I can compare the the constraints written in .lp file and constraints what I have written inside an AIMMS project.

Hi all,I found the setting to use an intial solution in AIMMS for Gurobi, however, how and where do you efficiently add this initial solution in AIMMS? Can I export an AIMMS output and read it again to use as the intial value? If so, how?  I found this topic, but the link does not work: How to start solving with an initial solution | AIMMS Community

Hello,I am trying to use database procedure function to extract some data from a HANA view database.Unfortunately, table name has dots (“.”), so it seems like AIMMS cannot parse it for SQL query properly. For example, the table name is something like xx.yy.zz/pp, where you can see some dots between xx, yy, and zz.  Can you help us to figure out proper syntax to write sql query with this type of name?Thank you!  

Hi Team,I am trying to solve a furnace loading problem. There are 60 items to be loaded over the furnaces. The number of furnaces are 32 where 16 of them are identical in nature and other 16 are identical in nature. I have modeled it as MIP problem with objective of capacity maximization in terms of weights. Model is giving correct answer but I am facing run time issues, due to the exponential complexity model is taking longer time to solve (almost more than 1 hour). Note that I have created virtual location inside the furnaces due to other constraints and I am also using some constraints to break the symmetry part. One way to reduce run time is to run it through loop but I do not want to use the loop. Is there any alternative way I can handle.  

Ideally, I need this information while running a procedure. I would like to assign it to a parameter. Is there maybe a constraint suffix that I could use to get this information? I’m thinking about something like this: ParameterValue := Constraint.binding

I have a webUI and pipelines running on Azure Data Factory, how do I create an on demand trigger which will be triggered through the webUI to trigger the Azure Data Factory pipelines.