Skip to main content

Get Aggregate Query

What is a get aggregate query​

A get aggregate query is a tabular query language that retrieves measure values at a specific cube location. It forms a subset of MDX.

Why use a get aggregate query​

A get aggregate query returns measure values without requiring a full MDX statement. This provides support for applications that need access to tabular data rather than tree‑structured table data. This is the preferred choice for applications that require real-time processing.

What is required to use a get aggregate query​

A clear understanding of cube locations is required. Each query targets one position in the cube to return the correct measures. An example is available in the location based queries.