A dimension in an Oracle Essbase database outline. Dimensions define the axes of a multi-dimensional data model and contain hierarchical members. Common dimension types include accounts, time, scenario, entity, and attribute dimensions.
Dimension name as defined in the database outline.
type
string
Dimension type classification. Accounts dimensions hold numeric measures. Time dimensions represent temporal periods. Attribute dimensions provide alternate categorizations.
storageType
string
How the dimension data is stored. Dense dimensions have data at most intersections. Sparse dimensions have data at few intersections.
tag
string
Dimension tag used for categorization and identification within the outline.
memberCount
integer
Total number of members in the dimension hierarchy.
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "oracle-essbase-dimension-schema.json",
"title": "Oracle Essbase Dimension",
"description": "A dimension in an Oracle Essbase database outline. Dimensions define the axes of a multi-dimensional data model and contain hierarchical members. Common dimension types include accounts, time, scenario, entity, and attribute dimensions.",
"type": "object",
"properties": {
"name": {
"type": "string",
"description": "Dimension name as defined in the database outline."
},
"type": {
"type": "string",
"description": "Dimension type classification. Accounts dimensions hold numeric measures. Time dimensions represent temporal periods. Attribute dimensions provide alternate categorizations."
},
"storageType": {
"type": "string",
"description": "How the dimension data is stored. Dense dimensions have data at most intersections. Sparse dimensions have data at few intersections."
},
"tag": {
"type": "string",
"description": "Dimension tag used for categorization and identification within the outline."
},
"memberCount": {
"type": "integer",
"description": "Total number of members in the dimension hierarchy."
}
},
"required": ["name"]
}