Dynamics AX Cubes

Cube Name	Purpose	Reference
Accounts Payable Cube	The Accounts payable cube for Microsoft Dynamics AX is used to report on purchase transactions.	Here
Accounts Receivable Cube	The Accounts receivable cube for Microsoft Dynamics AX is used to report on customer transactions and accounts receivable.	Here
Budget Control Cube	The Budget control cube for Microsoft Dynamics AX is used to analyze data from budget register entries. Analysis of this data helps organizations effectively manage their approved budgets and make decisions based on accurate information.	Here
Budget Plan Cube	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.	Here
Demand Forecast Accuracy Cube	The Demand forecast accuracy cube for Microsoft Dynamics AX is used to calculate and store demand forecast versus realized demand accuracy measurements.	Here
Demand Forecast Cube	The Demand forecast cube for Microsoft Dynamics AX is used to store historical demand data and demand forecast data.	Here
Environmental Sustainablity Cube	The Environmental sustainability cube for Microsoft Dynamics AX provides data that can help you track your organization’s energy consumption and greenhouse gas emissions. Therefore, your organization can take a more proactive approach to environmental issues.	Here
Expense Management Cube	The Expense management cube for Microsoft Dynamics AX is used to report on expense reports and policy violations.	Here
General Ledger Cube	The General ledger cube for Microsoft Dynamics AX is used to report on ledger accounts and bank accounts.	Here
Human Resources Cube	The Human resources cube for Microsoft Dynamics AX is used to analyze data for applicants, workers, positions, jobs, and courses. Analysis of human resources data is required for organizations to effectively manage their workforce and make decisions based on accurate information.	Here
Inventory Value Cube	The Inventory value cube for Microsoft Dynamics AX provides data that can help you evaluate the performance of your inventory. It provides measurements that provide insight into how the value of inventory has evolved over time. A set of key performance indicators (KPIs) are available to assist the process of improving financial performance of inventory management.	Here
Payroll Cube	The Payroll cube for Microsoft Dynamics AX is used to analyze data about earnings statements, pay statements, workers, positions, arrears, tax history, benefits, benefit accruals, and reversals. Analysis of payroll data is required for organizations to effectively manage payrolls and make decisions based on accurate information.	Here
Production Cube	The Production cube for Microsoft Dynamics AX is used to manage and track production activities.	Here
Profit Tax Totals Cube	The Profit tax totals cube for Microsoft Dynamics AX provides data that can help you track tax information. This cube can be useful only for Russia because it is based on Russian tables.	Here
Project Accounting Cube	The Project accounting cube for Microsoft Dynamics AX is used to report on project profitability, revenue costs, committed costs, employee utilization, and cash flow for one or multiple projects in a company.	Here
Purchase Cube	The Purchase cube for Microsoft Dynamics AX is used to report on purchase transactions.	Here
Retail Cube	The Retail cube for Microsoft Dynamics AX is used to help manage a chain of stores so that your business can improve service, manage growth, reach customers, and streamline efficiencies.	Here
Sales and Marketting Cube	The Sales and marketing cube for Microsoft Dynamics AX is used to report on sales transactions.	Here
Sales Cube	The Sales cube for Microsoft Dynamics AX is used to report on shipped and invoiced sales order lines.	Here
Workflow Cube	The Workflow cube for Microsoft Dynamics AX provides data that can help you track the performance and degree of automation associated with business processes in your organization, which will enable you to identify processes that have become inefficient.	Here

 

Extracting all possible ledger combinations in account structure

This post describes how to extract all possible ledger combination in accounts structures. 

Execute the following job to obtains all valid combinations.

static void srclJobExtractAllAccountStruct(Args _args)
{
    DimensionHierarchy                  dimensionHierarchy;
    DimensionAttribute                  dimensionAttribute;
    DimensionHierarchyLevel             dimensionHierarchyLevel;
    DimensionConstraintNode             dimensionConstraintNode;
    DimensionConstraintNodeCriteria     dimensionConstraintNodeCriteria;
    
    setPrefix('Account Structures Combination');
    
    while select Name from dimensionHierarchy
        where dimensionHierarchy.StructureType == DimensionHierarchyType::AccountStructure
    join RecId from dimensionHierarchyLevel
        where dimensionHierarchyLevel.DimensionHierarchy == dimensionHierarchy.RecId
    join Name from dimensionAttribute
        where dimensionHierarchyLevel.DimensionAttribute == dimensionAttribute.RecId
    join RecId from dimensionConstraintNode
        where dimensionConstraintNode.DimensionHierarchyLevel == dimensionHierarchyLevel.RecId
    join RangeFrom, RangeTo from dimensionConstraintNodeCriteria
        where dimensionConstraintNodeCriteria.DimensionConstraintNode == dimensionConstraintNode.RecId
    {
        setPrefix(dimensionHierarchy.Name);
        info(strFmt('%1 | %2 - %3', dimensionAttribute.Name, dimensionConstraintNodeCriteria.RangeFrom, dimensionConstraintNodeCriteria.RangeTo));
    }
}

Output

Displaying Graphs and Charts in AX Forms

This blog post will guide you, how to display data in graphs and charts in AX 2012 Forms. Sometimes you came up with requirements where end users requires graphical data on forms besides reports. In this particular post I will use an example where I will be displaying the customer details whose invoice amount is greater than $10000 and less than $20000.

step 1:

create a new form called CustomerInvoiceAmountGraph

step 2:

add CustInvoiceJour table as datasource

step 3 : 

override init() method and class declaration method

public class FormRun extends ObjectRun
{
      Graphics    graphics;
      CustInvoiceJour custinvoiceJourGraphValues;
      Microsoft.Dynamics.AX.Framework.Client.Controls.ChartToolBar chartToolbarControl;
}

public void init()
{
    super();
    // create an runtime reference to the toolbar control
   chartToolbarControl = chartToolbarControlHost.control();
   // bind the tool bar to the chart control by passing an instance of the chart control to it
    chartToolbarControl.set_ChartControl(graphControl.control());
   this.showchart();
}

step 4:

create a new method called showchart() where your logic is placed to display the customer data
whose invoice amount is greater than 10000 and less than 20000

void showchart()
{

   // create an instance of the X++ to .NET abstraction class and bind it to the chart control

    graphics =  new Graphics();
    graphics.ManagedHostToControl(graphControl);

    // set your abstracted chart options

    graphics.create();
    graphics.parmTitle("@SYS95906");
    graphics.parmTitleXAxis("CustAccount");
    graphics.parmTitleYAxis("Amount");

    // populate the chart with data

     while select CustInvoiceJour where  CustInvoiceJour.InvoiceAmount>=10000  &&                                                  CustInvoiceJour.InvoiceAmount <=20000
    {
        graphics.loadData( CustInvoiceJour.InvoiceAccount,  ' ' , CustInvoiceJour.InvoiceAmount);
    }

    graphics.showGraph();

}

step 5:

Right click Design->New control->ManagedHost

select Microsoft.Dynamics.AX.Framework.Client.Controls.ChartToolBar

step 6:

Right click Design->New control->ManagedHost

select System.Windows.Forms.DataVisualization.Charting.Chart and change the name of the control as GraphControl

output:

Writing custom message on status bar

This post will show you to write custom message on AX status bar for specific user.

Write the following code in JOB and execute it.

static void Job1(Args _args)
{
    str txtSample;

    txtSample = "XXXXXXXXXXXXXXXXXXYYYYYYYYY"; //Replace with you message

    xUserInfo::statusLine_CustomText(true);

    infolog.writeCustomStatlineItem(txtSample);
}

Output