To create date elements:
In the Metadata Navigator, locate the logical date column on which you want to base new date elements.
The logical date column you select must represent a date column in your physical data source. Otherwise, the Create Date Elements function is not available.
Right-click the logical date column and select Create Date Elements.
In the Create date elements dialog box, select the check box next to the date elements that you want to create.
In the Metadata Navigator, the new date elements appear as text columns belonging to the same table as the original date element.