Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Trigger to update a data set

    Posted Mon December 12, 2022 06:41 PM
    We have a data set that is built out of a PA cube.  We would like to refresh the data set every time the cube is updated. Has anybody done this before? Any tips?

    ------------------------------
    Rochelyn Sy
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Trigger to update a data set

    Posted Tue December 13, 2022 03:50 AM
    Hi Rochelyn,

    I assume your question is on the trigger side.

    With Cognos Analytics, there is a trigger folder located in
    <cognos_analytics_directory>\webapps\utilities\trigger
    This is a CLI utility.
    You can fire a trigger with the following URL:
    trigger "http://<cognos_server>:<port>/p2pd/servlet/dispatch" <userName> <password> <nameSpaceID> <triggerList>

    If you want to fire a single trigger, triggerList would be YourTriggerName, for instance.
    If you want to fire multiple triggers, triggerList would be (with the double quote): "YourFirstTrigger,YourSecondTrigger".

    You need to create a schedule based on a trigger for your data set.

    Best regard,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 3.  RE: Trigger to update a data set

    Posted Wed December 14, 2022 02:15 AM
    Thank you, Patrick.  Will take a look.

    ------------------------------
    Rochelyn Sy
    ------------------------------

    Original Message


  • 4.  RE: Trigger to update a data set

    Posted Wed December 14, 2022 09:57 AM
    Hi Rochelyn

    I would like to add to Patrick's suggestion, which is a valid suggestion.

    If you don't have an external method of judging when the data is updated, so that the trigger can be executed, you can use Event Studio along with a Job. Event Studio will allow you to check a database condition on a schedule (like every 5 min between 3:00-4:00). This can fire off the Job that updates the data. 

    I don't know what your condition would be but I suspect something like (Database_Table.Update_Date_Column) = (Today).

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

    Original Message


Related Content