Create a perspective for a cube [AX 2012]

Updated: November 26, 2013

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

A perspective is a collection of tables and views that is used to identify the tables and views that contain measures and dimension attributes for a cube. After you create a perspective, you can use it to generate an Analysis Services cube. The following procedure explains how to create a perspective for a cube and how to add or remove table and view fields to a perspective.

Before you can complete the procedures in this topic, you must make sure that the following prerequisites are in place.

Category

Prerequisite

For more information

Required software

Microsoft Dynamics AX with Analysis Services configured

Analytics in Microsoft Dynamics AX

  1. In the AOT, expand the Data Dictionary node.

  2. Right-click the Perspectives node, and then click New Perspective.

  3. Select the node for the perspective.

  4. In the Properties window, type a name for the Name property, specify a label to use in the Label property, and select either OLAP or Both for the Usage property. Set other properties as appropriate.

    NoteNote

    If you do not specify a label for the perspective, the cube name will not be available in the business overview web part in Enterprise Portal.

  5. Add tables that are used to define the cube to the perspective by dragging them from the Tables node in the AOT onto the Tables node that is in the perspective. Be sure to add the tables that already contain, or will contain, measures and dimensions for the cube.

    NoteNote

    If you set the createdDateTime property in any of the tables that you add to a perspective to No, cube processing may fail. If that happens, run the SQL Server Analysis Services project wizard using the update option. Deploy and process the Analysis Services project to make sure the project is generated. If necessary, open the Data Source View (DSV) in Microsoft Business Intelligence Development Studio (BIDS) and remove columns that are referenced in the error when the cube processing failed.

    NoteNote

    Sub-type tables (non-base tables) are not supported in perspectives in Microsoft Dynamics AX 2012 R2. Do not add a table that has a non-empty value for its Extends property to a perspective. If you want to use fields from a sub-type table, create a view that contains the field and then add the view to the perspective.

    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.

  6. Add views that are used to define the cube to the perspective by dragging them from the Views node in the AOT onto the Views node that is in the perspective. Be sure to add the views that already contain, or will contain, measures and dimensions for the cube.

  1. 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.

  2. In the Properties window, set the Dynamic property to No.

  3. Do one of the following:

  1. In the AOT, expand the node for the perspective, expand the Views node, expand the node for the view, and then select the Fields node.

  2. In the Properties window, set the Dynamic property to No.

  3. Do one of the following:

Community Additions

ADD
Show: