Skip to Content
author's profile photo Former Member
Former Member

XIR3.1 Universe Usage - Scheduled queries v/s run on demand queries

Hello Experts,

This is for XIR3.1 SP4 version.

Is there a way to find the usage of a universe and differentiate the usage numbers from the those run on demand queries versus the scheduled queries?

I have a report built off of the Audit Universe and it gives me the complete usage of a Universe. Now I want to find out how many hits were through the scheduled reports versus how many hits were run on demand?

If anyone has any query to accomplish this, then can you please share it?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 18, 2014 at 09:01 PM

    Hi,

    "Now I want to find out how many hits were through the scheduled reports versus how many hits were run on demand?"

    Hope the Auditor/en/Document Scheduling and Viewing Status would work for you.

    Hope this helps,

    Jin-Chong

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      "Is there a way to find out how many hits a universe received via scheduled jobs only?"

      Please check out Job service auditing events. For example, the scheduled jobs event_type_id are

      AUDIT_EVENT.Event_Type_ID In ( 327681,327682,327683 )

      Where 327681 is Job successful, 327682 is Job failed, and 327683 is Job failed. Job will be retried by the CMS.

      For the webi refresh,

      AUDIT_EVENT.Event_Type_ID = 11

      Where the event_type_id 11 Document Retrieved

      You will find all the SQL query you need from edit query on "Auditor/en/Document Scheduling and Viewing Status" Webi report and BusinessObjects Enterprise Administrator's Guide.

      Hope this helps,

      Jin-Chong

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.