title | TOCTitle | ms:assetid | ms:mtpsurl | ms:contentKeyID | author | ms.date | mtps_version |
---|---|---|---|---|---|---|---|
Budget plan cube (BudgetPlanCube) for Microsoft Dynamics AX 2012 R2 and R3 |
Budget plan cube (BudgetPlanCube) |
015155b3-1af0-402d-8b85-5ff1b394534a |
49384271 |
tonyafehr |
07/23/2014 |
v=AX.60 |
[!INCLUDEarchive-banner]
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
The Budget plan cube for Microsoft Dynamics AX is used to analyze data from the budget plan documents. Analysis of budget planning data is required for organizations to effectively manage their budget planning process and make decisions based on accurate information. This article provides details about the cube.
![]() Deployment Configuration keys Tables and views Measures Calculated measures Key performance indicators Security |
![]() Analytics in Microsoft Dynamics AX Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3 Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack |
The Budget plan cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX project—and the cubes that it contains—see Deploy the default cubes.
The following configuration keys are required to use all features of the Budget plan cube:
- Budget planning configuration key (LedgerAdv2BudgetPlanning)
The Budget plan cube uses data from the following tables and views:
-
AssetTable table
-
BudgetCycle table
-
BudgetPlanHeader table
-
BudgetPlanningProcess table
-
BudgetPlanningStage table
-
BudgetPlanPriority table
-
BudgetPlanProposedAsset table
-
BudgetPlanProposedProject table
-
BudgetPlanScenario table
-
UnitOfMeasure table
-
UserGroupInfo table
-
BudgetPlanCube view
-
BudgetPlanHeaderView view
-
HcmPositionForecastCube view
-
OMDepartmentView view
The Budget plan cube includes the following measure groups.
This measure group is based on the BudgetPlanCube view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
This measure group is based on the BudgetPlanHeader view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
The Budget plan cube contains the following calculated measures.
Calculated measure |
Aggregation |
Associated measure group |
Description |
---|---|---|---|
Budget net income |
Budgeted revenues minus budgeted expenses. |
Budget plan lines |
Defines budgeted profitability of the selected budget plan document lines. A total budget net income is calculated as a total of budget plan line field Amount. Budget amount for the expense accounts is stored in the budget plan document line as a positive number. Budget amount for the revenue accounts is stored as a negative number. |
Percentage of plans completed |
Count of budget plans with document status of Finalized, divided by count of all budget plans. |
Budget plan header |
Defines the progress of budget planning processes. This percentage is calculated based on the total number of budget plan documents, and the number of budget plan documents that have a status of Finalized. |
The Budget plan cube does not include any key performance indicators (KPIs).
The Budget plan cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.
-
Accounting manager
-
Accounting supervisor
-
Budget manager
-
Chief executive officer
-
Chief financial officer
-
Compliance manager
-
Financial controller