Deserializing Financial Dimensions in Microsoft Dynamics AX 2012

Camilo Godines

The Microsoft Dynamics AX/D365 Support Team at Avantiico is focused on solving our client’s problems, from daily issues to large and more complex problems.

See All Posts

Streamlined Multi-Entity Accounting: A Guide to Avantiico’s MCS for D365 Finance

December 4, 2023 No Comments

Modernize your D365 multi-entity accounting processes with Avantiico’s Multi-Company Solution for Microsoft Dynamics 365 Finance. Introduction Efficient financial multi-entity accounting is crucial in today’s rapidly

Streamline D365 Multi-Company Journal Imports with Avantiico’s Super Journal

November 27, 2023 No Comments

Discover the benefits and use cases of the Avantiico MCS Super Journal function for faster, simplified multi-company journal imports in Microsoft Dynamics 365 Finance. Introduction

D365 Payment Schedules: Simplified Accounts Payable and Accounts Receivable Management

November 20, 2023 No Comments

Optimize your financial management with D365 Payment Schedules. This blog explains how to simplify AP and AR processes, enhance cash flow tracking, and manage payments

Microsoft Dynamics Data Migration: Process & Best Practices

November 13, 2023 No Comments

Navigate your Microsoft Dynamics Data Migration confidently with our comprehensive guide, ensuring a seamless transition to Dynamics 365 Finance & Supply Chain Management. Discover best

September 13, 2017
12:59 pm
No Comments
Read Time: 1 Hour

Deserializing Financial Dimensions in Microsoft Dynamics AX 2012

Financial dimensions are stored as a 64bit integer surrogate key in the database. It may be necessary to extract this information to understand the financial dimensions that this surrogate key represents. For example, a custom BI solution, report or integration may require that this surrogate key be de-serialized to reveal the exact financial dimensions it represents. This blog explains some of the common Microsoft Dynamics APIs available and display financial dimension segment from a default dimension surrogate key. A simple job is created to demonstrate this.

In this example, we will be working with the financial dimensions of a customer.

This is stored in the SQL database as a 64 bit integer.

The database schema below represents all the tables and views that are required to de-serialize and display the financial dimensions that this surrogate key represents, however this blog post will demonstrate key Microsoft Dynamics AX API’s that can assist developers.

The following script is created to demonstrate:

The following Microsoft API’s are used:

The DimensionAttributeValueSetStorage class is used to iterate through all the financial dimensions in the DefaultDimension
The DimensionAttributeValue table is used, this stores a link to the VALUE of the financial dimension we want to display, for example a department or cost center number. This is usually linked via a surrogate key, e.g. DimensionAttibuteValue. EntityInstance is a surrogate key to the exact record we wish to display.
The DimensionAttribute table is used, this stores information so we can understand the TYPE of financial dimension. This stores the object ID of the view or tabled used as backing entity, e.g. 11765 = DimAttributeOMDepartment
The DimensionDefaultingControllerBase class is used to find the backing entity record. The backing entity is usually a view in the AOT, starting with DimAttribute. This view can then be used to display information about the financial dimension. The DimensionAttribute table is used to find the table that contains the financial dimension, the DimensionAttributeValue table is used to find the specific record in that table.
The DimensionAttribute record contains a ValueAttibute field, which is the field id in the backing entity view that stores the VALUE of the financial dimension, this is a natural key, for example a department ID (e.g. Department 10)
The NameAttribute field on the DimensionAttribute record stores the field in the backing entity view that stores the NAME of the financial dimension, for example “IT Department”.

The DimAttribute financial dimension backing entities have a key, value and name field. The following example shows the financial dimension backing entity for departments which are stored in the table OMOperatingUnit

Key: This is foreign key to the Operating Unit RecId field (e.g. OMOperatingUnit.recId)
Value: This represents the Operating Unit ID (e.g. 110)
Name: This represents the Operating unit Name (e.g. “Budget Office”)

Thanks for reading, comment below to let me know if you struggle with something specific in D365 or DynAX!

Deserializing Financial Dimensions in Microsoft Dynamics AX 2012

Camilo Godines

Deserializing Financial Dimensions in Microsoft Dynamics AX 2012

More to explorer

Featured

Products

Resources

Our Company

Join Our Newsletter

Request a free Dynamics 365 meeting