Database Reference
In-Depth Information
3. Now let's provide a meaningful name to the hierarchy so that our users know
what data they're browsing. Right-click on the hierarchy, choose
Rename
,
and then enter
Promotion Categories and Types
.
4. Alternatively, you can also edit the hierarchy name property within the
Prop-
erties
window. Now, the
Promotion Categories and Types
hierarchy con-
tains three levels:
English Promotion Category
,
English Promotion Type
,
and
Promotion Name
. Highlighting any attribute within the hierarchy allows
renaming of the level. For example, suppose that the majority of our users
are fluent in English and hence we don't need to include the word "English" in
level names. Therefore, let's remove this word from the corresponding levels
and arrive at the final design of our hierarchy to include
Promotion Cat-
egory
,
Promotion Type
, and
Promotion Name
levels.
5. Now, you're happy with hierarchy-level names, but SSDT shows another
warning; this is because we haven't defined attribute relationships yet. Attrib-
ute relationships define how Analysis Services should roll up data from one
hierarchy level to the next. In this case we know that each promotion cat-
egory can have multiple types, and each type can have multiple promotion
names. Switch over to the
Attribute Relationships
pane within the promo-
tion dimension editor; currently, you'll see the relationships as shown in the
following screenshot:
Search WWH ::
Custom Search