Dimensions table from Ax4 to Ax2012

Finance and Operations/AX Developer Forum
1

Hi,

Does anyone know which table replaced “Dimensions” table from Ax4 in Ax2012 ? And… could someone help out upgrading this method to Ax2012 ? Cant find and do it by myself.

void writeDimensionFile(int _dimCount, str _dimTxt)
{
Query queryDim;
QueryRun queryRunDim;
queryBuildDataSource queryBuildDSDim;
SysDictEnum SysDictEnum = new SysDictEnum(enumNum(SysDimension));
Dimensions dimensions;
int dimValue;
;
dimValue = SysDictEnum.index2Value(_dimCount-1);

queryDim = new Query();
queryBuildDSDim = queryDim.addDataSource(tableNum(Dimensions));
queryBuildDSDim.addRange(fieldNum(Dimensions, DimensionCode)).value(SysDictEnum.value2Label(dimValue));
queryRunDim = new QueryRun(queryDim);

while (queryRunDim.next())
{
dimensions = queryRunDim.get(tableNum(Dimensions));

if (!dimensions.Closed) // R01
{
info(Dimensions.Num);
info(Dimensions.Description);
}
}
}

2

Hi Raimondas,

“Dimensions” table from Ax4 in Ax2012 is “DimensionFinancialTag”

I think use this code run as same

static void dimensionFinancialTag(Args _args)
{
int _dimCount;
str _dimTxt;

Query queryDim;
QueryRun queryRunDim;
queryBuildDataSource queryBuildDSDim;
SysDictEnum SysDictEnum = new SysDictEnum(enumNum(SysDimension));
DimensionFinancialTag dimensionFinancialTag;
int dimValue;
;
_dimCount = 0;
dimValue = SysDictEnum.index2Value(_dimCount-1);

queryDim = new Query();
queryBuildDSDim = queryDim.addDataSource(tableNum(DimensionFinancialTag));
queryBuildDSDim.addRange(fieldNum(DimensionFinancialTag, Value)).value(SysDictEnum.value2Label(dimValue));
queryRunDim = new QueryRun(queryDim);

while (queryRunDim.next())
{
dimensionFinancialTag = queryRunDim.get(tableNum(DimensionFinancialTag));

info(dimensionFinancialTag.Value);
info(dimensionFinancialTag.Description);

}

}