dynamics-ax-2012dynamics-ax-2012-r2

Get Department from dimension in AX 2012

I want to get the department from the default dimension in AX 2012.

In the LedgerJournalTrans->lines->FinancialDimension I can fill the department but in the database for AX the default dimension is saved.

I'm working on SSRS reports d=so I want to get the department in SQL query.

Can anyone help me how to get the department and explain simply the relations

Thank you in advance and best regards,

Solution

  • You can use this in SQL:

    select DisplayValue from  DefaultDimensionView 
    where DefaultDimension = 1234567890
      and Name ='Department'

    In X++:

    select DisplayValue from defaultDimensionView 
    where defaultDimensionView.DefaultDimension == this.DefaultDimension
       && defaultDimensionView.Name == 'Department';