Skip to Content

BO Design Studio 1.6 Performance

Apr 24, 2017 at 11:28 AM


avatar image

Hi Tammy,

I am currently facing performance issue in Design Studio during development of application.

1.Taking long time to load application and prompt dialog.

2.Once answered prompt values it's again taking long time to show OK button.

I am trying to create dashboard on unx universe. Please find below details for reference.

1.Version: DS 1.6 SP3

2.Rows: 434


4.Total Execution time in DB: 530 ms.


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

4 Answers

Tammy Powlas
Apr 24, 2017 at 12:56 PM

Hi - since this is a community, I recommend not asking your questions to a particular person

Which version of BI4x are you using? Is your BI Platform sized correctly?

10 |10000 characters needed characters left characters exceeded
Mantu Sahu Apr 24, 2017 at 01:06 PM

Hi Tammy,

Well noted.

My version is BI 4.1SP5 P5. The sizing of server is also correctly setup.

I'm facing issue during designing of application. I have only one data source, and even if I click on edit initial view of data source, then also it's takes time. It takes more time to load in my web browser to load the prompt dialog box.

I would like to know is there any configuration which we need to make for DS tuning.


Mantu Sahu

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

Hi Mantu - I will keep searching, but I did find this - BI pattern book, performance testing - it may help to better pinpoint the performance issue:


Thanks Tammy. Please keep me posted.

Thanks your prompt assistance.

Andreas J.A. Schneider
May 22, 2017 at 10:47 AM

First, 4.1 SP5 is rather old, I suggest getting on a more recent patch level such as 4.2 with SP4.

And universes as a data source seem to have been more of an afterthought when it comes to DesignStudio, therefore I believe being on a recent patch level is even more important.

Another question, how long does the query take in a "native" universe Frontend tool such as Webi?

10 |10000 characters needed characters left characters exceeded
Mohd Fahad May 30, 2017 at 03:39 PM

Hi - Can you try to plug-in the same universe connection to WEBI or Analysis for OLAP and see if you encounter the same performance issue ?

It will clear out if the you need to fine-tune on DS-server sizing.

I recommend checking on browser version IE10 or higher and note there is no add-on on the browser that is consuming browser rendering speed since DS is generate HTML output.

Sometimes you will get message at the bottom in yellow - speed up browser removing un-necessary add-on like 'PDF editor and so on.

10 |10000 characters needed characters left characters exceeded