Skip to Content
0

DS report run slowly

Nov 24, 2016 at 01:23 PM

120

avatar image
Former Member

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
avatar image
Former Member 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
Former Member

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
Former Member
Former Member

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
Former Member
Former Member

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
Former Member
Former Member

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
Former Member
Former Member

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
Former Member
Former Member

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
Former Member
Former Member

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