Skip to content

📘 Introduction: Data Cube Modeling Tutorials ​

Welcome to our comprehensive tutorial series on data cube modeling. This collection is designed to guide you step by step through the core concepts and techniques used in modeling complex analytical data structures. Whether you're building a business intelligence solution or working on an OLAP engine, a solid understanding of the data cube, catalogs, schemas, and OLAP elements is essential.

We start with the relational foundation – modeling catalogs, schemas, tables, and columns in a way that mirrors typical database systems. This layer serves as the cornerstone for everything that follows.

From there, we transition into the world of OLAP modeling: You’ll learn how to define cubes, and how to enrich them with dimensions, hierarchies, and levels that reflect your business structure and enable powerful multidimensional queries.

We strongly recommend beginning with the database tutorial, as it introduces the core data model that most of the other tutorials build upon. Before diving into advanced topics, it’s useful to revisit the introductions in each section, as they often highlight key transitions and modeling decisions.

The Tutorials in the unstructured section agre bare Mapping descriptions and example files. They are designed for advaned users who are already familiar with the basics of data cube modeling. These tutorials provide a deeper dive into specific topics, showcasing advanced techniques and best practices for creating efficient and effective data models. Feel free to add Tutorial description and structure to this Tutotials.

A recommended reading order is provided below to help you build your understanding progressively and systematically.

Download the full Tutorial-Package as zip.

Database Intro

Database Column

Database Expression Column

Database Schema

Database Table

Database SQL View

Database Inline Table

Cube Minimal

Action Drillthrough

Formatter Cell

Measure Expression

Measure Inline Table

Measure Inline Table With Physical

Level Expressions

Level Small Int As Boolean Type

Level If Parents Name

Level If Blank Name Multiple

Level If Blank Name

Virtual Cube Minimal

Virtual Cube Dimensions

Virtual Cube Calculated Member

Virtual Cube Unvisible Reference Cubes

Hierarchy Inline Table

Hierarchy View

Hierarchy Unique Key Level Name

Parent Child Minimal

Parent Child Null Parent

Parent Child Link

Parent Child Parent As Leaf

Cube Measure Aggregator Base

Cube Measure Multiple

Cube Measure Datatype

Cube Measure Format

Cube Measure Group

Cube Measure Aggregator Bit

Cube Measure Aggregator Percentile

Cube Measure Aggregator Nth

Cube Measure Aggregator Text Agg

Cube Dimension Intro

Cube Hierarchy Query Table Base

Cube Hierarchy Query Table Multilevel Multitable

Cube Hierarchy Query Table Multilevel Singletable

Cube Hierarchy Query Join Base

Cube Hierarchy Query Join Multi

Cube Hierarchy Has All

Function Logic

Cube Calculated Member Intro

Cube Calculated Member Color

Access Database Schema Grant

Access Table Grant

Access Column Grant

Access Catalog Grant

Access Cube Grant

Access Dimension Grant

Access Hierarchy Grant

Access With Default Role

Access Member Grant

Writeback Inline Table

Writeback Table

Writeback View

Writeback Without Dimension

Member Identifier

Cube Level Member Property Intro

Member Properties with Geographic Data

KPI Intro

KPI All

KPI Parent Ring

KPI Virtual Cube

Namedset All

Aggregation Agg Exclude

Aggregation Aggregate Tables

Dimension Time Dimension

Dimension Optimisation With Level Attribute

Daanse Example - Schulwesen

ExpressiveNames

Bevölkerung

Parcel Delivery Service

Released under the Eclipse Public License 2.0