Set pdqpriority for reports in OBIEE

Question

Hi,

Im using informix as the datasource for OBIEE 11g, I want obiee to set pdqpriority of informix database everyt ime a report is run to maximize the cpu usage. Is that allowed in OBIEE database direct access? Please help. Thank you.

1723637 · Answer

Hi Thomas,

I'll try this at once, thank you.

Thomas Dodds · Answer

did you try something like:  http://gerardnico.com/wiki/dat/obiee/connection_script

using:   SET PDQPRIORITY {DEFAULT|OFF|LOW|HIGH};