Skip to Content
0
Former Member
Mar 23, 2018 at 01:47 AM

Universe data source takes time to return data in SAP Design Studio 1.6 SP5

64 Views Last edit Apr 05, 2018 at 05:45 AM 2 rev

Hi,

Design Studio version = 1.6 SP5

BI Platform version = 4.1 SP6

Backend = Microsoft SQL Server 2012 (x64)

App runs fine (locally & on BI platform) but with particular drop down box which return code/desc and consume simple query from universe takes around 13 secs for 200 rows. The design studio app has various data sources based on same universe. However, this particular query takes longer than expected.

If I run same query in universe itself then it takes only certain 226 ms for 10500 rows. Even webi retrieves the results < 1 sec.

So far I have tried following:

- Create a new app and then add this data source with same query > same result

- Try webi with same query > quick result

- Try different computer > same result

- Try DS trace option > no help (could not find anything useful)

- restarted APS which holds Analysis Application Service > same result

If you have faced this issue before or have some clue to fix it then please let me know.

Thanks in advance.

Angad