3 Replies Latest reply: Aug 15, 2012 4:36 PM by Maleathe-Oracle RSS

    How to activate usage tracking in OBIEE 11.1.1.6

    JoeSSI
      Hello,

      http://obieestuff.blogspot.com/2012/02/usage-tracking-in-obiee-11116.html

      From that link, I have set the enable usage tracking to Yes, but still no show in dashboard.
      Do I need to create schemas, connection pool for usage tracking in OBIEE 11.1.1.6?
      where to download usage tracking table?what step i must do in order to make the usage tracking 11.1.1.6 can show in dashboard?

      Thanks before

      JOE
        • 1. Re: How to activate usage tracking in OBIEE 11.1.1.6
          user248025
          Hi,

          Yes.you can find usage tracking files under below path
          Obiee11160 install drive D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample

          for the schema you can find it below
          drive:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\schema

          In obiee11.1.1.6.0 version Usage Tracking S_NQ_ACCT and Scheduling objects are moved from the target database area to RCU schema and also new column added and several column types changed.

          You can also download usage tracking RPD from this link
          http://total-bi.com/2011/09/obiee-11g-usage-tracking-rpd/

          Otherwise better to copy the 11g provided Usage tracking RPD layers and merge it with your upgraded RPD.However still Usage Tracking customization required.

          For more refer:http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/usage_track.htm

          Thanks
          Deva
          • 2. Re: How to activate usage tracking in OBIEE 11.1.1.6
            Satya Ranki Reddy
            Hi,

            Usage tracking table structure has changed in 11g.The table should have all the columns listed here,

            http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/usage_track.htm

            You have the tables readily imported in the rpd uploaded in this blog,

            http://total-bi.com/2011/09/obiee-11g-usage-tracking-rpd/

            Schema:

            It should be in your middleware home directory \instances\whatever\bifoundation\OracleBIServerComponent\coreapplication_obis1\schema

            Hope this help's

            Thanks
            satya
            • 3. Re: How to activate usage tracking in OBIEE 11.1.1.6
              Maleathe-Oracle
              This question is a follow-up - forgive me, as I'm new to OBIEE, and the question may not seem intelligent.

              When we configure OBIEE to pull information out of our data warehouse, we are being told by customer that we are not allowed to create RCU schemas on the data warehouse database.
              We will need to use summary advisor to create aggregates.

              What steps would I need to do to be able to use Summary Advisor is my RCU schemas are on a different database?