This is almost certainly not the most efficient or elegant solution, however, I believe it works.

Add a data item expression to your query called 'Flag' with the following expression definition (adjusting for column names)
total((if([ICD Code] = 'Z94.0')
then(1)
else(0))
for [Patient Account Number])
The add a detail filter
[Flag] = 0
The Flag column computes the total number of records with an ICD Code value of 'Z94.0' for each [Patient Account Number] and the filter excludes anything over 0.

This should get you moving forward until someone more experienced chimes in.

Do you need to register to IBM just to read support docs?  I registered but still don't have access to read support docs.

https://community.ibm.com/community/user/discussion/can-you-recover-the-modelxml-file-from-the-deployment-package





All the files of a FM project (model.xml (the actual model), the CPF, etc. ) are text so they lend themselves quite well to any sort of source control.

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!