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