Financial dimensions value

Finance and Operations/AX Developer Forum
1

Hi all,

How can i get all the values of a specific financial dimension in AX 2012 ?

I want to show all the values in a lookup which i have created in ssrs report.

2

I solved it myself . Here by i am posting the code which can be useful to other users.

public void lookup(FormStringControl _formStringControl)
{

DimensionAttribute DimensionAttribute = DimensionAttribute::findByName(’// You financial Dimension name’);
Query query = new Query();
QueryBuildDataSource qbdsFinancialTag,qbdsDirCategory;
QueryBuildRange qbr;
SysTableLookup SysTableLookup = SysTableLookup::newParameters(tableNum(DimensionFinancialTag),_formStringControl);

qbdsFinancialTag = query.addDataSource(tableNum(DimensionFinancialTag));
qbdsFinancialTag.addOrderByField(fieldNum(DimensionFinancialTag,Value),SortOrder::Ascending);

qbdsDirCategory = qbdsFinancialTag.addDataSource(tableNum(DimensionAttributeDirCategory));
qbdsDirCategory.relations(false);
qbdsDirCategory.addLink(fieldNum(DimensionFinancialTag,FinancialTagCategory),fieldNum(DimensionAttributeDirCategory,DirCategory));

qbr = qbdsDirCategory.addRange(fieldNum(DimensionAttributeDirCategory,DimensionAttribute));
qbr.value(queryValue(DimensionAttribute.RecId));

SysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag,Value));
SysTableLookup.addSelectionField(fieldNum(DimensionFinancialTag,Value));

SysTableLookup.parmQuery(query);
SysTableLookup.performFormLookup();

}