AX 7. How to add financial dimensions as separate columns to Data Entity.

Everyone who is working with financial dimensions in AX would like to see them in separate columns in Excel and today we will look how to achieve this for all Data Entities.


It’s also awesome because we have wizard that will do all the job for us!

In the Visual Studio under Dynamics AX > Addins select “Add financial dimensions for OData…”


Now we need to enter dimensions we want to expose. As you can see from a help text this dimensions should be setup in AX on Data Entities tab under General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications.


Also we need to specify a model for new objects. Please note that the model should have reference to the Dimensions model, however you can add reference afterwards.

After clicking “Apply”, VS will show new project creation dialog. New project will be created. It will contain two Data Entity Extensions:


Please note that you cannot rename them because internal code works only with entity extensions that have name = Data Entity Name + “DimensionIntegration”.

Both entities has identical changes, the only difference is that one show default dimensions and another one ledger dimensions.

Let’s looks at DimensionSetEntity extension:


It has 3 new fields, one for each financial dimensions we specified in the wizard.

This fields are computed columns, each of them use same data method “getValueColumnForDimensionAttributeSql”.


It is quite interesting and has some smarties inside but hardcoded values as well.

That all we need to do. After compilation and synchronization we can open Data Entity in Excel and will see new fields in data connector designer.


How does it work? That the most exciting part. All the magic is inside DimensionAttributeValueSet table. If we look at it in AOT – nothing is really changed since AX 2012, but if we go to SQL management studio we will see bunch of new columns:


For each financial dimensions we have 2 columns: one contains value and another RecId.

Each computed column in Dimensions entity select value from this table.

So, if you are doing BI with 3rd party tools, now you can use  DimensionAttributeValueSet and DimensionAttributeValueCombination tables to query all financial dimensions directly.

23 thoughts on “AX 7. How to add financial dimensions as separate columns to Data Entity.

  1. andreashine January 6, 2017 / 10:23 am

    how to add dimension columns for non-ledger account ?

    • ievgensaxblog January 6, 2017 / 10:32 am

      Hi Andre,
      Could you please elaborate your question ?

      • andreashine January 10, 2017 / 8:26 am

        Hi Ievgen,
        Following your instructions above on excel general ledger journal entry.
        I tried to input rows data in AX and synchronize it to excel.
        For row data with account type : ledger, all columns fin dim showed the value, but not for non-ledger acount like : Bank, customer, etc.
        Column fin dim taken from fields name : Account.Account.CostCenter, Account.Account.BusinessUnit.

    • ievgensaxblog January 10, 2017 / 8:37 am

      What data source did you use ? There are 2 options available DimensionSetEntity and DimensionCombinationEntity. One for default dimensions and another for ledger dimensions. Maybe you want to ask same question on the community because it is not very convenient to discuss it in the comments and there are a lot of experts that could also help.

      • andreashine January 10, 2017 / 11:48 am

        Both, DimensionSetEntity & DimensionCombinationEntity

  2. Naithika Shetty September 27, 2017 / 4:14 am

    Can you please provide the code for getValueAttributeForDimension Method

    • Ievgen Miroshnikov September 27, 2017 / 4:36 am

      Hi Naithika,
      You don’t need to write this method, it exists out of the box and actual wizard should populate this property for you on generated fields.

  3. Raphael October 17, 2018 / 8:18 am

    thanks saved the day specially the part with the “Please note that you cannot rename them”

  4. Robert Adams January 29, 2019 / 7:59 pm

    Is there a way to reset the model, the model I chose originally was not the extension model and Now the option to choose a model is not available, is there a way to reset the model or refresh the add In and start over?

    • Ievgen Miroshnikov January 29, 2019 / 8:03 pm

      If you have object in incorrect model, just move them from 1 model folder to another and recompile both.

      • Robert Adams January 29, 2019 / 8:04 pm

        In the AOT?

  5. Ievgen Miroshnikov January 29, 2019 / 8:17 pm

    In the solution or directly in explorer, move it from one folder to another.

  6. axel May 2, 2019 / 10:09 am


    Do you have some reference on how to do this, but without OData ?


    • Ievgen Miroshnikov May 2, 2019 / 11:06 am

      It adds new columns to 2 data entities, then you can join them and expose individual columns to BYOD or data export.

      • axel May 2, 2019 / 5:07 pm

        Thanks for replying,

        However I’m truly sorry, I really cannot get what does it mean.
        What are the 2 data entities you are mentioning?

        Thanks in advance.

    • Ievgen Miroshnikov May 2, 2019 / 7:06 pm

      DimensionCombinationEntity and DimensionSetEntity, run the wizard to add fields to them, then do find references for them to see how they are used in standard entities.

  7. Pirmin April 17, 2020 / 7:44 am

    Hi, I have followed the same steps. But when the record doesn’t have dimension values (DefaultDimension = 0) then the record doesn’t show up in Excel.
    When I redesign the field that are visible in Excel and I remove all the DefaultDimension.fieldname fields and only add the DefaultDimensionDisplayValue field then that line is visible in Excel again. So it seems that an inner join is used when using the DimensionSetEntity fields. Any ideas?
    Thanks in advance

  8. Elo June 3, 2020 / 7:20 am

    Hi, what is the difference between combination and set entities? I am trying to achieve the same functionality within a ledgerJournal data entity that is imported via data management (not excel). I have added the dimensions as separate fields on the data entity (Tried from combination and set). Was hoping that the account display value would be imported correctly into the journal, but it is completely ignored.
    Any ideas?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s