Dimensions select statement by index Ax2012

Finance and Operations/AX Developer Forum
1

Hi,

how do you write a simple select like this in Ax2012 ? while there is DefaultDimension field, upgraded one.

Select DH Where DH.Dimension[3] == ledgerJournalTrans.Dimension[3];

2

try to use views for financial dimensions DimensionAttributeLevelValueAllView and others, check them out!

3

Where can you get to the description of the value? For example, we have territory as a financial dimension. We have a numeric value for the territory but a description which shows us what the value means. The only table I have found that has this information is DimensionFinancialTag. I could simply join to this table using a CASE statement and hard code in the FinancialTagCategory but I figured there is a link to this table somewhere that I don’t know about.