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

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
------------------------------

Thank you, Patrick.  Will take a look.

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

Original Message:
Sent: Tue December 13, 2022 03:49 AM
From: Patrick Neveu
Subject: Trigger to update a data set

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
------------------------------

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
------------------------------