These are the jobs for getting ledger dimension values for active account structure in AX 2012
1*
static void
getDimensionCombinationValues(Args _args)
{
DimensionAttributeLevelValueAllView
dimensionAttributeLevelValueAllView;
DimensionAttribute dimensionAttribute;
Set
dimensionAttributeProcessed;
LedgerDimensionAccount _ledgerDimension;
str segmentName,
segmentDescription;
SysDim segmentValue;
str
getDynamicAccountAttributeName(TableNameShort _dimensionAttrViewName)
{
#Dimensions
container
cachedResult;
SysModelElement modelElement;
SysDictTable sysDictTable;
DictView dictView;
Label label;
Debug::assert(_dimensionAttrViewName like #DimensionEnabledPrefixWithWildcard);
//
Get/cache results of the AOT metadata lookup on the view
cachedResult =
DimensionCache::getValue(DimensionCacheScope::DynamicAccountAttributeName,
[_dimensionAttrViewName]);
if
(cachedResult == conNull())
{
//
Find the matching model element and instantiate the AOT metadata definition of
the view
select
firstOnly AxId, Name from modelElement
where modelElement.ElementType ==
UtilElementType::Table
&&
modelElement.Name == _dimensionAttrViewName;
sysDictTable = new sysDictTable(modelElement.AxId);
Debug::assert(sysDictTable.isView());
//
Create an instance of the view and get the singular representation of the
entity name as a label ID (do not translate)
dictView = new dictView(modelElement.AxId);
cachedResult =
[dictView.singularLabel()];
DimensionCache::insertValue(DimensionCacheScope::DynamicAccountAttributeName,
[_dimensionAttrViewName], cachedResult);
}
label = new
label();
return
label.extractString(conPeek(cachedResult,
1));
}
_ledgerDimension = 22565435768;
if
(_ledgerDimension)
{
dimensionAttributeProcessed = new Set(extendedTypeId2Type(extendedTypeNum(DimensionAttributeRecId)));
while
select DisplayValue,
AttributeValueRecId from
dimensionAttributeLevelValueAllView
order
by
dimensionAttributeLevelValueAllView.GroupOrdinal,
dimensionAttributeLevelValueAllView.ValueOrdinal
where
dimensionAttributeLevelValueAllView.ValueCombinationRecId == _ledgerDimension
join
Name, Type, ViewName, RecId from
dimensionAttribute
where
dimensionAttribute.RecId ==
dimensionAttributeLevelValueAllView.DimensionAttribute
{
if
(!dimensionAttributeProcessed.in(dimensionAttribute.RecId))
{
if
(DimensionAttributeType::DynamicAccount == dimensionAttribute.Type)
{
//
Use the singular name of the view backing the multi-typed entity
segmentName =
getDynamicAccountAttributeName(dimensionAttribute.ViewName);
}
else
{
//
Use the name of the attribute directly for all other types (main account,
custom list, existing list)
segmentName =
dimensionAttribute.localizedName();
}
segmentValue =
dimensionAttributeLevelValueAllView.DisplayValue;
segmentDescription =
DimensionAttributeValue::find(
dimensionAttributeLevelValueAllView.AttributeValueRecId).getName();
dimensionAttributeProcessed.add(dimensionAttribute.RecId);
info(strFmt("%1: %2, %3",
segmentName, segmentValue, segmentDescription));
}
}
}
}
2*
static void
getActiveDimensionCombinationValues(Args _args)
{
//
DimensionAttributeValueCombination stores the combinations of dimension values
// Any tables
that uses dimension combinations for
main account and dimensions
// Has a
reference to this table’s recid
DimensionAttributeValueCombination dimAttrValueCombination;
// Class
Dimension storage is used to store and manipulate the values of combination
DimensionStorage dimensionStorage;
// Class
DimensionStorageSegment will get specfic segments based on hierarchies
DimensionStorageSegment segment;
int segmentCount,
segmentIndex;
int hierarchyCount,
hierarchyIndex;
str segmentName,
segmentDescription;
SysDim segmentValue;
DimensionHierarchy dimensionHierarchy;
LedgerDimensionAccount ledgerDimension;
;
ledgerDimension = 22565435768;
setPrefix("Dimension values");
//Fetch the
Value combination record
dimAttrValueCombination =
DimensionAttributeValueCombination::find(ledgerDimension);
setPrefix("Breakup for " +
dimAttrValueCombination.DisplayValue);
// Get
dimension storage
dimensionStorage =
DimensionStorage::findById(ledgerDimension,true);
if
(dimensionStorage == null)
{
throw
error("@SYS83964");
}
dimensionHierarchy =
DimensionStorage::getAccountStructureFromLedgerDimension(ledgerDimension);
// Get hierarchy
count
hierarchyCount =
dimensionStorage.hierarchyCount();
//Loop through
hierarchies to get individual segments
for(hierarchyIndex
= 1; hierarchyIndex <= hierarchyCount;
hierarchyIndex++)
{
//get
segment value for active account structure
if(
dimensionHierarchy.RecId ==
DimensionHierarchy::find(dimensionStorage.getHierarchyId(hierarchyIndex)).RecId)
{
setPrefix(strFmt("Hierarchy:
%1", dimensionHierarchy.Name));
//Get
segment count for hierarchy
segmentCount =
dimensionStorage.segmentCountForHierarchy(hierarchyIndex);
//Loop
through segments and display required values
for
(segmentIndex = 1; segmentIndex <=
segmentCount; segmentIndex++)
{
// Get
segment
segment =
dimensionStorage.getSegmentForHierarchy(hierarchyIndex, segmentIndex);
//
Get the segment information
if
(segment.parmDimensionAttributeValueId() != 0)
{
//
Get segment name
segmentName =
DimensionAttribute::find(DimensionAttributeValue::find(segment.parmDimensionAttributeValueId()).DimensionAttribute).Name;
//Get
segment value (id of the dimension)
segmentValue = segment.parmDisplayValue();
//Get
segment value name (Description for dimension)
segmentDescription = segment.getName();
info(strFmt("%1:
%2, %3", segmentName, segmentValue, segmentDescription));
}
}
}
}
}
