10 Replies Latest reply: Jan 24, 2013 3:36 AM by Vineeth. K.M RSS

    OBIEE11g

    975991
      HI,

      I am new to obiee11g.can anyone tel me how to create session variable in obiee11g.

      Thanks.
        • 1. Re: OBIEE11g
          Satya Ranki Reddy
          Hi,

          I guess it would be the same for 11g.

          Check here for more details;

          http://shivabizint.wordpress.com/2010/10/08/obiee11g-system-session-variables/

          THanks
          Satya
          • 2. Re: OBIEE11g
            975991
            can u please send me procedure to create session variable.
            in that it is not there.
            • 3. Re: OBIEE11g
              ReddyG
              Google it its simple..

              Open Admin tool -->Manage-->Variables-->it will show u the Variables pane with left pane&Right pane->select Session variables-->right click in the Right pane it will give you the Option to create new..*Note:*you cont edit/Create similar variables that are same as System Session variables..you can create Non-system variables.
              • 4. Re: OBIEE11g
                975991
                Hi...

                Thanks.........

                But in obiee11g the connection pool is disable for session variable.
                Can u please tel me what are all the things before i want to do in obiee11g to create session variable...

                thanks.
                • 5. Re: OBIEE11g
                  Srini VEERAVALLI
                  Check this
                  http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/biadmin11g_02/biadmin11g.htm#t12

                  If helps mark
                  • 6. Re: OBIEE11g
                    Vineeth. K.M
                    Hi,

                    According to the best practices, you should have 2 connection pools in OBI. One for retrieving the data and the second one for the Init blocks.
                    Now, OBI 11g forces you to have a second connection pool to be chosen for the Init block / session / repository variable.
                    Please go ahead and create a second connection pool in the physical layer of the RPD and you should be able to select the connection pool in the Init block.

                    Thanks,
                    Vineeth
                    • 7. Re: OBIEE11g
                      975991
                      Hi...........
                      Thanks,
                      I used 2nd connection pool even through its thronging warning for me.
                      like this:"initialization block 'multi-tenantcy' uses connection pool "orcl"."connection pool" which is used for report queries. this may impact query performance"

                      Please tel me any solution for this warning.

                      Thanks.
                      • 8. Re: OBIEE11g
                        975991
                        Hi Thanks...

                        In this they didn't mention how to create session variable.so please send me the way to create session variable.
                        • 9. Re: OBIEE11g
                          Vineeth. K.M
                          Hi,

                          The warning says that the connection pool is used for reporting also.
                          Please make sure that you use the connection pool that you have created for Init block.

                          Thanks,
                          Vineeth
                          • 10. Re: OBIEE11g
                            975991
                            i used same connection pool even through its through the same warning for me.