Recently I needed to create a report against GL transactions filtered on specific accounts, sites and cost centers.
At first glance I thought I’d need to start by going through the dreaded DimensionAttributeValueCombination table to the MainAccount table, in order to setup my query.
However, there is a MUCH easier way.
The GeneralJournalAccountEntry table has a field LedgerAccount that stores the same information.
3. Modify your query within your DP class, ProcessReport method:
This should get you well on your way to quickly filtering those GL transactions!