RuntimeSubstitutionVariable

A runtime substitution variable for calculation scripts.

AnalyticsBudgetingBusiness IntelligenceFinancial ConsolidationMulti-Dimensional DatabaseOLAPPlanning

Properties

Name	Type	Description
name	string	Variable name.
type	string	Variable data type.
value	object	Default value.
dimension	string	Dimension name (for MEMBER type).
singleChoice	boolean	Whether only a single member can be selected.
allowMissing	boolean	Whether missing data is allowed.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/RuntimeSubstitutionVariable",
  "title": "RuntimeSubstitutionVariable",
  "type": "object",
  "description": "A runtime substitution variable for calculation scripts.",
  "properties": {
    "name": {
      "type": "string",
      "description": "Variable name."
    },
    "type": {
      "type": "string",
      "description": "Variable data type.",
      "enum": [
        "STRING",
        "NUMBER",
        "DATE",
        "MEMBER"
      ]
    },
    "value": {
      "description": "Default value."
    },
    "dimension": {
      "type": "string",
      "description": "Dimension name (for MEMBER type)."
    },
    "singleChoice": {
      "type": "boolean",
      "description": "Whether only a single member can be selected."
    },
    "allowMissing": {
      "type": "boolean",
      "description": "Whether missing data is allowed."
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This JSON Schema

curl "https://apis.io/api/v1/json-schemas/oracle-essbase-runtimesubstitutionvariable"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.