Skip to Content
0

DS report run slowly

Nov 24, 2016 at 01:23 PM

108

avatar image

hey,I was use OLAP connection,we are use sap businessobjects design studio 16.2.2.

even though I just use one datasource,its still slowly.Have sombody knows it?

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Poovarasan Boopalan Nov 24, 2016 at 04:09 PM
-1

Hi Jing Zhang,

Have you checked the profiling of application?

Can you show the screenshot of your profiling result?

Thanks,

Poovarasan

Show 7 Share
10 |10000 characters needed characters left characters exceeded

hey,Poovarasan,

I'm very happy to receive your reply.

but can you tell me how to check the profiling of application? I can't find the way .

Thanks.

0

Hi Jing Zhang,

You can activate runtime profiling using menu Tools -> Preference -> Support Settings then select Activate Runtime profiling option. It works for executing application in platform.

For local execution, the another way is you can add &PROFILING=X at the end of your application URL,

After adding it as shown, when you reload your application a window like above will appear with time statistics. you can download the statistics file and analyse it. It will have timing of every step of application execution.

If the time is more data sources time, then you need to optimize the query.

If the time is more in Design studio, then we need to look for the components rendering time and try to reduce it.

For more information, you can refer below blogs.

https://blogs.sap.com/2015/06/30/understanding-profiling-and-statistics-in-design-studio/

https://blogs.sap.com/2013/12/08/design-studio-tips-and-tricks-measuring-performance/

https://blogs.sap.com/2014/09/18/performance-monitoring-in-design-studio/

Let me know if you need anything in this.

Thanks,

Poovarasan

profiling-1.png (24.3 kB)
profiling-2.png (31.7 kB)
0
Poovarasan Boopalan

hey,Poovarasan.

I'm sorry to reply so late.

I have tried the way you said, It's very nice.thanks.

And those blogs are very helpful you recommended,which helped me save half time.

Thanks.

Jing.

0
Poovarasan Boopalan

hey,Poovarasan.

I recently continued to optimization my DS report,I've optimization it from 16s to 2s,but I want to know whether

following picture can continue to optimization,and I don't know where CREATE_ITEM from, and it's so many.

Thanks.

Jing

0

Hi Jing Zhang,

The CREATE_ITEM is the step where the components used in the dashboard will be created.

Like charts, container components etc.

It cannot be removed or optimized.

Thanks,

Poovarasan

0
Poovarasan Boopalan

Hi Poovarasan.

How is this, the times of follow picture can remove?

How often did you spent time in open report,is it too long that I open a report use 3.5s?

Thanks.

Jing

13755-1.png (28.9 kB)
0

Hi Jing Zhang,

Below 5 seconds for initial view of application without user interaction disturbance is a good performance dashboard.

In the Rendering statistics you can still get time split of rendering of components.

Thanks,

Poovarasan

0