Skip to content
Casabase CubeCasabase Cube Documentation

Agent Procedures

The procedures in this section are designed for Cortex Agent and MCP consumption. They provide AI-friendly wrappers over core Casabase Cube functionality.

Most agent procedures take a single JSON string and return VARIANT, a shape that AI tools can consume easily. AGENT_QUERY, AGENT_SEARCH_MEMBERS, AGENT_DISCOVER, and AGENT_HEALTH_CHECK use explicit arguments as shown below.

AGENT_QUERY

Section titled “AGENT_QUERY”

Minimum role: CUBE_PUBLIC

AGENT_QUERY(cube, pov, formulas) -> VARIANT

Wraps QUERY_CUBE and returns the query result as JSON.

Example

Section titled “Example”
CALL CUBE.AGENT_QUERY(
    'FINANCE',
    '{"MEASURES":["Units"],"TIME":["Qtr1"],"YEARS":["Curr Year"]}',
    NULL
);

AGENT_SEARCH_MEMBERS

Section titled “AGENT_SEARCH_MEMBERS”

Minimum role: CUBE_PUBLIC

AGENT_SEARCH_MEMBERS(cube, dimension, search) -> VARIANT

Wraps member search functionality for agent use.

AGENT_DISCOVER

Section titled “AGENT_DISCOVER”

Minimum role: CUBE_PUBLIC

AGENT_DISCOVER(cube) -> VARIANT

Returns cube and dimension discovery information in an agent-friendly format.

AGENT_HEALTH_CHECK

Section titled “AGENT_HEALTH_CHECK”

Minimum role: CUBE_PUBLIC

AGENT_HEALTH_CHECK(cube) -> VARIANT

Wraps HEALTH_CHECK for agent use.

AGENT_GET_COLUMNS

Section titled “AGENT_GET_COLUMNS”

Minimum role: CUBE_ADMIN

AGENT_GET_COLUMNS(table) -> VARIANT

Returns column metadata for a table.

AGENT_LIST_TABLES

Section titled “AGENT_LIST_TABLES”

Minimum role: CUBE_ADMIN

AGENT_LIST_TABLES(schema, pattern) -> VARIANT

Returns a table listing, optionally filtered by a pattern.

AGENT_CLONE_CUBE

Section titled “AGENT_CLONE_CUBE”

Minimum role: CUBE_ADMIN

AGENT_CLONE_CUBE(params) -> VARIANT

Agent-facing wrapper over CLONE_CUBE.

AGENT_REBUILD_CUBE

Section titled “AGENT_REBUILD_CUBE”

Minimum role: CUBE_ADMIN

AGENT_REBUILD_CUBE(params) -> VARIANT

Agent-facing wrapper over REBUILD_DIMENSIONS.

AGENT_IMPORT_DATA

Section titled “AGENT_IMPORT_DATA”

Minimum role: CUBE_ADMIN

AGENT_IMPORT_DATA(params) -> VARIANT

Agent-facing wrapper over LOAD_DATA.

AGENT_EXPORT_CONFIG

Section titled “AGENT_EXPORT_CONFIG”

Minimum role: CUBE_ADMIN

AGENT_EXPORT_CONFIG(params) -> VARIANT

Agent-facing wrapper over EXPORT_CUBE_CONFIG.

AGENT_IMPORT_CONFIG

Section titled “AGENT_IMPORT_CONFIG”

Minimum role: CUBE_ADMIN

AGENT_IMPORT_CONFIG(params) -> VARIANT

Agent-facing wrapper over IMPORT_CUBE_CONFIG.

AGENT_VALIDATE_DIMENSION

Section titled “AGENT_VALIDATE_DIMENSION”

Minimum role: CUBE_ADMIN

AGENT_VALIDATE_DIMENSION(params) -> VARIANT

Agent-facing wrapper over VALIDATE_DIMENSION.

AGENT_SNAPSHOT_DIMENSION

Section titled “AGENT_SNAPSHOT_DIMENSION”

Minimum role: CUBE_ADMIN

AGENT_SNAPSHOT_DIMENSION(params) -> VARIANT

Agent-facing wrapper over SNAPSHOT_DIMENSION.

AGENT_ROLLBACK_DIMENSION

Section titled “AGENT_ROLLBACK_DIMENSION”

Minimum role: CUBE_ADMIN

AGENT_ROLLBACK_DIMENSION(params) -> VARIANT

Agent-facing wrapper over RESTORE_DIMENSION_SNAPSHOT.

AGENT_COMPARE_SNAPSHOTS

Section titled “AGENT_COMPARE_SNAPSHOTS”

Minimum role: CUBE_ADMIN

AGENT_COMPARE_SNAPSHOTS(params) -> VARIANT

Provides snapshot comparison functionality for an agent.

AGENT_EDIT_MEMBER

Section titled “AGENT_EDIT_MEMBER”

Minimum role: CUBE_ADMIN

AGENT_EDIT_MEMBER(params) -> VARIANT

Provides agent-facing member maintenance operations, including add, rename, move, and delete.

AGENT_SET_VARIABLE

Section titled “AGENT_SET_VARIABLE”

Minimum role: CUBE_ADMIN

AGENT_SET_VARIABLE(params) -> VARIANT

Agent-facing wrapper over MANAGE_CUBE_VAR.

AGENT_RUN_SAVED_QUERY

Section titled “AGENT_RUN_SAVED_QUERY”

Minimum role: CUBE_ADMIN

AGENT_RUN_SAVED_QUERY(params) -> VARIANT

Runs a saved query and returns the result rows as JSON.

Example

Section titled “Example”
CALL CUBE.AGENT_RUN_SAVED_QUERY(
    '{"cube_name":"FINANCE","query_name":"Monthly P&L"}'
);

AGENT_TRANSLATE_FORMULA

Section titled “AGENT_TRANSLATE_FORMULA”

Minimum role: CUBE_ADMIN

AGENT_TRANSLATE_FORMULA(params) -> VARIANT

Agent-facing wrapper over IMPORT_ESSBASE_FORMULA.

AGENT_DATA_AUDIT

Section titled “AGENT_DATA_AUDIT”

Minimum role: CUBE_ADMIN

AGENT_DATA_AUDIT(params) -> VARIANT

Performs a data integrity audit for agent consumption.

AGENT_PERFORMANCE_REPORT

Section titled “AGENT_PERFORMANCE_REPORT”

Minimum role: CUBE_ADMIN

AGENT_PERFORMANCE_REPORT(params) -> VARIANT

Agent-facing wrapper over PERFORMANCE_REPORT.