-
Notifications
You must be signed in to change notification settings - Fork 0
Oms API GET Run Output Table calculated expressions
amc1999 edited this page Mar 14, 2024
·
5 revisions
Read a "page" of output table calculated expression(s) values from model run.
Read output table expression(s) and calculate additrional measures. Measures calculated as one of the following:
- for each table expression calculate one of: avg, sum, count, max, min, var, sd, se, cv
- as arbitrary aggreagated expressions provided as comma separated list
Page is part of output table values defined by zero-based "start" row number and row count. If row count <= 0 then all rows returned.
Dimension(s) returned as enum codes or as string values if dimension type is simple (integer or boolean).
Methods:
GET /api/model/:model/run/:run/table/:name/calc/:calc
GET /api/model/:model/run/:run/table/:name/calc/:calc/start/:start
GET /api/model/:model/run/:run/table/:name/calc/:calc/start/:start/count/:count
Arguments:
:model - (required) model digest or model name
Model can be identified by digest or by model name. It is recommended to use digest because it is uniquely identifies model. It is possible to use model name, which is more human readable than digest, but if there are multiple models with same name in database than result is undefined.
:run - (required) model run digest, run stamp or run name
Model run can be identified by run digest, run stamp or run name. It is recommended to use digest because it is uniquely identifies model run. Run stamp, if not explicitly specified as model run option, automatically generated as timestamp string, ex.: 2016_08_17_21_07_55_123. It is also possible to use name, which is more human readable than digest, but if there are multiple runs with same name in database than result is undefined.
:name - (required) output table name
:calc - (required) name of additional measure to calculate
Additional measure must be one of:
-
avgmean of expression sub-values -
sumsum of expression sub-values -
countcount of expression sub-values (excluding NULL's) -
maxmaximum of expression sub-values -
minminimum of expression sub-values -
varvariance of expression sub-values -
sdstandard deviation of expression sub-values -
sestandard error of expression sub-values -
cvcoefficient of variation of expression sub-values
Or a list of comma-separated aggreagated expressions, for example: OM_AVG(acc0) , 2 * SQRT(OM_SUM(acc1) - OM_SD(acc0))
It is also possible to use parameter(s) in calculation, parameter must be a scalar of float or integer type.
For example: OM_COUNT_IF(acc1 > param.High), where param.High is a value of scalar parameter High in that model run.
Following aggregation functions avaliable:
-
OM_AVGmean of accumulators sub-values -
OM_SUMsum of accumulators sub-values -
OM_COUNTcount of accumulators sub-values (excluding NULL's) -
OM_COUNT_IFcount values matching condition -
OM_MAXmaximum of accumulators sub-values -
OM_MINminimum of accumulators sub-values -
OM_VARvariance of accumulators sub-values -
OM_SDstandard deviation of accumulators sub-values -
OM_SEstandard error of accumulators sub-values -
OM_CVcoefficient of variation of accumulators sub-values
For more details please see: Model Output Expressions
:start - (optional) start "page" row number, zero-based.
:count - (optional) "page" size, number of rows to select, if count <= 0 then all rows selected.
Call examples:
http://localhost:4040/api/model/RiskPaths/run/RiskPaths_Default/table/T04_FertilityRatesByAgeGroup/calc/se
http://localhost:4040/api/model/_201208171604590148_/run/f172e98da17beb058f30f11768053456/table/salarySex/calc/se/start/2
http://localhost:4040/api/model/_201208171604590148_/run/f172e98da17beb058f30f11768053456/table/salarySex/calc/se/start/2/count/4
http://localhost:4040/api/model/_201208171604590148_/run/2019_01_17_19_59_52_998/table/salarySex/calc/se
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/avg
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/sum
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/count
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/min
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/max
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/var
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/sd
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/se
http://localhost:4040/api/model/modelOne/run/Default/table/salarySex/calc/cv
http://localhost:4040/api/model/modelOne/run/Default-4/table/salarySex/calc/OM_AVG(acc0),2*SQRT(OM_SUM(acc1)-OM_SD(acc0))
http://localhost:4040/api/model/modelOne/run/Default-4/table/salarySex/calc/OM_COUNT_IF(acc0%3Cparam.StartingSeed)
Note: OM_COUNT_IF(acc0%3Cparam.StartingSeed) is URL encoded: OM_COUNT_IF(acc0<param.StartingSeed)
Example:
http://localhost:4040/api/model/RiskPaths/run/RiskPaths_Default_4/table/T04_FertilityRatesByAgeGroup/calc/se
[
{
"Dims": [
"(-∞,15)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_AFTER_FIRST_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.01831399787736417,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.31524674743336684,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.05375412945398035,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.7131296479419359,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.27913884088946966,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.03403061129977049,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.6313567713962284,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.054454055397003744,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.8142261153929924,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.22599976710820624,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.02252894224790954,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.552801004995511,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.053909930664369304,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.8095822302661376,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.19515570806104682,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.04149012389398613,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.5994579474940404,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.041598506770988926,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.6024591444120154,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.18708044915078834,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.020349606948328054,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 1.0090672465971064,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.03146736899461647,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.4621989244428227,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.1378516298224034,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.022982490984116696,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.3622228137167969,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0.057202677626031914,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.041649739660050096,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.549536875782365,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.1100888012811952,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.04683269746871016,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.33029219738801313,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.022147682759750396,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.24011920351426697,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.07322050511146887,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.3916092867847636,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.011848889031140083,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.13186273037645685,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.08309987275700664,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.022104741738314906,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.27986398799940426,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0.11444275060810742,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.017525081049451968,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.1577477795548111,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.05727119253571546,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.16945519905993123,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_AFTER_FIRST_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"(-∞,15)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.000973984611518573,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.024860412545759547,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[15,17.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.0021489962375885207,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.016185741408360488,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.04582070104311915,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.025795347742306313,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.7869023105120465,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[17.5,20)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.004127288570814012,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.02043658375123932,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.041408824916237076,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.012711616731356437,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.17542003779519497,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[20,22.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.003881467816107038,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.016193285699936572,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.026391425572356776,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.024820325593176193,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.3528132665325038,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[22.5,25)",
"US_AFTER_SECOND_UNION"
],
"IsNull": true,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.0036557290231329803,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.01959960089317563,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.02072720867372254,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.03151338138462493,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.5935067944778238,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[25,27.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.005196619763242931,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.011665634117207072,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.01945905164366974,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.029555729394609345,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.10422127860974977,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[27.5,30)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0.02670576575482527,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.004163546631457847,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.07776769082434758,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.00807157824867373,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.04520648331822375,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.23240410935784928,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[30,32.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.002133413207162846,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.0522818322110285,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.01949087594847643,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.4087021371108991,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[32.5,35)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.004685194405920375,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.03917868926846236,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.012717967350323902,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0.012339858333394415,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.14037654439621916,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[35,37.5)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0.05343598681843709,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0.003295964388970783,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0.019743934009037976,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0.01043050794857122,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0.11795500304906231,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[37.5,40)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_NEVER_IN_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_FIRST_UNION_PERIOD1"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_FIRST_UNION_PERIOD2"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_AFTER_FIRST_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
},
{
"Dims": [
"[40,∞)",
"US_AFTER_SECOND_UNION"
],
"IsNull": false,
"Value": 0,
"CalcName": "OM_SE_Expr0",
"RunDigest": "b794d3399099035740e117378c523feb"
}
]
- Windows: Quick Start for Model Users
- Windows: Quick Start for Model Developers
- Linux: Quick Start for Model Users
- Linux: Quick Start for Model Developers
- MacOS: Quick Start for Model Users
- MacOS: Quick Start for Model Developers
- Model Run: How to Run the Model
- MIT License, Copyright and Contribution
- Model Code: Programming a model
- Windows: Create and Debug Models
- Linux: Create and Debug Models
- MacOS: Create and Debug Models
- MacOS: Create and Debug Models using Xcode
- Modgen: Convert case-based model to openM++
- Modgen: Convert time-based model to openM++
- Modgen: Convert Modgen models and usage of C++ in openM++ code
- Model Localization: Translation of model messages
- How To: Set Model Parameters and Get Results
- Model Run: How model finds input parameters
- Model Output Expressions
- Model Run Options and ini-file
- OpenM++ Compiler (omc) Run Options
- OpenM++ ini-file format
- UI: How to start user interface
- UI: openM++ user interface
- UI: Create new or edit scenario
- UI: Upload input scenario or parameters
- UI: Run the Model
- UI: Use ini-files or CSV parameter files
- UI: Compare model run results
- UI: Aggregate and Compare Microdata
- UI: Filter run results by value
- UI: Disk space usage and cleanup
- UI Localization: Translation of openM++
-
Highlight: hook to self-scheduling or trigger attribute
-
Highlight: The End of Start
-
Highlight: Enumeration index validity and the
index_errorsoption -
Highlight: Simplified iteration of range, classification, partition
-
Highlight: Parameter, table, and attribute groups can be populated by module declarations
- Oms: openM++ web-service
- Oms: openM++ web-service API
- Oms: How to prepare model input parameters
- Oms: Cloud and model runs queue
- Use R to save output table into CSV file
- Use R to save output table into Excel
- Run model from R: simple loop in cloud
- Run RiskPaths model from R: advanced run in cloud
- Run RiskPaths model in cloud from local PC
- Run model from R and save results in CSV file
- Run model from R: simple loop over model parameter
- Run RiskPaths model from R: advanced parameters scaling
- Run model from Python: simple loop over model parameter
- Run RiskPaths model from Python: advanced parameters scaling
- Windows: Use Docker to get latest version of OpenM++
- Linux: Use Docker to get latest version of OpenM++
- RedHat 8: Use Docker to get latest version of OpenM++
- Quick Start for OpenM++ Developers
- Setup Development Environment
- 2018, June: OpenM++ HPC cluster: Test Lab
- Development Notes: Defines, UTF-8, Databases, etc.
- 2012, December: OpenM++ Design
- 2012, December: OpenM++ Model Architecture, December 2012
- 2012, December: Roadmap, Phase 1
- 2013, May: Prototype version
- 2013, September: Alpha version
- 2014, March: Project Status, Phase 1 completed
- 2016, December: Task List
- 2017, January: Design Notes. Subsample As Parameter problem. Completed
GET Model Metadata
- GET model list
- GET model list including text (description and notes)
- GET model definition metadata
- GET model metadata including text (description and notes)
- GET model metadata including text in all languages
GET Model Extras
GET Model Run results metadata
- GET list of model runs
- GET list of model runs including text (description and notes)
- GET status of model run
- GET status of model run list
- GET status of first model run
- GET status of last model run
- GET status of last completed model run
- GET model run metadata and status
- GET model run including text (description and notes)
- GET model run including text in all languages
GET Model Workset metadata: set of input parameters
- GET list of model worksets
- GET list of model worksets including text (description and notes)
- GET workset status
- GET model default workset status
- GET workset including text (description and notes)
- GET workset including text in all languages
Read Parameters, Output Tables or Microdata values
- Read parameter values from workset
- Read parameter values from workset (enum id's)
- Read parameter values from model run
- Read parameter values from model run (enum id's)
- Read output table values from model run
- Read output table values from model run (enum id's)
- Read output table calculated values from model run
- Read output table calculated values from model run (enum id's)
- Read output table values and compare model runs
- Read output table values and compare model runs (enun id's)
- Read microdata values from model run
- Read microdata values from model run (enum id's)
- Read aggregated microdata from model run
- Read aggregated microdata from model run (enum id's)
- Read microdata run comparison
- Read microdata run comparison (enum id's)
GET Parameters, Output Tables or Microdata values
- GET parameter values from workset
- GET parameter values from model run
- GET output table expression(s) from model run
- GET output table calculated expression(s) from model run
- GET output table values and compare model runs
- GET output table accumulator(s) from model run
- GET output table all accumulators from model run
- GET microdata values from model run
- GET aggregated microdata from model run
- GET microdata run comparison
GET Parameters, Output Tables or Microdata as CSV
- GET csv parameter values from workset
- GET csv parameter values from workset (enum id's)
- GET csv parameter values from model run
- GET csv parameter values from model run (enum id's)
- GET csv output table expressions from model run
- GET csv output table expressions from model run (enum id's)
- GET csv output table accumulators from model run
- GET csv output table accumulators from model run (enum id's)
- GET csv output table all accumulators from model run
- GET csv output table all accumulators from model run (enum id's)
- GET csv calculated table expressions from model run
- GET csv calculated table expressions from model run (enum id's)
- GET csv model runs comparison table expressions
- GET csv model runs comparison table expressions (enum id's)
- GET csv microdata values from model run
- GET csv microdata values from model run (enum id's)
- GET csv aggregated microdata from model run
- GET csv aggregated microdata from model run (enum id's)
- GET csv microdata run comparison
- GET csv microdata run comparison (enum id's)
GET Modeling Task metadata and task run history
- GET list of modeling tasks
- GET list of modeling tasks including text (description and notes)
- GET modeling task input worksets
- GET modeling task run history
- GET status of modeling task run
- GET status of modeling task run list
- GET status of modeling task first run
- GET status of modeling task last run
- GET status of modeling task last completed run
- GET modeling task including text (description and notes)
- GET modeling task text in all languages
Update Model Profile: set of key-value options
- PATCH create or replace profile
- DELETE profile
- POST create or replace profile option
- DELETE profile option
Update Model Workset: set of input parameters
- POST update workset read-only status
- PUT create new workset
- PUT create or replace workset
- PATCH create or merge workset
- DELETE workset
- POST delete multiple worksets
- DELETE parameter from workset
- PATCH update workset parameter values
- PATCH update workset parameter values (enum id's)
- PATCH update workset parameter(s) value notes
- PUT copy parameter from model run into workset
- PATCH merge parameter from model run into workset
- PUT copy parameter from workset to another
- PATCH merge parameter from workset to another
Update Model Runs
- PATCH update model run text (description and notes)
- DELETE model run
- POST delete model runs
- PATCH update run parameter(s) value notes
Update Modeling Tasks
Run Models: run models and monitor progress
Download model, model run results or input parameters
- GET download log file
- GET model download log files
- GET all download log files
- GET download files tree
- POST initiate entire model download
- POST initiate model run download
- POST initiate model workset download
- DELETE download files
- DELETE all download files
Upload model runs or worksets (input scenarios)
- GET upload log file
- GET all upload log files for the model
- GET all upload log files
- GET upload files tree
- POST initiate model run upload
- POST initiate workset upload
- DELETE upload files
- DELETE all upload files
Download and upload user files
- GET user files tree
- POST upload to user files
- PUT create user files folder
- DELETE file or folder from user files
- DELETE all user files
User: manage user settings
Model run jobs and service state
- GET service configuration
- GET job service state
- GET disk usage state
- POST refresh disk space usage info
- GET state of active model run job
- GET state of model run job from queue
- GET state of model run job from history
- PUT model run job into other queue position
- DELETE state of model run job from history
Administrative: manage web-service state
- POST a request to refresh models catalog
- POST a request to close models catalog
- POST a request to close model database
- POST a request to delete the model
- POST a request to open database file
- POST a request to cleanup database file
- GET the list of database cleanup log(s)
- GET database cleanup log file(s)
- POST a request to pause model run queue
- POST a request to pause all model runs queue
- PUT a request to shutdown web-service