0 Replies Latest reply: Mar 14, 2012 12:52 PM by 920824 RSS

    OBIA 7.9.6.3. Initialization Block

    920824
      Hello All,
      I have installed OBIEE11g (11.1.1.5.) and configured OBIA 7.9.6.3.. 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 ??
      Many Thanks,
      Sat