Hello,
The query on the bottom gives me the following result :
A1201~710~2015~12~~~~~~~01~~~~~~~016~001~423418.44~
A1201~710~2015~12~~~~~~~01~~~~~~~016~020~114214.80~
A1201~710~2015~12~~~~~~~01~~~~~~~016~022~9954.60~
A1201~710~2015~12~~~~~~~01~~~~~~~016~030~170156.88~
A1201~710~2015~12~~~~~~~01~~~~~~~016~031~4892.04~
As you can see , this sums the value for each cost center :
I want to see each value seperately like this :
A1201~710~2015~12~~~~~~~11~~~~~~~014~~647770.71~
A1201~710~2015~12~~~~~~~01~~~~~~~016~~102148.68~
A1201~710~2015~12~~~~~~~01~~~~~~~016~001~423418.44~
A1201~710~2015~12~~~~~~~01~~~~~~~016~020~41431.32~
A1201~710~2015~12~~~~~~~01~~~~~~~016~020~2333.04~
A1201~710~2015~12~~~~~~~01~~~~~~~016~020~21491.64~
A1201~710~2015~12~~~~~~~01~~~~~~~016~020~25184.28~
A1201~710~2015~12~~~~~~~01~~~~~~~016~020~23774.52~
A1201~710~2015~12~~~~~~~01~~~~~~~016~022~3228.00~
A1201~710~2015~12~~~~~~~01~~~~~~~016~022~6726.60~
A1201~710~2015~12~~~~~~~01~~~~~~~016~030~75939.12~
-------------------------------------------------------
private Query baseQuery_AssetTrans()
{
Query q = new Query();
QueryBuildDataSource qbds, qbdsAssetBook, qbdsAssetTrans;
QueryBuildRange qbr;
DimensionProvider dimensionProvider;
Name costCenterDimName;
//-- AssetTable --//
qbds = q.addDataSource(tableNum(AssetTable));
// filter on majorType -> not empty
qbr = qbds.addRange(fieldNum(AssetTable, MajorType));
qbr.value(SysQuery::valueNotEmptyString());
//qbds.addGroupByField(fieldNum(AssetTable, MajorType));
//-- AssetBook --//
qbdsAssetBook = qbds.addDataSource(tableNum(AssetBook));
qbdsAssetBook.relations(true);
// acquisition must be in this year or earlier
qbr = qbdsAssetBook.addRange(fieldNum(AssetBook, AcquisitionDate));
qbr.value(strFmt('(%1.%2 <= %3)'
, qbdsAssetBook.name()
, fieldStr(AssetBook, AcquisitionDate)
, date2StrXpp(toDate)));
// exclude no depreciation
qbr = qbdsAssetBook.addRange(fieldNum(AssetBook, Depreciation));
qbr.value(queryValue(NoYes::Yes));
//-- AssetTrans --//
qbdsAssetTrans = qbdsAssetBook.addDataSource(tableNum(AssetTrans));
qbdsAssetTrans.relations(true);
qbdsAssetTrans.addSelectionField(fieldNum(AssetTrans, AmountMST), SelectionField::Sum);
//-- Group by cost center --//
dimensionProvider = new DimensionProvider();
costCenterDimName = DimensionAttribute::find(RDSFinancialDimensionMapping::getAttributeRecIdForFinDimension(RDSFinancialDimensionValues::CostCenter)).Name;
qbds = dimensionProvider.addDataSourceToQuery(q, qbdsAssetTrans.name(), fieldStr(assetTrans, DefaultDimension), DimensionComponent::DimensionAttribute, costCenterDimName);
qbds.addGroupByField(fieldNum(DimensionAttributeValueSetItemView, DisplayValue));
return q;
}
I tried commenting the group by's and the sum but i still can't get a decent result.
What am i missing here?
