Skip to content

Tool Reference

AgentCube exposes Oracle EPM data through MCP tools. Each tool maps to one or more Oracle REST API operations, returning structured data that AI assistants use to answer user questions.

Connectors

Connector Oracle System Tools
Essbase Connector Oracle Essbase 21c 9 tools
Planning Connector Oracle EPM Planning Cloud (EPBCS/PBCS) 12 tools

Common Tools

Both connectors share these tools with identical behavior:

Tool Purpose
mcp_connector_status Returns connector health, version, uptime, and backend connectivity
test_datasource Tests connectivity to the configured Oracle system
list_applications Lists all applications the authenticated user can access

Common Patterns

A typical workflow for exploring data:

  1. list_applications — find available applications
  2. list_cubes / list_plan_types — find cubes or plan types within an application
  3. get_cube_schema / get_plan_type_schema — understand the dimension structure
  4. list_dimension_members — browse members within a dimension
  5. get_member_info — get details about a specific member
  6. query_cube_data / execute_mdx / query_data_grid — retrieve data

Member Names and Aliases

Oracle EPM treats member names and aliases as interchangeable in most API calls. When specifying members in tool parameters, you can use either the member name or its alias.