Get Department from dimension in AX 2012

Question

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,

Answer 1

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