Date Dataset

A Date dataset is a dataset in the logical data model(LDM) that represents DATE / TIMESTAMP columns in your database. The Date dataset helps you manage time-based data and enables aggregation at the day, week, month, quarter, and year level.

When a relationship exists between a standard dataset and a Date dataset, the related foreign keys are mapped to the DATE / TIMESTAMP columns.

You can share a Date dataset with multiple standard datasets and then slice the facts from those standard datasets by the dates from the Date dataset.

You can create multiple Date datasets and create relationships between these Date datasets and one standard dataset, for example:

• Date datasets: Created, Last Updated
• Standard dataset: Tickets containing two foreign keys, Created and Last Updated

A Date dataset in the LDM is identified by the following visual object:

Granularity Levels in a Data Dataset

The Date datasets support the following categories of date/time granularity:

• Chronological
• Periodical

When used in the LDM, the Date dataset defines what levels of granularity can be used in your analytics and how the titles of the those levels should be presented.