execute_cube_query
Execute advanced analytics queries on SD Elements security development data using Cube API to extract insights from activity, application, countermeasure, and other schemas with customizable dimensions, measures, and filters.
Instructions
Execute a Cube API query for advanced analytics. The query parameter can be a JSON string or object.
Query structure (see https://docs.sdelements.com/master/cubeapi/):
schema: Required. One of: activity, application, countermeasure, integration, library, project_survey_answers, training, trend_application, trend_projects, trend_tasks, user
dimensions: Required. Array like ["Application.name", "Project.id"]
measures: Required. Array like ["Project.count", "Task.completeCount"]
filters: Optional. Array of objects with member, operator (equals/contains/gt/etc), values
order: Optional. 2D array like [["Application.name", "asc"], ["Project.count", "desc"]]
limit: Optional. Number to limit results
time_dimensions: Optional. For Trend Reports only (trend_application, trend_projects, trend_tasks)
Example: {"schema": "application", "dimensions": ["Application.name"], "measures": ["Project.count"], "limit": 10}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | Cube query (JSON string or object) |