Perspective table

The DEPM_MOD_PERSPECTIVE table represents the perspectives of a cube.


Name	Definition
Name	nvarchar(50) NOT NULL; PK
CubeID	nvarchar(50) NOT NULL; PK
Definition	ntext NOT NULL
Type	int NULL
ExtendedProperties	ntext NULL

Name represents the perspective name in OLAP.

CubeID references the cube in the DEPM_MOD_CUBE table. This cube is the base cube for the perspective.

Definition holds the xml definition of the perspective. In this example, the Channel dimension is excluded from the perspective, the element from which to read values is set to Indirect Sales, and the ValType default element for the hierarchy is changed to Actual:

'<Alea:Perspective Name="Perspective01" Cube="ANALYSIS">
    <Alea:Dimension Name="CHANNEL">
        <Alea:ExcludeDimension Element="Indirect Sales" Hierarchy="CHANNEL" />
    </Alea:Dimension>
    <Alea:Dimension Name="VALTYPE">
        <Alea:Hierarchy Name="VALTYPE">
            <Alea:DefaultMember Name="Actual" />
        </Alea:Hierarchy>
    </Alea:Dimension>
</Alea:Perspective>'

Type is for future uses.

ExtendedProperties holds additional information about the perspective in the OLAP Extended Properties.xml format. For example, the perspective caption, the perspective description, and their translations.