If you only want to display data records of a table that contain certain financial dimensions in a form, you can do this by overwriting the init() of the FormDataSource as follows:
public void init() { super(); SysQuery::addDimensionAttributeRange(salesTable_ds.query(), salesTable_ds.name(), fieldStr(Salestable, DefaultDimension), DimensionComponent::DimensionAttribute, '1001', 'CostCenter'); }
You can also call addDimensionAttributeRange() multiple times, so you can filter for multiple dimensions simultaneously.
clearDimensionRangesFromQuery() removes such filters:
SysQuery::clearDimensionRangesFromQuery(salesTable_ds.query())
If you only want to display data records of a table that contain certain financial dimensions in a form, you can do this by overwriting the init() of the FormDataSource as follows:
You can also call addDimensionAttributeRange() multiple times, so you can filter for multiple dimensions simultaneously.
clearDimensionRangesFromQuery() removes such filters: