In this article, giving an example for defining the lookup for dimensions in simple way. This example will cover only for user Defined dimensions.
Tag: Dimensions
Microsoft Dynamics Ax
Dynamics AX 2012 Excel Add-in – Tracking Dimensions
by Bo Jensen •
Purpose: The purpose of this document is to illustrate how to work with Tracking Dimensions in Dynamics AX 2012 Excel Add-in. Challenge: Data model changes in Dynamics AX related to high normalization and introduction of surrogate keys made import of data more complex. Additionally there are number of differences between Excel and AX Rich Client…
Microsoft Dynamics Ax
Dynamics Ax Internals: Default dimension storage in Ax 2012
by Bo Jensen •
The Chart of accounts structure in Ax2012 has changed significantly from previous versions. In Ax2009, any table that stored dimensions would have a field called ‘Dimension’ (an n-element array). This applied to master data (customers, items, etc), as well as transactions, like entries in the GL (LedgerTrans). Typically, dimension values would flow from the master…
Microsoft Dynamics Ax
Adding only one Dimension in Dialog – Axaptapedia
by Bo Jensen •
A small lesson on how to add only one Dimension in dialogs
Microsoft Dynamics Ax
Adding only one Dimension in Dialog – Axaptapedia
by Bo Jensen •
Microsoft Dynamics Ax
Coding against Dimensions
by Bo Jensen •
The usual method of programming against a specific dimension in Ax is as follows: salesTable.Dimension[SysDimension::Center + 1] = ‘The cost centre’; However, this code is not technically correct. It relies on the enum value of the dimension matching the array dimension (plus 1), which is not guaranteed. If a developer follows Microsoft’s best practice guide…
SQL Analysis Services
Bruce's Blog: The Date Dimension in Analysis Services
by Bo Jensen •
Bruce’s Blog: The Date Dimension in Analysis Services