Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aggregates - Query specific performance optimization

Hi.

I am trying to build aggregates on two cubes (Actual and Plan) to improve the performance on two or three specific queries that are build on a MultiProvider base don these two cubes. In this respect, a few questions comes to mind:

Does anyone have some good documents or anything that could help me out as to what to consider when setting up these aggregates?

Is there anything specific I should look for in the query that I want to optimize performance for?

Would it be a good idea to build an aggregate that uses all the characteristics / navigational attributes for this one specific query?

Also, is it a bigger challenge to make aggregates “pay off” since the query is built on a Multiprovider and it is not possible to build aggregates on a MultiProvider?

Any input greatly appreciated! Thanks.

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question