Improving Query Performance by Effective and Efficient Maintenance of Aggregates
You have created queries over a Multiprovider or Infocube but when you are executing these queries using BEx Analyzer, they are taking lot of time to show the query result and query response time is more. We'll take an example where queries are built over a Multiprovider and there are four Info Cubes as part of this Multiprovider. There are already existing aggregates built over couple of Info cubes. This article explains how to improve the query performance by making effective and efficient use of aggregates of Info Cubes of the Multiprovider.