How to reduce loading time of query on RSRT

[former_member746094]

How to reduce loading time of query on RSRT?

What Data manager exactly does?

Here is my running time on debug mode(figure 2) and composite provider (figure 1). I tried to use cache on database but there are always an error (figure 3). I tried use local cache but not really help much (~reduce 1-2 sec)

I already did a dynamic partition on DSO MSEGO_CN (contain data from table MSEG), the loading time from ~170 s to 150 s and remove some column on query (e.g article number on MSEG) the loading time from ~150 to ~100 s.

Is there any other way to improve the performance of query?

My query contains ~ 30 column key figure, is this the reasons of time consuming?.

figure 1

figure 2

figure 3.

[FCI]

Hi Jacky,

The data manager refers to the DB. Here, 52 s are spent to get the data at the db level.

To improve this part, I can only give general advices:

• Simplify (your composite is quite an heavy one, try to identify the join that cause a performance issue, study the possibility to materialize a part of the model)
• Filter (depending on the filters you set and the time at which the db apply them, the performance can change drastically).

It may be useful to trace the sql behind the scene and play with variants of this sql to identify the costly point(s).

Note : I'm suprised by the OLAP transfer time. 25s to transfer 282 records. Did I read it correctly ?

Regards,

Frederic