Period Dimension (Time Dimension) Creation with Year, Month, Day Hierarchy
Suppose we have a Period table which contains some of the typical period columns, like Period_Key, Day, Month, Year.
In the table, we have typical Period rows, like
Now we want to create a Period Dimension from it.
Tags: design, time dimension