Cube Overview

Cubes are stored in an OLAP database. A cube aggregates the facts (or measures)
in each level of each dimension. The term cube is used because it best describes
the resulting data. For example, when you create a cube you take the facts (Total,
Quantity, Freight, and Discount) and add them up by model, by city, by quarter,
and by every other possible combination of dimensions, you get the following
type of data structure.



Because the cube contains all of your data in an aggregated form, you can get
answers to business questions very quickly. This is the big advantage of cubes.
For example, you can find the total number of vehicles you sold last year in the
United States, or more specifically, the total number of vans you sold last month
in California.
There are ten cubes included out-of-the-box with Microsoft Dynamics AX 2012.
Each cube provides different data. The following list includes each cube
provided.

• Accounts Payable

• Accounts Receivable

• Customer Relationship Management

• Environmental Sustainability

• Expense Management

• General Ledger

• Production

• Project Accounting

• Purchase

• Sales

• Workflow

NOTE: You can refer to the Technical reference for analytics
(http://msdn.microsoft.com/library/dda9cc57-d7f4-4a7b-857a-
4df2d69d46d7(AX.60).aspx)page on MSDN to review additional information
about each cube including descriptions of the dimensions, measures, KPI
information, and other elements of the default cubes that are provided with
Microsoft Dynamics AX 2012.

The default cubes that are included with Microsoft Dynamics AX 2012 include a
Date dimension. The Date dimension is based on the Gregorian calendar, which
is a 365.2425 day western calendar starting January 1.

In Microsoft Dynamics AX 2012, you can define the properties of the Gregorian
calendar by using the Date dimension form the Microsoft Dynamics AX client.

 


Regards,
Hossein Karimi