Universe

[Former Member]

what are the performance issues in bex query?

[Former Member · Accepted solution]

Hi,

Some guidelines:

First goto St03n t-code then you can find the statistics of the query ... by this we can analyze the different ways to increase query performance.

1. DB time: if this time is more, you can go for Aggregates, Compression, Indexing, Cube partition, Data partition to History & present by builidng 2 Cubes.

2. OLAP time: if this time is more, try ot increase OLAP cache, you have different options for the query in RSRT t-code.; select that properties which makes to store the query result set in OLAP Cache for permanent.

3. Front End time: If this time is more then try to avoid the more characteristics in displaying the query result.

and try ot make the result of query very less.

4 Use only less no of Characteristics in the initial report. Place remaining in Free chars.

5 Use Aggregates

6 Enable OLAP Cache

7 Use of precalculated web templates

8 BIA

All the Best,

Praveen