DMTable

The type code is DMT

formulaName
string <= 255 characters
reservedWords
Array of strings
lastUpdateByName
string
typedId
string
keyFieldNames
Array of strings
lastUpdateDate
string <date-time>
fieldNames
Array of strings
dbTable
string
deployed
boolean
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
rowCount
integer
locked
boolean
createDate
string <date-time>
lastDataModificationDate
string <date-time>
owner
string <= 255 characters
calculationMessages
string
targetDate
string <date-time>
object
property name*
additional property
string
label
string <= 255 characters
version
integer
dbKey
string
queryable
boolean
dbView
string
uniqueName
string <= 255 characters
createdBy
integer
object
property name*
additional property
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
system
boolean
numeric
boolean
key
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
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"
    ],
  • "lastUpdateDate": "2019-08-24T14:15:22Z",
  • "fieldNames": [
    • "string"
    ],
  • "dbTable": "string",
  • "deployed": true,
  • "type": "DATASOURCE",
  • "calculationDate": "string",
  • "sourceFile": "string",
  • "valid": true,
  • "view": true,
  • "loadableFields": [
    • "string"
    ],
  • "keyFields": [
    • { }
    ],
  • "auxiliary": true,
  • "rowCount": 0,
  • "locked": true,
  • "createDate": "2019-08-24T14:15:22Z",
  • "lastDataModificationDate": "2019-08-24T14:15:22Z",
  • "owner": "string",
  • "calculationMessages": "string",
  • "targetDate": "2019-08-24T14:15:22Z",
  • "query": {
    • "property1": "string",
    • "property2": "string"
    },
  • "label": "string",
  • "version": 0,
  • "dbKey": "string",
  • "queryable": true,
  • "dbView": "string",
  • "uniqueName": "string",
  • "createdBy": 0,
  • "messages": {
    • "property1": "string",
    • "property2": "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"
        },
      • "system": true,
      • "numeric": true,
      • "key": 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",
  • "status": "DRAFT",
  • "lastUpdateBy": 0
}