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"
}