However, doing this is difficult for an OLAP report. This article explains how to create a Time Dimension table and use it inside SSAS. DimTime.sql – CREATE TABLE statement creates the DimTime table.

Design and implementation of a normalized retail database and dimensional data warehouse using SQL. Includes data modeling, integrity constraints, star schema, ETL logic, and business insights with ...