Retrieve Data From Financial Dimension Fields

(1) Share

Report

Posted on by AB-24101041-0

I am developing a report that is already working, I need to add 2 new fields and retrieve data from financial dimension. I used this code in the event handler "onInserting" but the data didn't show in the report.


   AssetBalancesTmp assetBalancesTmp = sender as AssetBalancesTmp;
   AssetTable assetTable;
        dimensionAttributeValue dimensionAttributeValue;
        DimensionAttributeValueSet DimensionAttributeValueSet;
        dimensionAttributeValueSetItem dimensionAttributeValueSetItem;
        dimensionAttribute dimensionAttribute;
        DefaultDimensionview DefaultDimensionview;



        while select * from assetTable
    where assetTable.AssetId == assetBalancesTmp.AssetId

    join RecId from dimensionAttributeValueSet
        where dimensionAttributeValueSet.RecId == assetTable.DefaultDimension
    join RecId, DisplayValue from dimensionAttributeValueSetItem
        where dimensionAttributeValueSetItem.DimensionAttributeValueSet == dimensionAttributeValueSet.RecId
    join RecId from dimensionAttributeValue
        where dimensionAttributeValue.RecId == dimensionAttributeValueSetItem.DimensionAttributeValue
    join RecId, Name from dimensionAttribute
        where dimensionAttribute.RecId == dimensionAttributeValue.DimensionAttribute

        && (dimensionAttribute.Name == "CostCenter" 
        || dimensionAttribute.Name == "Branch")
        {

            assetBalancesTmp.Branch = DefaultDimensionview.DisplayValue;
            assetBalancesTmp.CostCenter = DefaultDimensionview.DisplayValue;


        }

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Gelev Martin 13 on at

Like
a
(1)

Report
Copy link

Link copied!

You can try the following select:

while select DimensionAttributeValue.DISPLAYVALUE
   from DimensionAttributeValue
join DIMENSIONATTRIBUTE
   where DimensionAttributeValue.DIMENSIONATTRIBUTE = DIMENSIONATTRIBUTE.RECID
join dimensionAttributeValueSetItem
   where DimensionAttributeValue.RECID = dimensionAttributeValueSetItem.DIMENSIONATTRIBUTEVALUE
join assetTable
   where dimensionAttributeValueSetItem.DIMENSIONATTRIBUTEVALUESET = assetTable.DEFAULTDIMENSION
   && (DIMENSIONATTRIBUTE.NAME = 'CostCenter' or DIMENSIONATTRIBUTE.NAME = 'Branch'
{
   assetBalancesTmp.Branch = DimensionAttributeValue.DisplayValue
   assetBalancesTmp.CostCenter = DimensionAttributeValue.DisplayValue
}

Was this reply helpful? Yes No
Verified answer

AB-24101041-0 38 on at

Like
a
(0)

Report
Copy link

Link copied!
DimensionAttributeValueSetStorage dimStorage = DimensionAttributeValueSetStorage::find(assetBook.DefaultDimension); str costCenterValue = ''; str branchValue = ''; for (int i = 1; i <= dimStorage.elements(); i++) { str attributeName = DimensionAttribute::find(dimStorage.getAttributeByIndex(i)).Name; str attributeValue = DimensionAttributeValue::find(dimStorage.getValueByIndex(i)).getValue(); if (attributeName == 'CostCenter') { costCenterValue = attributeValue; } else if (attributeName == 'Branch') { branchValue = attributeValue; } }

Solved!

Was this reply helpful? Yes No