Database Reference
In-Depth Information
Tip
The role playing dimension is a great feature but sadly does not provide
the option of renaming attributes. When you expose role playing dimen-
sions for browsing, it would be very helpful if we could show "ship date
month" under the Ship Date dimension and "due date month" under the
Due Date dimension. Unfortunately we are limited to having just one at-
tribute name, "month". If you require the additional flexibility of having dif-
ferent attribute names, you must create separate physical dimensions for
ship and due dates—you can't use role playing. One way to work around
this limitation is by creating single-level, user-defined hierarchies within
each role-playing dimension. For example, you could build a ship date
month hierarchy within the ship date, a due date month within the due
date, and so on.
16. If you click on the plus sign ( + ) next to each dimension within dimensions'
window, you will see the attributes and hierarchies available within the data-
base dimension. Using the Properties window you can set various proper-
ties for each dimension and attribute within the scope of the current cube.
The dimensions included in the cube are referred to as cube dimensions ; as
discussed before, each measure group (or even each cube) may or may not
include all database dimensions.
17. The Visible property advises SSAS whether a particular attribute or user
hierarchy should be available for browsing within the cube. The Aggregation
wizard uses the Aggregation Usage property to determine whether a par-
ticular attribute should be included in aggregations—precalculated summary
tables. You will learn how to build aggregations later in this chapter.
18. Clicking on the Edit option for each dimension simply opens a dimension ed-
itor. Keep in mind that cube dimension properties do not have to match data-
base dimension properties; for example, the date attribute could be visible in
a database dimension but hidden in a particular cube, where exposing such
a level of detail is not desired.
Search WWH ::




Custom Search