How to: Create a Perspective for a Cube
A perspective is a collection of tables. There are several scenarios for using perspectives in Microsoft Dynamics AX. One of those scenarios is to identify the tables that contain measures and dimensions for a cube. The following procedure explains how to create a perspective for a cube and how to add or remove table fields in a perspective.
To create a perspective for a cube
-
In the AOT, expand the Data Dictionary node.
-
Right-click the Perspectives node, and then click New Perspective.
-
Select the node for the perspective.
-
In the Properties sheet, type a name for the Name property and select either OLAP or Both for the Usage property. Set other properties as appropriate.
Note The Usage property specifies materialization options for a perspective. Setting the Usage property to OLAP indicates that the perspective can be used to generate a cube in a SQL Server Analysis Services (SSAS) Business Intelligence project. Setting the Usage property to Both indicates the perspective can be used to generate a cube in a SSAS Business Intelligence project and a transactional Semantic Model Definition Language (SMDL) model for ad hoc reporting. For a detailed description of the Business Intelligence properties and their options, see Business Intelligence Properties.
-
Add tables that are used to define the cube to the perspective by dragging them from the Tables node onto the perspective. Be sure to add the tables that already contain or will contain measures and dimensions for the cube.
You can define measures and dimension attributes at different levels and on different objects in the Application Object Tree (AOT). For more information, see How to: Specify Measures for a Cube and How to: Specify Dimensions and Attributes for a Cube.
To add or remove table fields in a perspective
-
In the AOT, expand the node for the perspective, expand the Tables node, expand the node for the table, and then select the Fields node.
-
In the Properties sheet, set the Dynamic property to No.
-
Do one of the following:
-
To add a field, right-click the Fields node and then click New Field. In the Properties sheet, select a field for the DataField property. To identify the field as a measure or a dimension attribute, see How to: Specify Measures for a Cube and How to: Specify Dimensions and Attributes for a Cube.
-
To delete a field, expand the Fields node, right-click the field. and then click Delete.
-