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!

Michael,
You noted "users" above, rather than just a single user, so it seems unlikely that there is a specific corrupted object. 

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

You can download and trial MM for free, and during the trial period you could quickly handle this task.  https://www.bspsoftware.com/products/metamanager/#mm-download

I shot you an email with some more details.

This topic has been moved to Reporting.

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