Time Dimension Designs

Fiscal Year Single Type Time Dimension


Time
------FY05
------------Q1FY05
--------------------JanFY05
--------------------FebFY05
--------------------MarFY05
------FY06
------------Q1FY06
--------------------JanFY06
--------------------FebFY06
--------------------MarFY06

In this design, the lev

Generic Time design with two dimensions
Time
------YearTot
------------Q1
--------------------Jan
--------------------Feb
--------------------Mar
Year
---------- FY05
---------- FY06