Cubes and Multidimensional Analysis - Microsoft SQL Server 2008 Analysis Services - page 69

None of the elements of a collection is derived from the cube. You have to define all the
collections when you create a perspective. If you don't define a collection for any type of
element (say hierarchy), that element won't be visible in the perspective. If you don't
specify an attribute in the perspective, that attribute isn't visible through the perspective.

Listing 6.4 shows a definition of a perspective for Warehouse and Sales cube, with only
one dimension and one measure visible.

LISTING 6.4

A Perspective for a Cube

<Perspectives>
<Perspective>
<ID>Perspective</ID>
<Name>Product Sales</Name>
<Dimensions>
<Dimension>
<CubeDimensionID>Product</CubeDimensionID>
<Attributes>
<Attribute>
<AttributeID>Product</AttributeID>
</Attribute>
<Attribute>
<AttributeID>Brand Name</AttributeID>
</Attribute>
<Attribute>
<AttributeID>SKU</AttributeID>
</Attribute>
<Attribute>
<AttributeID>SRP</AttributeID>
</Attribute>
<Attribute>
<AttributeID>Product Subcategory</AttributeID>
</Attribute>
<Attribute>
<AttributeID>Product Category</AttributeID>
</Attribute>
<Attribute>
<AttributeID>Product Department</AttributeID>
</Attribute>
<Attribute>
<AttributeID>Product Family</AttributeID>
</Attribute>
</Attributes>
<Hierarchies>
<Hierarchy>