static void getDimValue(Args _args)
{
str 30 finMainaccount, finArea, finBussiness, fnCostCenter, finFamily, finSeason, finProject, finCompany;
DimensionAttributeLevelValueAllView dimAttrView; //View that will display all values for ledger dimensions
DimensionAttribute dimAttr; //Main dimension attribute table
int i;
i++;
while select DisplayValue from dimAttrView
where dimAttrView.ValueCombinationRecId == generalJournalAccountEntry.LedgerDimension
join Name from dimAttr
where dimAttr.RecId == dimAttrView.DimensionAttribute
{
switch (dimAttr.Name)
{
case "MainAccount":
finMainaccount = strFmt(dimAttrView.DisplayValue);
break;
case "Area":
finArea = dimAttrView.DisplayValue;
break;
case "CostCenter":
fnCostCenter = dimAttrView.DisplayValue;
break;
case "Family":
finFamily = dimAttrView.DisplayValue;
break;
case "Business":
finBussiness = dimAttrView.DisplayValue;
break;
case "Project":
finProject = dimAttrView.DisplayValue;
break;
case "Season":
finSeason = dimAttrView.DisplayValue;
break;
case "Company":
finCompany = dimAttrView.DisplayValue;
break;
}
}
}
{
str 30 finMainaccount, finArea, finBussiness, fnCostCenter, finFamily, finSeason, finProject, finCompany;
DimensionAttributeLevelValueAllView dimAttrView; //View that will display all values for ledger dimensions
DimensionAttribute dimAttr; //Main dimension attribute table
int i;
i++;
while select DisplayValue from dimAttrView
where dimAttrView.ValueCombinationRecId == generalJournalAccountEntry.LedgerDimension
join Name from dimAttr
where dimAttr.RecId == dimAttrView.DimensionAttribute
{
switch (dimAttr.Name)
{
case "MainAccount":
finMainaccount = strFmt(dimAttrView.DisplayValue);
break;
case "Area":
finArea = dimAttrView.DisplayValue;
break;
case "CostCenter":
fnCostCenter = dimAttrView.DisplayValue;
break;
case "Family":
finFamily = dimAttrView.DisplayValue;
break;
case "Business":
finBussiness = dimAttrView.DisplayValue;
break;
case "Project":
finProject = dimAttrView.DisplayValue;
break;
case "Season":
finSeason = dimAttrView.DisplayValue;
break;
case "Company":
finCompany = dimAttrView.DisplayValue;
break;
}
}
}
No comments:
Post a Comment