How to check if the the queries in a data madel hit DB parallelly or in a sequence in BI Publisher?

Question

Summary

Content

I have 2 data set in a data model.

I want to check if the queries hit the DB parallely or sequentially.

If sequential, is there a way to set the property so that the 2 queries hit the DB parallely.

YGUTTIKONDA · Answer

I think the datasets are run sequentially ... the first created dataset takes precedence  ...  Please see below links for more info

https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T558188.htm

Hope this helps ....

--YG

Venkat Thota - BIP · Answer

place sysdate in each data set and execute data and check which data set executed first and second based on timestamp component in sysdate.Thanks