Cognos Analytics

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson

Hello Snjezana. Maybe I have another / better solution for the task: We have a tool (Apparo Fast Edit) with which we can update data in relational databases from Cognos.

This can be done per event, per button or an input mask - manually or via SQL script.

Passing parameters from reports is no problem there. If you are interested please send me a PN or use our Contact Form.

------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------

Original Message:
Sent: Mon July 13, 2020 02:53 PM
From: Snjezana Skledar
Subject: Event Studio

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson

Have you looked at this document? Also there is a sample that comes with the legacy samples that you can use to get familiar with the feature. (ELM Escalation Agent)
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_es.doc/ug_cr_es.pdf

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

Original Message:
Sent: Mon July 13, 2020 02:53 PM
From: Snjezana Skledar
Subject: Event Studio

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson

Thank you for help in this matter.

We managed to call the procedure but now we are facing a different problem.


------------------------------
Snjezana Skledar
------------------------------

Original Message:
Sent: Tue July 14, 2020 09:32 AM
From: TREVOR COMEAU
Subject: Event Studio

Have you looked at this document? Also there is a sample that comes with the legacy samples that you can use to get familiar with the feature. (ELM Escalation Agent)
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_es.doc/ug_cr_es.pdf

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

Original Message:
Sent: Mon July 13, 2020 02:53 PM
From: Snjezana Skledar
Subject: Event Studio

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson

There was an issue where creating an Agent, scheduling it in the portal (allowing it to run) and then changing the Agent caused the error you mentioned on the next run.

It is resolved in CA 11.0.13 FP3.

There may be other methods to reproduce the error but I would need to have more detailed steps to provide any further information.
Cheers,
Trevor

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

Original Message:
Sent: Tue August 04, 2020 08:59 AM
From: Snjezana Skledar
Subject: Event Studio

Thank you for help in this matter.

We managed to call the procedure but now we are facing a different problem.


------------------------------
Snjezana Skledar

Original Message:
Sent: Tue July 14, 2020 09:32 AM
From: TREVOR COMEAU
Subject: Event Studio

Have you looked at this document? Also there is a sample that comes with the legacy samples that you can use to get familiar with the feature. (ELM Escalation Agent)
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_es.doc/ug_cr_es.pdf

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

Original Message:
Sent: Mon July 13, 2020 02:53 PM
From: Snjezana Skledar
Subject: Event Studio

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson

Thank you for this input, it was helpful:
- I have created a new event and it was executed succesfully (thus, advice: don't change event but create a new one from scratch).
Environment where we had problems: IBM Cognos Analytics 11.0.12 and 11.0.13.1.

I hope something like that doesn't happen in 11.1.7.

Best regards,
Snjezana

------------------------------
Snjezana Skledar
------------------------------

Original Message:
Sent: Tue August 04, 2020 09:19 AM
From: TREVOR COMEAU
Subject: Event Studio

There was an issue where creating an Agent, scheduling it in the portal (allowing it to run) and then changing the Agent caused the error you mentioned on the next run.

It is resolved in CA 11.0.13 FP3.

There may be other methods to reproduce the error but I would need to have more detailed steps to provide any further information.
Cheers,
Trevor

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

Original Message:
Sent: Tue August 04, 2020 08:59 AM
From: Snjezana Skledar
Subject: Event Studio

Thank you for help in this matter.

We managed to call the procedure but now we are facing a different problem.


------------------------------
Snjezana Skledar

Original Message:
Sent: Tue July 14, 2020 09:32 AM
From: TREVOR COMEAU
Subject: Event Studio

Have you looked at this document? Also there is a sample that comes with the legacy samples that you can use to get familiar with the feature. (ELM Escalation Agent)
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_es.doc/ug_cr_es.pdf

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

Original Message:
Sent: Mon July 13, 2020 02:53 PM
From: Snjezana Skledar
Subject: Event Studio

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson

You're welcome. This should not happen in 11.1.7.

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

Original Message:
Sent: Tue August 04, 2020 11:50 AM
From: Snjezana Skledar
Subject: Event Studio

Thank you for this input, it was helpful:
- I have created a new event and it was executed succesfully (thus, advice: don't change event but create a new one from scratch).
Environment where we had problems: IBM Cognos Analytics 11.0.12 and 11.0.13.1.

I hope something like that doesn't happen in 11.1.7.

Best regards,
Snjezana

------------------------------
Snjezana Skledar

Original Message:
Sent: Tue August 04, 2020 09:19 AM
From: TREVOR COMEAU
Subject: Event Studio

There was an issue where creating an Agent, scheduling it in the portal (allowing it to run) and then changing the Agent caused the error you mentioned on the next run.

It is resolved in CA 11.0.13 FP3.

There may be other methods to reproduce the error but I would need to have more detailed steps to provide any further information.
Cheers,
Trevor

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

Original Message:
Sent: Tue August 04, 2020 08:59 AM
From: Snjezana Skledar
Subject: Event Studio

Thank you for help in this matter.

We managed to call the procedure but now we are facing a different problem.


------------------------------
Snjezana Skledar

Original Message:
Sent: Tue July 14, 2020 09:32 AM
From: TREVOR COMEAU
Subject: Event Studio

Have you looked at this document? Also there is a sample that comes with the legacy samples that you can use to get familiar with the feature. (ELM Escalation Agent)
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_es.doc/ug_cr_es.pdf

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

Original Message:
Sent: Mon July 13, 2020 02:53 PM
From: Snjezana Skledar
Subject: Event Studio

Hi,

We have requrement to update records in DB from Cognos
(our Client is using Cognos version 11.0.13; DB is Oracle).

We have created DB procedure, FM package and event to test the behaviour.
DB Procedure has 2 input parameters.

In FM, we have created Data Modification query subject based on that DB procedure and that Query subject has 2 input parameters.
For one we have set fix input parameter value, for second one, we have entered parameter in form ?p_param?.

In Event Studio we are able to set value for that input parameter, but, when we execute that event, nothing happens, because, it seems input parameter value is empty.
More exactly, in log file, the call for that procedure is:
CALL EDW_META.PROCEDURE_TEST_COGNOS_WITH_P3 (
?,
N'COMPLETED'
)

What are we doing wrong?
Is there more comprehensive Event Studio documentation?

Thanks!

------------------------------
Snjezana
------------------------------

#CognosAnalyticswithWatson