Perspective Element (ASSL)
Applies To: SQL Server 2016 Preview
Defines details for a perspective of a Cube element.
<Perspectives> <<Perspective> <Name>...</Name> <ID>...</ID> <CreatedTimestamp>...</CreatedTimestamp> <LastSchemaUpdate>...</LastSchemaUpdate> <Description>...</Description> <Translations>...</Translations> <DefaultMeasure>...</DefaultMeasure> <Dimensions>...</Dimensions> <MeasureGroups>...</MeasureGroups> <Calculations>...</Calculations> <Kpis>...</Kpis> <Actions>...</Actions> <Annotations>...</Annotations> </Perspective> </Perspectives>
Data type and length
0-n: Optional element that can occur more than once.
A perspective provides a subset of a cube, selecting the dimensions, hierarchies, attributes, and other details that are to be included, and defining the slice of data to be included. A perspective is owned by a single cube. It is not possible to override or add objects within a perspective; all dimensions, hierarchies, and other details must exist in the underlying cube. It is not possible to include objects and mark them as not visible.
The corresponding element in the Analysis Management Objects (AMO) object model is Perspective.