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

WEBI Report Scheduling based on event.

Hello All,

We have a requirement to schedule a webi report based on event generated by ETL loads.

Scheduling works fine based on events.My requirement is If event is not generated we want to schedule the report at specific time.Lets assume event will generate between 10 Am to 11 Am.If event is not generated report will not schedule,but we want schedule report after 11 Am.

Please let us know if any one have solution for the above

Thanks,

Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2014 at 05:19 PM

    There is no out of box solution. May be you can develop custom Java code to look for the event, and kick off the report if the event does not arrive.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2014 at 09:58 AM

    As an workaround create a script which monitors the event file from 10-11. If the event file is not generated, generate the event file from the script after 11. By this way you can handle both the scenarios.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2014 at 04:23 AM

    You can schedule your report based on the file event to look for the trigger file till 11 AM. If the file not generated, you can use the below VB Script to generate the file in the desired location by 11 AM.

    Private Sub writeDebug(ByVal x As String)
    Dim path As String = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)
    Dim FILE_NAME As String = path & "\mydebug.txt"
    MsgBox(FILE_NAME)
    If System.IO.File.Exists(FILE_NAME) = False Then
    System.IO.File.Create(FILE_NAME).Dispose()
    End If
    Dim objWriter As New System.IO.StreamWriter(FILE_NAME, True)
    objWriter.WriteLine(x)
    objWriter.Close()
    End Sub

    Script does the below operations:

    • It will verify if the file already exist for the day.
    • If it does not exist, it will overwrite the old file with the new one. If already exist, the script will end.
    • Script contains "Debug" function which will be helpful for your analysis.

    Add this program to your scheduler to run everyday at 11 AM.

    Add a comment
    10|10000 characters needed characters exceeded

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.