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: A Customizable Calendar Dimension

概述

• 提供商: Douro Data
• 价格: $89/月
• 试用: 90天无限试用
• 功能: 完全可配置的日历类型、会计期间支持、节假日管理，内置自动化动态管理和更新报告周期。

主要用途

1. 基于日期的聚合: 支持不同时间粒度的汇总和下钻。
2. 基于时间的过滤: 允许用户按特定日期、周、月或年过滤报告。
3. 滚动周期: 支持滚动月/季度/年视图。
4. 比较分析: 支持年同比、月环比或周环比分析。
5. 自定义会计日历: 支持非公历日历，如4-4-5会计日历。
6. 节假日和周末识别: 区分工作日和非工作日。
7. 趋势和季节性分析: 支持时间序列分析。
8. 会计期间报告: 定义与公历不一致的业务特定期间。
9. 财务结算和预算: 支持非标准会计年度的财务报告。
10. 监管和合规报告: 支持特定期间定义的报告。
11. 自定义期间对齐: 支持对齐运营期间，如零售周。
12. 快照和历史跟踪: 用于在特定报告间隔捕获数据快照。

业务需求

财务和管理报告

• 支持与标准日历年不同的财务报告。
• 确保准确的财务报告，包括月度、季度和年度财务报表、预算和预测、税务和审计报告、监管合规等。

运营绩效跟踪

• 绩效基准测试。
• 零售和供应链优化。
• 工作日跟踪。

销售和营销分析

• 趋势和季节性检测。
• 销售预测和收入分析。
• 营销活动效果测量。

合规和审计要求

• 监管报告。
• 数据完整性和一致性。
• 审计跟踪。

行业特定日历

• 支持零售、政府、教育等行业的自定义日历结构。

安全性

• 安全审查: 已完成Snowflake安全审查。
• 基于角色的访问控制: 数据受Snowflake基于角色的访问控制保护。
• 推荐权限: 安装后根据需要授予账户级别权限。

其他产品

• Time Dimension: ISO标准时间维度，免费。
• Country Dimension: ISO 3166-1标准国家参考数据，免费。

类别

• 分析工具

联系信息

• 销售: [e-mail]
• 支持: [e-mail]

云区域可用性

AWS

• 亚太地区（孟买）
• 亚太地区（大阪）
• 亚太地区（首尔）
• 亚太地区（新加坡）
• 其他35个区域

法律条款

• 标准