Cube - Multi-dimensional query (OLAP query)

Data System Architecture

About

An multi-dimensional query is a query that runs against a multi-dimensional structure (ie cube).

It is also known as:

  • an OLAP query.
  • a business query

multi-dimensional query are analytics query and therefore are also:

Language

See Multi Dimensional Data - MDX

Characteristics

The queries exhibit the following characteristics:

  • They have a high degree of complexity;
  • They use a variety of access
  • They are of an ad hoc nature
  • They examine a large percentage of the available data;
  • They contain query parameters that change across query executions.





Discover More
Data System Architecture
Data Analysis - ad-hoc queries (exploratory)

An ad-hoc query is a query created on the fly by an analyst in order to answer specific business questions. It's also known as: speed-of-thought analysis Impromptu query This queries are: constructed...
Data Mart
Data Warehousing - Data Marts

A data mart is a subject-or application-specific multidimensional schema build on the top of an Enterprise Data Warehouse. Data marts are designed for a particular line of business and is an aggregation...
Star Schema
Dimensional Data Modeling - Level

A level in a dimensional hierarchy is a set of attributes that has: an mandatory identifier attribute (known also as the business identifier) and descriptive attributes (optional) A level is...
Star Schema
Dimensional Data Modeling - OLAP Cube

An OLAP cube is a dimensional data structure that answer dimensional query. It store data in a multidimensional way. You can a cube as an extension of the two dimensions relational table. A cube is...
Data System Architecture
Multi Dimensional Data - MDX

MDX is a standardized query and calculation language for multidimensional databases such as: Essbase, Microsoft Analysis Services, and SAP BW.
Data System Architecture
Online Analytical Processing (Olap)

Online Analytical Processing (OLAP) refers to: a class of application an approach to quickly answer multi-dimensional analytical queries. The term OLAP was created as a slight modification of...
Star Schema
Semantic Layer - Semantic query (Business Query)

A semantic query is a business query that runs against the logical star schema of a semantic layer. The semantic layer translates this query to a SQL query in order to query the underlying database and...



Share this page:
Follow us:
Task Runner