Analytical queries

Grouped, aggregated and filtered reads for analytical clients, answered by the database rather than in application memory. This concerns the queries a chart or report sends, while analytic modelling defines the measures and dimensions they read.

Overview

Grouped, aggregated and filtered reads for analytical clients — the query shapes an analytical UI issues, answered by the database rather than in memory. Named for the query and not for the field: this is what a CAP service does when a chart asks it something, and it is not the analytics estate — Datasphere, Analytics Cloud, BW and the modelling that happens in them are a different concern on a different door.

SAP SHIPS
Node.js →

@sap/cds Compiles OData $apply into database aggregation, so grouping and aggregates are answered by the database.

Not covered: It stops at the transformations capire's table marks n/a for both runtimes: topcount, toppercent and topsum with their bottom counterparts, expand, groupby with rollup or $all, and custom aggregation methods; search and compute inside $apply are answered by CAP Java and not by @sap/cds. The hierarchy transformations TopLevels, ancestors and descendants are there only to support requests from the UI5 Tree Table, and concat has to end the pipeline and rules out every other system query option.

Built into @sap/cds
THE COMMUNITY ADDS

No community artifact is documented here.

Artifacts1

1 of 1 artifacts
ArtifactSignals
Packages1
@sap/cdsCAP Node.js runtime
Signals
none

Content9

Group by9 of 9 pieces
Piece, what it offers
SAP Incentive Management - Understanding of CSN file & CLI Command to generate
SAP Community, Yogananda, BlogThe reasoningA recipeRunnable code
Building an Analytical List Page with CAP OData V4
SAP Community, Mio Yasutake, BlogThe reasoningA recipeRunnable code
Gone quiet
Fiori Elements Analytical Table with CAP: Does it work with V2 and V4?
SAP Community, Mio Yasutake, BlogThe reasoningRunnable code
Core changed
Show 6 more
Empowering Your Data Analytics with GPT-3 and SAP CAP Integration
SAP Community, Former Member, BlogThe reasoning
SAP Data and Analytics Showcase – Use SAP Cloud Application Programming Model to Develop a Machine Learning Application on SAP BTP
SAP Community, former_member10846, BlogThe reasoningA recipeRunnable code
SAP Data and Analytics Showcase - Develop a Machine Learning Application on SAP BTP
SAP Community, former_member10846, BlogThe reasoning
Predictive Asset Insights embedded Live analytics using CAP and SAC
SAP Community, Saif, BlogThe reasoningA recipeRunnable code
Discovering SAP Fiori Elements Analytical functions by implementing SAP Support Message Reporting
SAP Community, Gregor Wolf, BlogThe reasoningRunnable code
E2E: SAP Cloud Platform Internet of Things to SAP Analytics Cloud
SAP Community, Gunter, BlogThe reasoningA recipe

Seen working3

ArtifactSignals
Samples3
blog-cap-chartFiori overview page comparing aggregated and plain donut-chart cards
No license
cap-alpAnalytical List Page over a CAP OData V4 service
No license
cap-sflight-hierarchysflight example extended with hierarchy support
No license

Details

Coverage
statecore only, CAP
assessed
For your agent
Ref
capability:analytical-queries
JSON
/capabilities/analytical-queries.json
MCP
Connecting an agent