Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/06/19 09:33 AM
    ​We currently have a trigger set up that is being used to kick off scheduled reports.

    How can I use this trigger in Event Studio?  I'd like to create a job that runs all the reports one after another if the even is successful.

    Thank you,
    Jen

    ------------------------------
    Jenifer Broughton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/06/19 10:25 AM
    @Jenifer Broughton You can schedule by trigger for Events as well. So the Event will only run when the schedule is called by the trigger. ​

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/06/19 10:36 AM
    How and where do I do this in Event Studio?  Do I have to have a url for the trigger or just the trigger name in a sql statement?​

    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 4.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/06/19 10:46 AM

    On the properties of the event you can schedule the event to be fired by trigger. If you are just looking for the event to be fired by trigger and do not care about the event condition, you can set an event condition to return true, for example 1=1.



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 5.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/06/19 02:14 PM
    Oh ok, the visuals were helpful.  I understand what you are saying now.

    Thank you!​

    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 6.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/07/19 09:08 AM

    I must be doing something wrong.  I've set up the 'test job' with 2 reports included. I ran this job separately via it's own set schedule based on our Trigger and it updates the reports as expected.​  When I create an event and use the event 1=1 then add the 'test job' as a task and 'email' as a task.  It doesn't appear to work.  

    The scheduled event appears to error with the following: 
    ;nested exception is: org.xml.sax.SAXException:  Invalid element in com.cognos.developer.schemas.bibus._3.Options - name org.xml.sax.SAXException: Invalid element in com.cognos.developer.schemas.bibus._3Option - name

    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 7.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/07/19 01:54 PM
    hrmm it might be the condition of 1=1. Could you trying using a query item from your package and create a condition that will validate to true? For example [Quantity] >0

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 8.  RE: Event Studio event based on Trigger Cognos 11.0.11

    Posted 08/08/19 06:25 AM
    Edited by System Admin 01/20/23 04:48 PM
    Hi Denny,

    Yes, that seemed to work.  ​Thank you! 

    ------------------------------
    Jenifer Broughton
    ------------------------------