Database Reference
In-Depth Information
8. Specify
Date
as the name of the newly created dimension and click on
Fin-
ish
.
Preparing the Date dimension for end users
Now you have the newly created the
Date
dimension and it is time to prepare it
for end users. This means that you need to change some objects and create some
more.
Renaming attributes
First of all, you need to rename the key attribute from
Date Key
to
Date
.
1. In the dimension editor window, click on the
Dimension Structure
tab.
Under
Attributes
, right-click on the
Date Key
attribute and choose
Rename
.
2. Change the name to
Date
and press the
Enter
key.
3. Rename
Month Number Of Year
to
Month
using the same method as you
used with the
Date
attribute.
Search WWH ::
Custom Search