Cognos Analytics

 View Only
Expand all | Collapse all

Datasets - Event Studio

  • 1.  Datasets - Event Studio

    Posted Thu July 18, 2019 09:12 AM
    ​Hello,

    I'm running Cognos 11.0.11 and I'm wondering if there is a way to have a scheduled even in Event Studio that runs Datasets?  I'm not to familiar with Even Studio but didn't see anything.

    Thanks-Jen

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

    #CognosAnalyticswithWatson


  • 2.  RE: Datasets - Event Studio

    Posted Thu July 18, 2019 10:29 AM
    @Jenifer Broughton Are you able to provide more details on why you want to schedule via Event Studio? Are you trying to refresh the data set after a DB load? ​

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



  • 3.  RE: Datasets - Event Studio

    Posted Thu July 18, 2019 12:10 PM
    Hi Denny.

    Yes, I have approx. 15 datasets (more to come) and this morning they failed due to DB issues.  Is there a way to run these via a job in event studio where, if they fail, an email will automatically send to people to set up to get?​

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



  • 4.  RE: Datasets - Event Studio

    Posted Fri July 19, 2019 09:00 AM
      |   view attached

    @Jenifer Broughton Thanks for providing the details. To accomplish this, you would need to use Event Studio and the Cognos Audit Package ​. As the audit DB will capture failures related to data sets.

    The event condition would look something like:

    [Target type] = 'DataSet BatchReportService' and [Status] = 'Failure' and cast([Time stamp],date) = current_date

    Also, attached a screenshot for reference.



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



  • 5.  RE: Datasets - Event Studio

    Posted Fri July 26, 2019 08:39 AM
    Hi Denny,

    Thanks for your insight on this.  Do I have to have special permissions to access the Audit Package?  I haven't worked with Auditing since version 7 and I think we had a 3rd party tool (genware maybe).   My skills related to the Audit Tables are rusty.​

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



  • 6.  RE: Datasets - Event Studio

    Posted Fri July 26, 2019 08:53 AM

    @Jenifer Broughton - The Audit Package is provided by default with Cognos Analytics. No special permissions as it's just like any other Framework Manager Package. ​

    If you're not able to locate the Audit Package, you may need to speak to your Administrator to have them import the Audit deployment, which contains the Audit package and a set of reports, into your environment.



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



  • 7.  RE: Datasets - Event Studio

    Posted Fri July 26, 2019 02:46 PM
    So, if we have Cognos Analytics 11.0.1 we should have also included audit logs that feed an audit package.  This is not an added cost?

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



  • 8.  RE: Datasets - Event Studio

    Posted Thu August 01, 2019 01:08 PM

    @Jenifer Broughton The audit deployment, which contains the Audit Package and reports, will be located in <Your_Cognos_Install_Directory>\​samples\Audit_samples

    However, if you do not have an audit database configured in Cognos Configuration to capture audit information, this technique will not work until you setup the audit db.



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



  • 9.  RE: Datasets - Event Studio

    Posted Fri August 02, 2019 08:26 AM
    Hi Denny,

    I know have access to the Audit Package.  However, ​is there a certain 'level' of auditing that needs set to use this statement you provided:

    [Target type] = 'DataSet BatchReportService' and [Status] = 'Failure' and cast([Time stamp],date) = current_date

    Thank you!!!

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



  • 10.  RE: Datasets - Event Studio

    IBM Champion
    Posted Fri August 02, 2019 10:39 AM
    The default audit level (minimal, I think) should capture this info afaik. If you want more comprehensive monitoring of failures in your environment, we have a product called Thrive which will help with that.

    Otherwise what you have above should work.

    ------------------------------
    Ryan Dolley
    2019 IBM Champion
    www.ibmblueview.com
    ------------------------------



  • 11.  RE: Datasets - Event Studio

    Posted Fri August 02, 2019 11:37 AM
    Hi Ryan,

    I've created the event ([Target type] = 'DataSet BatchReportService' and [Status] = 'Failure' and cast([Time stamp],date) = current_date)  with a task to send an email if there is a 'Failure'.  I then set up a dataset that fails when it runs (due to cross joins).  I scheduled this dataset and then the Event afterwards.  It does not sent an email out.  When I check the Event 'versions' for the runtime it says 'CNC-ASV-0050 Event condition not met'.   This event doesn't recognize the dataset failed.  Any ideas?

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



  • 12.  RE: Datasets - Event Studio

    Posted Fri August 02, 2019 12:58 PM
    Edited by System Fri January 20, 2023 04:44 PM
    ​I see the issue one issye.  'Failure' needs to be in uppercase.  All is working now.  THANKS!!!

    Next question is can I use Event Studio to run datasets?  You can't create a 'job' to run datasets.  It would be nice to have an 1 event where I can run all my datasets.  This would come in handy when the runs fail, currently I have to run each manually.

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



  • 13.  RE: Datasets - Event Studio

    Posted Wed August 14, 2019 12:37 PM
    I agree.  Would be great to be able to refresh data sets from an Event agent.

    ------------------------------
    Jeffrey Qureshy
    ------------------------------



  • 14.  RE: Datasets - Event Studio

    Posted Wed August 14, 2019 01:20 PM
    Edited by System Fri January 20, 2023 04:38 PM
    ​Hi Jeffery,

    I was told in version 11.1.3 it's possible to add datasets to a JOB hence then to an Event!

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



  • 15.  RE: Datasets - Event Studio

    Posted Wed August 14, 2019 05:36 PM
    I was able to add Datasets to a Job in 11.1.3 but not 11.0.13.

    ------------------------------
    TREVOR COMEAU
    ------------------------------