Skip to main content
Glama
bintocher

Qlik Sense MCP Server

by bintocher
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

engine_create_hypercube

Create multi-dimensional data cubes for analysis with customizable sorting, including top-N results via expression-based dimension sorting.

Instructions

Create hypercube for data analysis with custom sorting options. IMPORTANT: To get top-N records, use qSortByExpression: 1 in dimension sorting with qExpression containing the measure formula (e.g., 'Count(field)' for ascending, '-Count(field)' for descending). Measure sorting is ignored by Qlik Engine.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
app_idYesApplication ID
dimensionsNoList of dimension definitions with optional sorting
measuresNoList of measure definitions with optional sorting
max_rowsNoMaximum rows to return

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed9 schema fields changedv1.0.0
    • changedInput schema / properties / dimensions / description
      Previous value: -"List of dimension fields"New value: +"List of dimension definitions with optional sorting"
    • addedInput schema / properties / dimensions / items / additionalProperties
      Added value: +false
    • addedInput schema / properties / dimensions / items / properties
      Added value: +{
+  "field": {
+    "description": "Field name for dimension",
+    "type": "string"
+  },
+  "label": {
+    "description": "Optional label for dimension",
+    "type": "string"
+  },
+  "sort_by": {
+    "additionalProperties": false,
+    "properties": {
+      "qExpression": {
+        "default": "",
+        "description": "Expression for custom sorting. For top-N: 'Count(field)' for ascending, '-Count(field)' for descending",
+        "type": "string"
+      },
+      "qSortByAscii": {
+        "default": 1,
+        "description": "Sort by ASCII value (-1 desc, 0 none, 1 asc)",
+        "type": "integer"
+      },
+      "qSortByExpression": {
+        "default": 0,
+        "description": "Use expression for sorting (0/1). For top-N results, set to 1 and use qExpression with measure formula",
+        "type": "integer"
+      },
+      "qSortByNumeric": {
+        "default": 0,
+        "description": "Sort by numeric value (-1 desc, 0 none, 1 asc)",
+        "type": "integer"
+      }
+    },
+    "type": "object"
+  }
+}
    • changedInput schema / properties / dimensions / items / type
      Previous value: -"string"New value: +"object"
    • changedInput schema / properties / measures / description
      Previous value: -"List of measure expressions"New value: +"List of measure definitions with optional sorting"
    • addedInput schema / properties / measures / items / additionalProperties
      Added value: +false
    • addedInput schema / properties / measures / items / properties
      Added value: +{
+  "expression": {
+    "description": "Measure expression",
+    "type": "string"
+  },
+  "label": {
+    "description": "Optional label for measure",
+    "type": "string"
+  },
+  "sort_by": {
+    "additionalProperties": false,
+    "properties": {
+      "qSortByNumeric": {
+        "default": -1,
+        "description": "Sort by numeric value (-1 desc, 0 none, 1 asc). NOTE: Measure sorting is ignored by Qlik Engine - use dimension sorting with qSortByExpression for top-N results",
+        "type": "integer"
+      }
+    },
+    "type": "object"
+  }
+}
    • changedInput schema / properties / measures / items / type
      Previous value: -"string"New value: +"object"
    • changedInput schema / required
      Previous value: -[
-  "app_id",
-  "dimensions",
-  "measures"
-]New value: +[
+  "app_id"
+]
  2. First observed

TDQS

A3.6/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It adds valuable context beyond the input schema by explaining that 'Measure sorting is ignored by Qlik Engine' and providing specific guidance on how to achieve top-N results using qSortByExpression. This clarifies important behavioral traits not evident from the schema alone.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is appropriately sized with two sentences that are front-loaded with the main purpose. The second sentence provides crucial implementation details without unnecessary elaboration. Every sentence earns its place, though it could be slightly more structured for clarity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity of the tool (4 parameters with nested objects, no output schema, and no annotations), the description is somewhat complete but has gaps. It explains key behavioral aspects like the engine's handling of measure sorting, but doesn't cover other potential behaviors such as error conditions, performance implications, or what the created hypercube output entails. This is adequate but with clear room for improvement.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 100%, so the schema already documents all parameters thoroughly. The description adds some semantic value by explaining the purpose of qSortByExpression for top-N results and clarifying that measure sorting is ignored, but it doesn't provide significant additional meaning beyond what's in the schema descriptions. This meets the baseline of 3 for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool creates a hypercube for data analysis with custom sorting options, providing a specific verb ('create') and resource ('hypercube'). However, it doesn't explicitly differentiate this tool from its siblings (which are all 'get' operations), though the distinction is implied by the 'create' action versus their 'get' actions.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides implicit usage guidance by mentioning 'To get top-N records, use qSortByExpression: 1 in dimension sorting,' which suggests when to use certain parameters. However, it doesn't explicitly state when to use this tool versus alternatives (e.g., compared to sibling 'get' tools) or provide clear exclusions, leaving some context to inference.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools