If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Recent posts

#21
Framework Manager / Recover Framework Model
Last post by jburchill - 28 May 2025 04:10:20 PM
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.
#22
Reporting / Programming question
Last post by Developer1 - 28 May 2025 11:15:20 AM
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?

#23
SDK / Re: Using SSO with the SDK
Last post by Andrei I - 26 May 2025 09:34:39 AM
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.

#24
Reporting / Re: Parse string at last delim...
Last post by Andrei I - 25 May 2025 09:47:25 AM
You can use regular expressions:

substring_regex ('\b\w+\W*$', [String_Column])
#25
Reporting / Re: Two Flags Intersection in ...
Last post by Andrei I - 25 May 2025 09:26:38 AM
Hello!
Can you create a report with your use case against a Cognos Samples datasource and attach it here?
#26
Reporting / Re: Converting CDD Reports to ...
Last post by sjohnson - 23 May 2025 02:18:03 PM
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.
#27
Reporting / Two Flags Intersection in Cros...
Last post by MaxTheDuck - 22 May 2025 01:16:03 PM
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!
#28
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.
#29
Cognos Administration / CM-REQ-4159 | CAM-4005 | CAF-W...
Last post by CognosUser101 - 22 May 2025 10:36:16 AM
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.
#30
Reporting / Converting CDD Reports to Cogn...
Last post by sjohnson - 21 May 2025 10:16:36 AM
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.