Oracle Essbase

Oracle Essbase Dimensions API

View dimension information, generations, and levels

GitHub OpenAPI

Operations 4

GET /applications/{applicationName}/databases/{databaseName}/dimensions Oracle Essbase List Dimensions #
GET /applications/{applicationName}/databases/{databaseName}/dimensions/{dimensionName} Oracle Essbase Get Dimension #
GET /applications/{applicationName}/databases/{databaseName}/dimensions/{dimensionName}/generations Oracle Essbase List Dimension Generations #
GET /applications/{applicationName}/databases/{databaseName}/dimensions/{dimensionName}/levels Oracle Essbase List Dimension Levels #

Documentation

📖
Documentation
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/index.html
📖
Authentication
https://docs.oracle.com/en/database/other-databases/essbase/21/erest/op-rest-v1-sessions-post.html
📖
GettingStarted
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/api-essbase.html

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/openapi/oracle-essbase-dimensions-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-application-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-database-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-job-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-user-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-session-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-dimension-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-connection-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-script-schema.json
📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-schema/oracle-essbase-filter-schema.json

Other Resources

🔗
Reference
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/rest-endpoints.html
🔗
JSONLDContext
https://raw.githubusercontent.com/api-evangelist/oracle-essbase/refs/heads/main/json-ld/oracle-essbase-context.jsonld

Work with this as data

Every API 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 apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • 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 API 
curl "https://apis.io/api/v1/apis/oracle-essbase-dimensions-api"
All apis 
curl "https://apis.io/api/v1/apis?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.

OpenAPI Specification

oracle-essbase-dimensions-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Essbase REST Application Configuration Dimensions API
  description: RESTful API for managing and interacting with Oracle Essbase applications, databases, and performing analytical operations. Enables automation of Essbase resource management with endpoints for applications, databases, calculations, data loads, user management, sessions, jobs, files, scripts, filters, partitions, connections, datasources, dimensions, outline viewer, locks, scenarios, server properties, and more. All communication occurs over secured HTTP.
  version: 21.0.0
  contact:
    name: Oracle Support
    url: https://support.oracle.com
  license:
    name: Oracle Technology Network License
    url: https://www.oracle.com/legal/terms/
  x-provider: oracle-essbase
servers:
- url: https://{host}:{port}/essbase/rest/v1
  description: Oracle Essbase REST API server
  variables:
    host:
      default: localhost
      description: Essbase server hostname
    port:
      default: '9001'
      description: Essbase server port
security:
- basicAuth: []
- bearerAuth: []
tags:
- name: Dimensions
  description: View dimension information, generations, and levels
paths:
  /applications/{applicationName}/databases/{databaseName}/dimensions:
    get:
      operationId: listDimensions
      summary: Oracle Essbase List Dimensions
      description: Returns a list of dimensions defined in the specified database outline.
      tags:
      - Dimensions
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      responses:
        '200':
          description: Dimension list returned successfully.
          content:
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/Dimension'
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/databases/{databaseName}/dimensions/{dimensionName}:
    get:
      operationId: getDimension
      summary: Oracle Essbase Get Dimension
      description: Returns details of the specified dimension including its name, type, and storage properties.
      tags:
      - Dimensions
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      - name: dimensionName
        in: path
        required: true
        description: Dimension name.
        schema:
          type: string
      responses:
        '200':
          description: Dimension details returned successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Dimension'
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/databases/{databaseName}/dimensions/{dimensionName}/generations:
    get:
      operationId: listDimensionGenerations
      summary: Oracle Essbase List Dimension Generations
      description: Returns the generation hierarchy for the specified dimension.
      tags:
      - Dimensions
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      - name: dimensionName
        in: path
        required: true
        description: Dimension name.
        schema:
          type: string
      responses:
        '200':
          description: Generations returned successfully.
          content:
            application/json:
              schema:
                type: array
                items:
                  type: object
                  properties:
                    number:
                      type: integer
                      format: int32
                      description: Generation number.
                    name:
                      type: string
                      description: Generation name.
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/databases/{databaseName}/dimensions/{dimensionName}/levels:
    get:
      operationId: listDimensionLevels
      summary: Oracle Essbase List Dimension Levels
      description: Returns the level hierarchy for the specified dimension.
      tags:
      - Dimensions
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      - name: dimensionName
        in: path
        required: true
        description: Dimension name.
        schema:
          type: string
      responses:
        '200':
          description: Levels returned successfully.
          content:
            application/json:
              schema:
                type: array
                items:
                  type: object
                  properties:
                    number:
                      type: integer
                      format: int32
                      description: Level number.
                    name:
                      type: string
                      description: Level name.
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
components:
  parameters:
    databaseName:
      name: databaseName
      in: path
      required: true
      description: Essbase database (cube) name.
      schema:
        type: string
    applicationName:
      name: applicationName
      in: path
      required: true
      description: Essbase application name.
      schema:
        type: string
  schemas:
    Dimension:
      type: object
      description: A dimension in an Essbase database outline.
      properties:
        name:
          type: string
          description: Dimension name.
        type:
          type: string
          description: Dimension type (e.g., accounts, time, attribute).
        storageType:
          type: string
          description: Dimension storage type.
        tag:
          type: string
          description: Dimension tag.
        memberCount:
          type: integer
          format: int32
          description: Number of members in the dimension.
    Error:
      type: object
      description: Error response from the Essbase REST API.
      properties:
        message:
          type: string
          description: Human-readable error message.
        errorCode:
          type: string
          description: Machine-readable error code.
        details:
          type: string
          description: Additional error details.
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
      description: HTTP Basic Authentication using Essbase username and password.
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: OAuth 2.0 Bearer token authentication for cloud deployments on Oracle Cloud Infrastructure.