Display Default Dimension Description Name AX 2102
private Name NA003DivisionDimensionName(DimensionDefault _defaultDimension)
{
DimensionAttributeValueSetItem setItem;
DimensionAttributeValue dimAttrValue;
DimensionAttribute dimAttr;
Common common;
DictTable dictTable;
str Name;
DimensionAttributeValueSetStorage set = new DimensionAttributeValueSetStorage();
select RecId, DisplayValue from setItem where setItem.DimensionAttributeValueSet == _defaultDimension
join dimAttrValue
where dimAttrValue.RecId == setItem.DimensionAttributeValue
&& dimAttrValue.IsDeleted == false
join dimAttr
where dimAttr.RecId == dimAttrValue.DimensionAttribute
&& dimAttr.Name == "@SYS40998";
if (dimAttr && dimAttrValue)
{
dictTable = new DictTable(dimAttr.BackingEntityType);
common = dictTable.makeRecord();
if (common.TableId)
{
select common where common.(dimAttr.KeyAttribute) == dimAttrValue.EntityInstance;
name = common.(dimAttr.NameAttribute);
}
}
return name;
}
private Name NA003DivisionDimensionName(DimensionDefault _defaultDimension)
{
DimensionAttributeValueSetStorage dimStorage;
DimensionAttribute DimensionAttribute;
Counter i;
DimensionAttribute dimAttr;
DimensionAttributeValue dimAttrValue;
Common common;
DictTable dictTable;
str Name;
str value;
// make the dimension storage object
dimStorage = DimensionAttributeValueSetStorage::find(_defaultDimension);
for (i=1 ; i<= dimStorage.elements() ; i++)
{
// get attribute select here.
select firstonly dimAttrValue
where dimAttrValue.RecId == dimStorage.getValueByIndex(i)
join dimAttr
where dimAttr.RecId == dimAttrValue.DimensionAttribute
&& dimAttr.Name == "@SYS40998";
if (dimAttr && dimAttrValue)
{
dictTable = new DictTable(dimAttr.BackingEntityType);
common = dictTable.makeRecord();
if (common.TableId)
{
select common where common.(dimAttr.KeyAttribute) == dimAttrValue.EntityInstance;
name = common.(dimAttr.NameAttribute);
}
break;
}
}
return name;
}
Comments
Post a Comment