I have installed OBIEE11g (18.104.22.168.) and configured OBIA 22.214.171.124.. I am using Oracle Data Warehouse(Database Source) and warehouse tables exists under this node. Out of the Box OBIA has two connection pool
1. Oracle Data Warehouse Connection Pool
2. Oracle Data Warehouse Repository Initblocks Connection Pool
I have standalone OBIA / OBIEE install and data is source from Oracle Ebusiness suite 12.1.3 and Siebel 8.1.x
I need to define new Initialization Block and in Administration Tool I am navigating Manage--> Variable and under Session I am creating new Initialization Block ..
I am not sure which connection pool do I need to use to define new Initialization Block ?? I have checked exisiting Initialization Block and they have been using " Oracle Data Warehouse Repository Initblocks Connection Pool"...
Reviewing SQL query log in Answers is using "Oracle Data Warehouse Connection Pool "...
Can anyone suggest where do I need to write my Initialization Block ??