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.

I've found a 3-step solution

1.   Reverse = reverse([String_Column])
2.   ParseReverse = substring([Reverse], 1, position(' ', [Reverse])-1)
3.   ReverseParseReverse = reverse([ParseReverse])

It's a bit long-winded but it works.

e.g. If the text read 'AAAA 12345 BBBB CCCC' I'd like to create a column that shows 'CCCC'.