Aggregates - Query specific performance optimization
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.