essbase_grid

This Essbase MCP Server tool enables you to run grid-oriented read operations.

This tool supports following actions:

• default
• execute_grid
• execute_layout
• layout_grid
• mdx_report

Use essbase_query action to run simple ad hoc MDX query. Use this tool when the client has grid/layout payloads or saved MDX reports.

Parameters

• action (string) — required — Operation to perform.
• app_name (string) — required — Essbase application name.
• db_name (string) — required — Essbase database/cube name.
• payload (string) — JSON object/string or XML string required by the selected action.
• layout (string) — Saved grid layout name.
• report_name (string) — Report name, such as an MDX or drill-through report.

Minimum Profile

viewer