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