get_cube_sales_cube

Query the 'order_count' cube to analyze key sales metrics like USD amounts and order counts. Group data by dimensions such as customer key, sales year, or month and aggregate measures like total order amounts and gift card usage. Returns formatted results for actionable insights.

Instructions

Tool to query the cube 'order_count'.
Get the key sales metrics: USD amount and number of orders.

Expected inputs:
    dimensions (str): Comma-separated dimension names to group by. Allowed values:
- customer_key: Key for the customer
- sales_year: Year of the sale
- sales_month: Month of the sale

    measures (str): Comma-separated measure names to aggregate (must match cube definition). Allowed values:
- gift_amount_usd: Total gift card amount used for the order in USD
- total_amount_usd: Total order amount in USD
- order_count: Total number of orders

Returns:
    Query result as a formatted response.

Input Schema

Name	Required	Description	Default
`dimensions`	Yes
`measures`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "dimensions": {
      "title": "dimensions",
      "type": "string"
    },
    "measures": {
      "title": "measures",
      "type": "string"
    }
  },
  "required": [
    "dimensions",
    "measures"
  ],
  "title": "get_cube_sales_cubeArguments",
  "type": "object"
}

Teradata MCP Server

get_cube_sales_cube

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Teradata MCP Server

Related Tools

MCP directory API