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

Hi all,

I have a string column with varying lengths of text and varying numbers of spaces.  I'd like to isolate the text following the last space at the end of the string.  Any ideas about how I can do that?

Thanks,

Cogency

Quote from: Eric.Pleiss on 15 May 2025 09:48:14 AMThe MetaManager software allows easy access to user my folders and content, and as an admin you should be able to quickly diagnose the underlying issue, or just delete them for the users as a sys Admin. 

Thanks, Eric. We have MetaManager installed at work. I'll look into that.

Hi everyone,

I recently migrated a Cognos report from Cognos 10 to Cognos 11 and I found an issue with the way Excel handles merged cells in a list.

Each column in the list has two data items, with the second item being in a block. In Cognos 10, if Column 1 is empty, only the value of Column 2 will appear in a single cell when exporting to Excel. But in Cognos 11, even if Column 1 is empty, an extra empty cell will be created and merged with the adjacent column.5

Has anyone else encountered this issue? Do you know how to fix it so that the Excel export works as before?

Thanks in advance!