> ## Documentation Index > Fetch the complete documentation index at: https://docs.reelevant.com/llms.txt > Use this file to discover all available pages before exploring further. # Execute and persist one authorized Statistics query as report evidence ## OpenAPI ````yaml https://openapi.production.reelevant.io/v1/render/statistics post /reports/{reportId}/generations/{generationId}/queries openapi: 3.0.0 info: title: statistics version: 44efd88c5f14f4c3ad43726185fe340ffc0152ec description: >- # Errors | Error code | Message | HTTP status code | Payload | | :--- | :--- | :--- | :--- | | 9000,9001,9002,9003,9004,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9018,9019,9020,9021,9022,9023,9024,9025,9026,9027,9028,9029,9030,9031,9032,9033,9034 | A tag key with this name already exists | 409 | ```{"name":"string"}``` | servers: - url: https://api.reelevant.com/v2/statistics/ description: production security: [] paths: /reports/{reportId}/generations/{generationId}/queries: post: tags: - AnalysisReports summary: Execute and persist one authorized Statistics query as report evidence operationId: execute-analysis-report-query parameters: - name: reportId in: path schema: type: string required: true - name: generationId in: path schema: type: string required: true requestBody: required: true content: application/json: schema: type: object properties: measures: type: array items: type: string description: List of measure id dimensions: type: array items: type: string description: List of dimension id filters: type: array items: $ref: '#/components/schemas/BinaryFilter' description: |- CubeJS filters on dimension values Note: It's not possible to filter on virtual measures timeDimensions: type: array items: oneOf: - allOf: - $ref: '#/components/schemas/TimeDimensionBase' - $ref: '#/components/schemas/TimeDimensionComparisonFields' - allOf: - $ref: '#/components/schemas/TimeDimensionBase' - $ref: '#/components/schemas/TimeDimensionRangedFields' description: Time filters limit: type: number order: oneOf: - $ref: '#/components/schemas/TQueryOrderObject' - type: array items: type: array items: oneOf: - type: string - oneOf: - type: string enum: - asc - type: string enum: - desc operationId: type: string description: >- Deterministic identity of this query operation. Replaying the same operationId returns the evidence already persisted for it without re-running the query nor consuming the generation budget. executionId: type: string description: |- Execution identity received with the generation request. The generation rejects calls from any other execution. required: - measures - dimensions - filters - timeDimensions - operationId - executionId additionalProperties: false responses: '200': description: Ok content: application/json: schema: allOf: - type: object properties: status: type: string enum: - success required: - status additionalProperties: false - $ref: >- #/components/schemas/InternalResponse_AnalysisReportEvidenceResponse security: - password_auth: [] components: schemas: BinaryFilter: type: object properties: dimension: type: string member: type: string operator: oneOf: - type: string enum: - equals - type: string enum: - notEquals - type: string enum: - contains - type: string enum: - notContains - type: string enum: - startsWith - type: string enum: - notStartsWith - type: string enum: - endsWith - type: string enum: - notEndsWith - type: string enum: - gt - type: string enum: - gte - type: string enum: - lt - type: string enum: - lte - type: string enum: - inDateRange - type: string enum: - notInDateRange - type: string enum: - beforeDate - type: string enum: - beforeOrOnDate - type: string enum: - afterDate - type: string enum: - afterOrOnDate values: type: array items: type: string required: - operator - values additionalProperties: false TimeDimensionBase: type: object properties: dimension: type: string granularity: type: string required: - dimension additionalProperties: false TimeDimensionComparisonFields: type: object properties: compareDateRange: type: array items: oneOf: - type: string - type: array items: oneOf: - type: string - type: string required: - compareDateRange additionalProperties: false TimeDimensionRangedFields: type: object properties: dateRange: oneOf: - type: string - type: array items: oneOf: - type: string - type: string additionalProperties: false TQueryOrderObject: type: object properties: {} additionalProperties: oneOf: - type: string enum: - asc - type: string enum: - desc InternalResponse_AnalysisReportEvidenceResponse: type: object properties: program: type: string version: type: string datetime: type: string status: type: string code: type: number message: type: string data: $ref: '#/components/schemas/AnalysisReportEvidenceResponse' required: - program - version - datetime - status - message - data additionalProperties: false AnalysisReportEvidenceResponse: type: object properties: evidence: $ref: '#/components/schemas/AnalysisReportEvidence' required: - evidence additionalProperties: false AnalysisReportEvidence: type: object properties: id: type: string operationId: type: string query: $ref: '#/components/schemas/Query' rows: type: array items: type: object properties: {} additionalProperties: $ref: '#/components/schemas/AnalysisReportEvidenceCell' sources: type: array items: $ref: '#/components/schemas/AnalysisReportEvidenceSource' freshness: $ref: '#/components/schemas/AnalysisReportEvidenceFreshness' state: $ref: '#/components/schemas/AnalysisReportEvidenceState' warning: type: string failureCode: type: string failureMessage: type: string executedAt: type: string format: date-time durationMs: type: number rowCount: type: number embeddedRowCount: type: number payloadBytes: type: number resultHash: type: string required: - id - query - rows - sources - freshness - state - executedAt - durationMs - rowCount - embeddedRowCount - payloadBytes - resultHash additionalProperties: false Query: type: object properties: measures: type: array items: type: string description: List of measure id dimensions: type: array items: type: string description: List of dimension id filters: type: array items: $ref: '#/components/schemas/BinaryFilter' description: |- CubeJS filters on dimension values Note: It's not possible to filter on virtual measures timeDimensions: type: array items: oneOf: - allOf: - $ref: '#/components/schemas/TimeDimensionBase' - $ref: '#/components/schemas/TimeDimensionComparisonFields' - allOf: - $ref: '#/components/schemas/TimeDimensionBase' - $ref: '#/components/schemas/TimeDimensionRangedFields' description: Time filters limit: type: number order: oneOf: - $ref: '#/components/schemas/TQueryOrderObject' - type: array items: type: array items: oneOf: - type: string - oneOf: - type: string enum: - asc - type: string enum: - desc required: - measures - dimensions - filters - timeDimensions additionalProperties: false AnalysisReportEvidenceCell: type: object properties: value: oneOf: - type: string - type: number - type: boolean enum: - 'false' - type: boolean enum: - 'true' nullable: true metadata: $ref: '#/components/schemas/AnalysisReportEvidenceCellMetadata' required: - value additionalProperties: false AnalysisReportEvidenceSource: type: object properties: service: type: string enum: - statistics queryLayer: type: string enum: - cube members: type: array items: type: string required: - service - queryLayer - members additionalProperties: false AnalysisReportEvidenceFreshness: type: object properties: capturedAt: type: string format: date-time required: - capturedAt additionalProperties: false AnalysisReportEvidenceState: type: string enum: - success - warning - failure AnalysisReportEvidenceCellMetadata: type: object properties: link: type: string additionalProperties: false securitySchemes: password_auth: type: oauth2 flows: password: tokenUrl: https://api.reelevant.com/v2/auth/token refreshUrl: https://api.reelevant.com/v2/auth/token scopes: {} ````