Originally posted by: FireFox159

Hi to all !
I have a rather technical question for you guys, I've been trying to solve it for quite some while and thought finally putting it out here might be the key :)

I load a ODBC database into ILOG structured like this:

From

To

Time

Total

I would like to access this data in my model in this fashion TTFromToTime=Total.
Yet I can't see to find how this should be done...

And extra to this probably relatively small problem is the following:
I should be able to define the time using a decision variable in my model. The decision variable is for example t[i][j][m].
However, R is also a decision variable since it is directly dependent on t[i][j][m].
Example:
R[i][j][t[i][j]m] = Total (looked up from the database of course).

Thank you for your assistance.
With highest regards
Gijs
#DecisionOptimization
#MathematicalProgramming-General

Originally posted by: SystemAdmin

It is hard to read what you really want to do, because the forum software messes up your input.
Could you please explain again, embracing the mathematical parts with "code" keywords (in curly braces, see help on the right hand side when editing)?

My guess is that you want to access constant data elements and variables with indices that are decision variables, right? This can be done with CPO (the constraint programming engine) using the "element" constraint. With integer programming this is not so easy. You typically would model this with tons of binary variables.
Tobias
#DecisionOptimization
#MathematicalProgramming-General