Defining Cubes in Microsoft Dynamics AX


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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

A cube is defined by its measures and the dimensions it uses. You can specify measures and dimensions at different levels and on different elements in the Application Object Tree (AOT) using the Business Intelligence properties that appear in the Properties sheet. You use a perspective to identify the tables and views that contain the dimension attributes and measures for a cube. This section describes how to create an analysis cube in Microsoft Dynamics AX.

In This Section

How to: Create a Perspective for a Cube

How to: Specify Measures for a Cube

How to: Specify Dimensions and Attributes for a Cube

How to: Create a Date Dimension for a Cube

How to: Include a Hierarchy in a Cube

How to: Upgrade Microsoft Dynamics AX cubes

Business Intelligence Properties

How to: Add a Financial Dimension to a Cube

How to: Create an ODC file for a Business Overview Web Part

How to: Expose a PowerPivot Model in a Business Overview Web Part

How to: Create a Role Center

See also

Designing Cubes (SQL Server Books Online)

Measures and Measure Groups (SQL Server Books Online)

Introduction to Dimensions (SQL Server Books Online)

Attributes and Attribute Hierarchies (SQL Server Books Online)