Issue :
Connection Pool Select Button is Disabled when creating init bloc in 11g:
Unable to create session variable using OBIEE 11.1.1.5 Admin tool
It is not possible to select a connection pool when we try to create an OBIEE Session variable in the rpd.
Solution:
Solution is to check “Allow First Connection for init block” to true
For setting “Allow First Connection for init block” follow below steps :
1. In the Administration Tool, select Tools, then select Options to display the Options dialog.
2. On the General tab, select ”Allow First Connection for init block.
This option is not a best practice and might cause performance issues.
