We are performance tuning BPS web interface. I have found a note 560369 (Proposal BW aggreates for sem-bps) regarding response times for reading of transactional data.
We have built a report layout that contains Amount (by period) for the current year plus a total amount for last years actuals.
My Question is this. When read access is performed, will more than 1 aggregate be used if I create more detailed aggregates are found. (eg: In Bex queries multiply aggregate may be used in a to produce a query result)