4 Replies Latest reply: Mar 28, 2013 10:52 PM by Turbokat RSS

    No BI query logs

    999065
      I was working on a production issue, unfortunately query logging is disabled in production. Technically query might be same as from dev, but i need to confirm prod query. What should be the right approach to solve the issue here?
        • 1. Re: No BI query logs
          Srini VEERAVALLI
          Use SET VARIABLE LOGLEVEL=2; in Answers->Advanced tab Prefix

          as in
          http://bischool.wordpress.com/2009/04/06/set-loglevel-from-answers/

          If helps mark as correct

          Edited by: Srini VEERAVALLI on Mar 28, 2013 5:22 PM
          • 2. Re: No BI query logs
            998980
            Since its production, you may not have much choice in modifying the RPD. You best bet might be to take xml from production, apply it in answers in dev, and get the query from development.
            • 3. Re: No BI query logs
              998980
              Also, if you still concerned about dev RPD not being the same in dev compared to prod, then deploy copy of production RPD on your local machine or a sandbox if you have OBIEE installed there, and get query from there (after setting the right log level).
              • 4. Re: No BI query logs
                Turbokat
                Take the logical query from analysis which would be shown from 'Manage Sessions' and run this in 'Issue SQL' under Administration and enable whatever logging you want to starting with 4 is recommended. Now you can click view log to get the physical query.!

                Run this in your DB.

                Mark if helps.

                Thanks,
                SVS