File:RDB connection.ANA: Difference between revisions

Connection module for writing variable results into the Result database. You can freely open and use the module, but you cannot actually write information into the Result database unless you have a password.

Note that the necessary variable, index, dimension, and run information will be asked. You must fill in all tables before the process is completed.

Note! You can insert several variables at the same time. Each variable MUST have at least one index.

For reading results from the database, see RDB reader.ANA.

To do: improvement needs

• Run_list table needs the field Var_id. This will help identification of variables in each run without the need to go through result_id. The model should contain formula to fill it.
• Loc_of_result.Ind_id must be updated in the RDB. Now it is empty. Does the model contain formula to fill it?
• There should be a button for converting nodes into edit tables. This is because some models are using external data that cannot be accessed with other versions than Analytica Enterprise. The button would simply do (Va1:= Va1) for each variable in the variable list.
• The correct IP should be used so that the model works in the Internet as well. The correct IP is 193.167.179.97.

SQL code in the model

SQL for Dimension table:

SELECT Dim_id, Dim_name 
FROM `Dimension` 

SQL for Indices table:

SELECT Ind_id, Ind_name, Dimension.Dim_id, Dim_name 
FROM `Index`, Dimension
WHERE `Index`.Dim_id=Dimension.Dim_id 

SQL for Locations table:

SELECT Loc_id, Location, Dimension.Dim_id, Dim_name 
FROM `Location`, `Dimension` WHERE Location.Dim_id = Dimension.Dim_id 

SQL for Variables table:

SELECT Var_id, Var_name 
FROM `Variable`