Skip to Content
0

Performance Issues in SAP Design Studio 1.6

Feb 02, 2017 at 04:25 AM

575

avatar image

Hi All,

I am creating an application using SAP Design Studio 1.6 SP2.

My data source is universe.

I have 5 different universes namely Universe_1 , Universe_2, Universe_3,Universe_4, Universe_5 and I have used a tabstrip for each universe.

Due to various scenarios,(like having different dimensions in the Rows) I have to take a copy of each universe to show the output in the desired format, and I ended up have 13 universes all together.

But the outcome of this was the performance issues. It takes close to 1 min to execute the application, and once the application is executed, it takes close to 30 secs to switch between each tabs.

This is really a big concern.

I have followed few tips mentioned in below article like, setting the Load in script to TRUE, background processing ,but that did not make much difference.

https://blogs.sap.com/2015/05/22/design-studio-performance-best-practices/

Can someone please guide me on how to improve the performance.

Thanks.

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

2 Answers

avatar image
Former Member Feb 02, 2017 at 06:59 AM
0

Hi Poojitha,

Can you try reducing the data source count by using data selection in charts and data binding in other components?

It may help in reducing datasource and also please use a if statement in each tab navigation to load data source if not loaded in the on select of a tab.

If possible can you show us your script for loading data so we can debug it.

Thanks,

Poovarasan

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

Hi Poovarasan,

I have used data selection in charts, but since the data selection option doesn't allow me to select dimensions, I had to take a copy of the universe.

I have also used the option to load data source on tab selection, like

On Select : DS_1.loadDatasource();

0
Former Member
Poojitha Sukumaran

Hi Poojitha,

Can you show us the profiling statistics of your dashboard?

So we can have clear picture of where it takes long time. Also check the run time of switching tabs if you load all the datasources in startup without using scripting.

So it may give us info about the loading time of each page.

Thanks,

Poovarasan

0

I have taken statistics of the dashboard.

Please let me know if I need to send any further information.

Thanks

0
Former Member
Poojitha Sukumaran

Hi Poojitha,

Are you accessing your system from an external network using VPN?

It seems to be your application is opening at 6 seconds. But there is a problem while connecting to the servers. It happens while you are accessing the system from an external network.

Thanks,

Poovarasan

0

Hi Poovarasan,

Yes, I access my system using VPN.

Is there anything that I can do to improve my dashboard performance?

0
Former Member
Poojitha Sukumaran

Hi Poojitha,

You can't do anything for it, It is handled by your IT team. Ask them to look into it.

Because the problem is VPN is taking time to hit the BOBJ server. So the dashboard takes time to get started to load.

Thanks,

Poovarasan

0
Show more comments

You can Google/search how to improve VPN performance

0
Poojitha Sukumaran Feb 10, 2017 at 06:26 PM
0

Hi Poovarasan,

As you mentioned, I created a sample empty application using the same connection and the application executes in 20-30s.

Thanks.

Share
10 |10000 characters needed characters left characters exceeded