Database Reference
In-Depth Information
Tip
The order of the keys is important, you need to have an order that
uniquely identifies the values. Another reason is that it affects the sorting
of the values that are shown to the users.
4. Change the order of the columns so that you have
CalendarYear
on the top
followed by the
CalendarQuarter
column.
Now that you have a composite attribute key, you also need to add a name column.
The name column is the value that gets displayed to the end user when they browse
the cube. As you have a composite attribute key, a name column is required. If you
have a single column as the key column, by default the value of the attribute key is
shown.
1. In the
Properties
window, click on the
NameColumn
property and add the
FullCalendarQuarter
column as
NameColumn
.
2. Now you need to perform the same thing for the
Month
attribute. Click on the
Month
attribute in the dimension editor.
3. Add the
CalendarYear
column to
Key Columns
and
EnglishMonthName
as
NameColumn
.
Tip
For more information about how to design the best dimensions from a
performance perspective, please refer to the following white paper:
Search WWH ::
Custom Search