Skip to Content
avatar image
Former Member

BI 4.1 SP06 Publication performance

Hello,

We are on BI 4.1 SP06 in Windows 2008 server R2.

I have publication which is on CR2013.

It runs for eight hours and sends e-mail to 100 users.

Is there any way to find out how long it took to get the actual report done from the Database and then total time it took to send e-mails.

I checked some of the audit tables but not successful so far

Please advice.

Regards.

Thank you,

SS

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 06, 2016 at 06:33 PM

    No.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2016 at 03:15 AM

    Copy the report SQL to run in DB to check time it takes to complete in DB.

    Schedule the same report to default Enterprise location to check the time it take to complete scheduling.

    Schedule the same report to your email to check the time it take to complete (Scheduling +Email)

    Create publication to deliver the same report to 1 user to check time it took in (scheduling+Publication profiling+Email)

    Also can use the recommendation mention in the link:-

    Tips and Tricks for SAP BusinessObject Intelligence Platform Publication

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2016 at 12:43 PM

    Hi Surendra,

    Ideally no, but you can get some idea using below.

    1. How long it took to run the publication Perfom the steps mentioned by @Raunak that will tell if the report is lonng runninng or you need to tune in you publication group servers.

    2. Time taken to delever it to email. If there is a way to know from SMTP server only then, BO just forwards the request to SMTP server , which takes care of emailing.If you can get some logs from SMTP.

    Regards,

    RVS

    Add comment
    10|10000 characters needed characters exceeded