Calendar Dimension Overview

Modified on Mon, 27 Jul at 4:21 AM

Calendar Dimension Overview

QQube calendar dimensions are designed to make date-based analysis easier across Excel, Power Pivot, and Power BI. They combine fiscal and calendar-date attributes, provide presentation-friendly fields, and support consistent reporting across QQube data models.

Combined Date Logic

Fiscal and calendar-date attributes are included in the same dimension.

Presentation-Friendly Fields

Fields such as Q2, FY 2001, and formatted month labels are ready for reports.

Power BI Ready

Sorting, hierarchies, formatting, and comparison fields are prepared in advance.

Types of Calendar Dimensions

QQube calendar dimensions serve one of two roles within a data model.

Calendar Role	Purpose	Example
Primary Calendar	Acts as a main reporting driver and supports date-based drill-downs and analysis.	Trip End Date in the Vehicle Mileage Data Model.
Supporting Calendar	Adds another date perspective that supplements the primary analysis.	Trip Start Date in the Vehicle Mileage Data Model.

Vehicle Mileage Example

Trip End Date is the primary calendar for Vehicle Mileage and supports date drill-downs. Trip Start Date supplements the analysis with the beginning date of each trip.

Trip Start Date	Trip End Date

Multiple Primary Calendars

A data model can include more than one primary calendar when the subject requires multiple date-driven analyses.

Sales Data Model Example

The Sales Data Model includes primary calendar dimensions for Transaction Date and Open Sales Order Ship Date. It also includes supporting calendar dimensions such as Service Date and Fully Paid Date.

Power Query, Power Pivot, and Power BI Implementation

QQube prepares calendar dimensions so they can be used consistently without additional model-building work.

Field Sorting	Text fields are sorted by the appropriate numeric fields. For example, Month Name is sorted by Month Number.
Consecutive Period Numbers	Running year, quarter, month, week, and day numbers support period comparisons.
Date Formatting	Date fields are formatted as MM/DD/YYYY.
Hierarchies	Consistent date hierarchies are included for drill-down analysis.
Field Visibility	A consistent set of visible and hidden fields is applied throughout the prepared examples.
Power BI Auto Date/Time	The Auto date/time for new files option is turned off in the QQube Power BI examples.

Date Table Setting

The QQube architecture does not require a calendar dimension to be marked as a date table in Power Pivot or Power BI.

Transaction Date Example

The following example shows the Transaction Date Dimension in the Sales Data Model.

Transaction Date Dimension in the QQube Sales Data Model