DMSimDatamart

The type code is DMSIM

formulaName
string <= 255 characters
reservedWords
Array of strings
lastUpdateByName
string
typedId
string
keyFieldNames
Array of strings
sources
Array of strings
lastUpdateDate
string <date-time>
itemClassName
string
fieldNames
Array of strings
dbTable
string
deployed
boolean
source
string <= 255 characters
type
string
Possible values: "DATASOURCE" "DS_VIEW" "DATAMART" "SIM_DATAMART" "FEED" "DW_TABLE" "MODEL" "VIEW" "ROLLUP"
calculationDate
string
sourceFile
string <= 255 characters
valid
boolean
view
boolean
loadableFields
Array of strings
keyFields
Array of objects
auxiliary
boolean
normalization
string <= 255 characters
Possible values: "NONE" "LOW" "MEDIUM" "HIGH" "VIEW"
rowCount
integer
locked
boolean
createDate
string <date-time>
lastDataModificationDate
string <date-time>
calculationMessages
string
localFields
Array of strings
targetDate
string <date-time>
object
property name*
additional property
string
isPlasma
boolean
label
string <= 255 characters
version
integer
Array of objects
Array
skuField
string
targetDateField
string
simulationSet
string
formulaName
string
targetDate
string <date-time>
feederFormulaName
string
Array of objects
Array
name
string
label
string
lookupTableId
string
url
string
type
string
value
string
valueHint
string
readOnly
boolean
object
parameterGroup
string
required
boolean
labelTranslations
string
addUnknownValues
boolean
typedId
string
alwaysEditable
boolean
inputs
Array of objects
object
object
valueOptions
Array of strings
inputParams
Array of objects
mappingParams
Array of objects
Array of objects
Array
elementName
string
elementLabel
string
formulaName
string
formulaDate
string <date-time>
elementGroups
Array of strings
formatType
string
Possible values: "NUMERIC" "NUMERIC_LONG" "MONEY" "PERCENT" "TEXT" "MONEY_EUR" "MONEY_USD" "MONEY_GBP" "MONEY_JPY" "MONEY_CHF" "MONEY_PLN" "DATETIME" "DATE" "INTEGER" "LINK" "COMPLEX" "SPARKLINE"
key
boolean
selected
boolean
displayedInPriceShop
boolean
targetFields
Array of strings
name
string
enabled
boolean
distributed
boolean
dbKey
string
queryable
boolean
dbView
string
uniqueName
string <= 255 characters
createdBy
integer
itemClass
string <= 255 characters
object
property name*
additional property
string
baseCcyCode
string
sourceName
string
Array of objects
Array
name
string
label
string
object
property name*
additional property
string
rank
integer
format
string
measureType
string
Possible values: "PERUNIT" "EXTENDED" "FIXED"
functionalType
string
Possible values: "PERUNITBASIS" "PERCENTBASIS" "PRICINGDATE" "LEVEL" "ALTKEY" "OBSOLETE_CONVERSIONFROM" "OBSOLETE_CONVERSIONTO" "OBSOLETE_CONVERSIONRATE" "OBSOLETE_BASECCY" "OBSOLETE_BASEUOM" "TIMEDIMENSION" "OBSOLETE_DELETE"
visibility
integer
defaultValue
string
sourceField
string
expression
string
function
string
Possible values: "SUM" "AVG" "MIN" "MAX" "COUNT" "EVERY" "ANY" "COUNTDISTINCT" "COUNT_DISTINCT" "PERCENTILE_DISC" "PERCENTILE_CONT" "ROW_NUMBER" "ROW_ID" "PERCENT_RANK" "CUME_DIST" "NTILE" "BIN_IDX" "BIN_ABS" "BIN_PCT" "ISNULL" … 32 more
formulaElement
string
object
property name*
additional property
string
numeric
boolean
key
boolean
system
boolean
deleted
boolean
calculated
boolean
persisted
boolean
dimension
boolean
deployed
boolean
queryable
boolean
auxiliary
boolean
partitioningKey
boolean
time
boolean
aggregation
boolean
dbColumn
string
dbTable
string
type
string
Possible values: "NUMBER" "QUANTITY" "TEXT" "DATE" "MONEY" "CURRENCY" "UOM" "LOB" "DATETIME" "BOOLEAN" "INTEGER"
source
string
owningFC
string
calculationStartDate
string
baseUomCode
string
status
string
Possible values: "DRAFT" "PENDING" "SCHEDULED" "PROCESSING" "SCHEDULED_DIRTY" "ERROR" "READY" "CANCELLED"
lastUpdateBy
integer
{
  • "formulaName": "string",
  • "reservedWords": [
    • "string"
    ],
  • "lastUpdateByName": "string",
  • "typedId": "string",
  • "keyFieldNames": [
    • "string"
    ],
  • "sources": [
    • "string"
    ],
  • "lastUpdateDate": "2019-08-24T14:15:22Z",
  • "itemClassName": "string",
  • "fieldNames": [
    • "string"
    ],
  • "dbTable": "string",
  • "deployed": true,
  • "source": "string",
  • "type": "DATASOURCE",
  • "calculationDate": "string",
  • "sourceFile": "string",
  • "valid": true,
  • "view": true,
  • "loadableFields": [
    • "string"
    ],
  • "keyFields": [
    • { }
    ],
  • "auxiliary": true,
  • "normalization": "NONE",
  • "rowCount": 0,
  • "locked": true,
  • "createDate": "2019-08-24T14:15:22Z",
  • "lastDataModificationDate": "2019-08-24T14:15:22Z",
  • "calculationMessages": "string",
  • "localFields": [
    • "string"
    ],
  • "targetDate": "2019-08-24T14:15:22Z",
  • "query": {
    • "property1": "string",
    • "property2": "string"
    },
  • "isPlasma": true,
  • "label": "string",
  • "version": 0,
  • "simulations": [
    • {
      • "skuField": "string",
      • "targetDateField": "string",
      • "simulationSet": "string",
      • "formulaName": "string",
      • "targetDate": "2019-08-24T14:15:22Z",
      • "feederFormulaName": "string",
      • "feederInputParams": [
        • {
          }
        ],
      • "inputParams": [
        • { }
        ],
      • "mappingParams": [
        • { }
        ],
      • "outputElements": [
        • {
          }
        ],
      • "targetFields": [
        • "string"
        ],
      • "name": "string",
      • "enabled": true,
      • "distributed": true
      }
    ],
  • "dbKey": "string",
  • "queryable": true,
  • "dbView": "string",
  • "uniqueName": "string",
  • "createdBy": 0,
  • "itemClass": "string",
  • "messages": {
    • "property1": "string",
    • "property2": "string"
    },
  • "baseCcyCode": "string",
  • "sourceName": "string",
  • "fields": [
    • {
      • "name": "string",
      • "label": "string",
      • "labelTranslations": {
        • "property1": "string",
        • "property2": "string"
        },
      • "rank": 0,
      • "format": "string",
      • "measureType": "PERUNIT",
      • "functionalType": "PERUNITBASIS",
      • "visibility": 0,
      • "defaultValue": "string",
      • "sourceField": "string",
      • "expression": "string",
      • "function": "SUM",
      • "formulaElement": "string",
      • "messages": {
        • "property1": "string",
        • "property2": "string"
        },
      • "numeric": true,
      • "key": true,
      • "system": true,
      • "deleted": true,
      • "calculated": true,
      • "persisted": true,
      • "dimension": true,
      • "deployed": true,
      • "queryable": true,
      • "auxiliary": true,
      • "partitioningKey": true,
      • "time": true,
      • "aggregation": true,
      • "dbColumn": "string",
      • "dbTable": "string",
      • "type": "NUMBER",
      • "source": "string",
      • "owningFC": "string"
      }
    ],
  • "calculationStartDate": "string",
  • "baseUomCode": "string",
  • "status": "DRAFT",
  • "lastUpdateBy": 0
}