Hello All, we had a few folders that didn't get transfered over to our new bi server and lost a few FM models.  Is there a way to recover framework models?  We are using Cognos 11.2.4.  We have the published package, but need to make updates to it.

Working in Cognos 11.  Please see attached screenshot for data structure.  I need to exclude each patient with an ICD Code equal to Z94.0.  If I use a filter like [ICD Code] <> 'Z94.0', it only excludes that one row for the patient with that particular ICD code, but I want to get rid of (ie; exclude) all rows for that that patient so that the entire patient record is excluded.  Any ideas?

Hi Doug,
Check the IBM Cognos Trigger Code with API KEY

It shows how to authenticate with REST API and pass the login info to SDK calls.

You can use regular expressions:

substring_regex ('\b\w+\W*$', [String_Column])

Hello!
Can you create a report with your use case against a Cognos Samples datasource and attach it here?

I have come to realize that the CDD report format is unrelated to Cognos and is the purview of a different vendor's product. Whoops. Learning is happening.

If you've stumbled onto this post looking for a solution to the same problem, I suggest searching Central Square's community for "Cognos Reporting with Docs Online". The user Michael Webb has a document revised as recently as March 2025 that looks like it might help.

Hi! I'm attempting to create a Crosstab in a form as follows.

Columns: Two measures (1 or 0 only)
Rows: 8 measures (1 or 0 only)

The Crosstab I desire is 2 columns, 8 rows, where the inner cells are the total(column * row)

Basically I want the intersection of these categories.

When I put them in a Crosstab, each row is the exact same value for the columns, the intersection isn't being measured.

Ive been able to create a query calculation for each row where it's total(row1 * col1) but I will have to do this calculation to manually create each cell, which is time consuming.

Does anyone know of a more efficient way to approach this? I'm happy to provide more information, but am unable to post real time images of the data as they are of a sensitive nature.

Thanks so much!

We're trying to schedule reports with a service account. These scheduling configurations had been setup, but were not enabled for some time. I can run the reports manually.

When I try to run the pre-configured reports through a schedule, I get the error:
CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header. CAF-WRN-2082 An error has occurred. Please contact your administrator.

I tried renewing credentials and it still throws. I also tried taking ownership of a report and remaking the schedule entirely, and the schedule doesn't even trigger, resulting in no errors at all.

We're trying to schedule reports with a service account. These scheduling configurations had been setup, but were not enabled for some time. I can run the reports manually.

When I try to run the pre-configured reports through a schedule, I get the error:
CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header. CAF-WRN-2082 An error has occurred. Please contact your administrator.

I tried renewing credentials and it still throws. I also tried taking ownership of a report and remaking the schedule entirely, and the schedule doesn't even trigger, resulting in no errors at all.

I have been tasked with converting a number of old CDD reports to Cognos Analytics (11.1.7). The process has gone well so far, except for image drill downs. I've found the data in the im_ files (im_page, im_index_data, im_info, im_index_mstr, im_index_dtl) but trying to roll my own solution from that seems kludgy and overly complicated.

How does one go about reproducing the image drill down functionality in 11.1.7?

Any help/guidance would be greatly appreciated.