Cal: A Customizable Calendar Dimension

# Cal: The Backbone of Strategic Decision Making

Fully configurable calendar types, fiscal period support, holidays...or not, – Cal has got you covered.

But that’s not all – Cal comes with built-in automation to dynamically manage and update reporting periods.

Cal is not just a calendar; it is a well thought out analytics component that every data warehouse needs to be successful, allowing you to immediately go from raw data to insight with ease. In just a few clicks you will configure Cal to meet your specific calendar and reporting timeframe dimension needs, and with Cal’s built in automation, it will keep your analytics in sync and up to date so you can simply focus on adding value to your cause. Cal saves you the time and cost of development so that you can get right to your business and stay there.

***With Cal, you can set it and forget it.***

<p><br/></p>

**Steps to generate Cal from the provided UI:**

1. Choose a calendar type *(basic, fiscal, 445 variants, etc.)*
2. Pick a start and end date
3. Pick a Q1 start month *(for the fiscal or 445 variant calendars)*
4. Choose your week start day *(i.e. Monday)*
5. Set your timezone *(for reporting period automation)*
6. *Done..!*

<p><br/></p>

**What is Cal used for:**

1. **Date-based Aggregation** – Enables rollups and drilldowns across different time granularities (e.g., daily, monthly, quarterly, yearly reports).
2. **Time-based Filtering** – Allows users to filter reports by specific dates, weeks, months, or years.
3. **Rolling Periods** – Facilitates rolling month/quarter/year views, e.g., "Last 12 Months (LTM)," "Previous Quarter," or "Year-to-Date (YTD)."
4. **Comparative Analysis** – Supports comparisons such as Year-over-Year (YoY), Month-over-Month (MoM), or Week-over-Week (WoW) analysis.
5. **Custom Fiscal Calendars** – Supports non-Gregorian calendars like a 4-4-5 fiscal calendar or industry-specific calendar structures.
6. **Holiday and Weekend Identification** – Helps in distinguishing business days from non-business days for operational and financial reporting.
7. **Trend and Seasonality Analysis** – Facilitates time-series analysis to detect seasonal patterns in business performance.
8. **Fiscal Period Reporting** – Defines business-specific periods like fiscal quarters and years that do not align with the Gregorian calendar.
9. **Financial Close and Budgeting** – Supports financial reporting where companies operate on non-standard fiscal years.
10. **Regulatory and Compliance Reporting** – Enables reporting for tax, legal, or industry regulations that require specific period definitions.
11. **Custom Period Alignment** – Supports alignment of operational periods like retail weeks (e.g., weeks starting on Sundays or Mondays).
12. **Snapshot and Historical Tracking** – Used for capturing snapshots of financial and operational data at specific reporting intervals.

<p><br/></p>

<p><br/></p>

## Example Table Structure

This section has been improved and moved to our [docs site](https://docs.dourodata.com/products/cal/#column-definitions)!

搜集汇总

背景与挑战

背景概述

Cal是一个可配置的日历维度数据集，支持多种日历类型、财政周期和节假日设置，具备自动化更新功能，适用于数据仓库中的时间聚合、比较分析和财务报告等场景。