QuoteWe need to gather information about report runs

What information do you need to gather?

This should probably be moved to Cognos Analytics | Administration and Security

UPD
I set RSVP.PARAMETERS.LOG=true, for all services containing word "report" turned logging level to "Basic", restarted dispatchers,
But when I run IBS Cognos reports the column COGIPF_PARAMETERS.COGIPF_PARAMETER_ VALUE_BLOB is still empty...
What else can help?



Hello, everybody, I'm very in IBM COGNOS, so please, sorry for a silly question
IBM Cognos version is 11.1
We need to gather information about report runs, and when I run the report, the field COGIPF_PARAMETERS.COGIPF_PARAMETER_ VALUE_BLOB  remains empty while the other fields of this table are filled with data.
At the same time I see many other records, where the field COGIPF_PARAMETERS.COGIPF_PARAMETER_ VALUE_BLOB  contains xml with parameters and their values....
I read that it is necessary to set parameter RSVP.PARAMETERS.LOG=true
So the question is - how can I do it? I opened the Administrative console -> system -> additional parameters, but I do not see the parameter with the name "RSVP.PARAMETERS.LOG".
What button do I need to press to  add it?

Thanks in advance

Quote from: Vineet on 17 Nov 2025 08:12:40 AMHello All


Recently I am assigned to do a feasibility check of Cognos on IBM CP4D. Cognos is already installed on Cp4d and instance is working but I need to restore the Content Store from previous version.
Need help on restoring the Content Store deployment archive, I am not sure where to post the file for import job to pick it up.
Content Store is from Cognos 11.1 and we are moving to 12.0.

Thanks
VJ

Hi,

Deployment archives in the CP4D version of Cognos Analytics get stored in the Deployments folder in the Artifacts pod. You would need to get your backup zip transferred to your bastion server (usually via sftp using something like Filezilla), then use the OpenShift copy command (oc cp) to copy it to the correct folder in the Artifacts pod. Once it is there, you should be able to restore it as normal from within the Cognos Analytics UI.

Cheers!

MF.

Hello All


Recently I am assigned to do a feasibility check of Cognos on IBM CP4D. Cognos is already installed on Cp4d and instance is working but I need to restore the Content Store from previous version.
Need help on restoring the Content Store deployment archive, I am not sure where to post the file for import job to pick it up.
Content Store is from Cognos 11.1 and we are moving to 12.0.

Thanks
VJ

Quote from: icallow on 12 Nov 2025 08:59:38 AMSo I recently fell upward into an analyst position at work, and while there's a big push towards Power BI, apparently a significant chunk of our data lives on Cognos Analytics. From what I've been able to gather, someone set up some reports pre-covid and people have just been using those reports ever since. The guy who set them up left the company a while ago, and nobody knows how to do anything with this EXCEPT run those reports. I'd like to get a handle on it.

Unfortunately, I am a very small cog in a very large machine so I don't have access to stuff like setting up my own data modules (I am not trained in data science or whatever, I'm a techy guy with google), and the data I DO have feels like it's all over the place and not labeled particularly well.

Do you folks have any links that might be helpful to me as a newbie, trying to wrap my head around how this is supposed to work? Tips and/or tricks for massaging the data into legible reports? I'll take anything at this point.

If I was in your position, I would focus first on getting more familiar with the reporting side of Cognos Analytics. I fully agree that the data (or at least the view of the data presented to the author) needs to be properly structured and intuitive, but getting to grips with the modelling side is a much bigger ask, and you need to walk before you can run.

There are official courses available for reporting from a number of different providers - both instructor-led and self-paced. I would suggest you ask your company if they would book you on a course. Once you have a basic grasp of the reporting side it will help you a lot - both in being able to author new reports and also in understanding what deficiencies (if any) your current data model(s) have.

Here is a link to the Report Authoring Fundamentals course to get you started:

https://www.ibm.com/training/course/ibm-cognos-analytics-author-reports-fundamentals-v112-B6358G

Cheers!

MF.

This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38452.0

Have you tried sending an email to the non-working DL?  (outside of Cognos)  What was the result?

Neither Power BI nor Cognos Analytics contain data.  Based on your level of data and analytics experience, and your level of permissions, I'm thinking either working directly with your Cognos Analytics administrator or hiring a contractor would be your best option.

Quote from: CMWY0529 on 11 Nov 2025 12:31:33 AMThanks! I do still want to see every row. And only those with a certain date display a pass in the Yes/No column but those other records that do not have a certain date would just display blank. So instead of the current:

Record Number   Field A Yes/No
Record 1       
Record 2
Record 3        Pass
Record 3
Record 4
Record 5        Pass
Record 5

I wanted it to be:

Record Number   Field A Yes/No
Record 1       
Record 2
Record 3        Pass
Record 4
Record 5        Pass

Because in the database, record 3 have multiple entries in field A (test date), like 01-Jan-2025, 02-Jan-2025, 03-Jan-2025, etc, indicating this person has done multiple tests on different dates. My current function is:

CASE WHEN (Field A (test date) = '02-Jan-2025')
THEN 'Pass'
END

And I think the reason why record 3 has two rows in the current output, is because for the 02-Jan-2025 entry in record 3 in DB, the case when function outputs a "Pass". However because record 3 also has 01-Jan-2025 and 03-Jan-2025, this is the "ELSE NULL" default statement part of Case When function that outputs an extra row of blank. So I would want record 3 to only have one row, which is Pass. Basically as long as it has that date 02-Jan-2025 I want the function to stop looking for other entries within the record. Does that help clarify?

Thank you!

Thanks - that makes sense. Doug's suggestion of using aggregation and choosing the MAX value of 'Field A Yes/No' for each Record is probably the way to go here.

Cheers!

MF.

So I recently fell upward into an analyst position at work, and while there's a big push towards Power BI, apparently a significant chunk of our data lives on Cognos Analytics. From what I've been able to gather, someone set up some reports pre-covid and people have just been using those reports ever since. The guy who set them up left the company a while ago, and nobody knows how to do anything with this EXCEPT run those reports. I'd like to get a handle on it.

Unfortunately, I am a very small cog in a very large machine so I don't have access to stuff like setting up my own data modules (I am not trained in data science or whatever, I'm a techy guy with google), and the data I DO have feels like it's all over the place and not labeled particularly well.

Do you folks have any links that might be helpful to me as a newbie, trying to wrap my head around how this is supposed to work? Tips and/or tricks for massaging the data into legible reports? I'll take anything at this point.