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)
<i>My Question is this. When read access is performed, will more than 1 aggregate be used if I create more detailed aggregates are found.</i>
The OLAP will use the generic Aggregate. If it feels that the generic Aggregate is not sufficient in the query navigation, it takes the data from other aggregate (which is suitable for current navigation) .
And It is sure that the query can use multiple aggregates.
Anil Kumar Sharma .P