A frequent issue that arises while dealing with time dimension is the definition of the year. Many organizations use the fiscal year in place of the calendar year or may be constrained to use both. In such instances Analysis Services permits the user to maintain two different hierarchies when the time dimension is created. These multiple hierarchies must be planned for before the dimension is created.
Creating a time dimension from a single Date/Time Column
Open the Dimension Editor, click on File Menu, point to New Dimension and launch the Dimension Wizard.
Click single table option and click next. Select Time_by_day as the dimension table and Click Next. Click the Time Dimension option, click Next, Select Year, Quarter, Month for time levels, and click Next. Click Next to skip the Advanced options screen.
On the finish Screen type TimeMonth as the name of the dimension, select the check box labeled Create a hierarchy of a Dimension and type Calendar in the Hierarchy Name box that appears.
Click Finish to create the dimension.