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';