Good Morning Cognos Experts,

I'm using Cognos 11.2.3 to Join two queries together using the only data item that the queries have in common. 

However, though these character data items are known to contain the exact same values, they are in fact from two different tables.

The queries run successfully alone.  But when I attempt to run the JOIN query which is using only "=" comparison of one data item from each query result set, I get this error message:

"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.

I do not have access to Framework Manager to change the source database.  So, I'm looking for ideas of how I might be able to either manipulate the data items prior to the JOIN OR use an expression to populate their values into separate new data items (within their respective queries) which I could then JOIN instead.

Thank You.

Quote from: jburchill on 29 May 2025 08:09:39 AMDo you need to register to IBM just to read support docs?  I registered but still don't have access to read support docs.

Hi,

You will need to register for an IBM ID using your email address. Once you have that, you should be able to view support documentation. Have you tried the direct link to the support article:

https://www.ibm.com/support/pages/how-recover-parts-corrupted-or-lost-framework-manager-model

Cheers!

MF.

Quote from: carioca10 on 03 Jun 2025 05:32:50 PMNeed to group similar items in a column of a second column in a single line  in a report.

As follows:

Input

Field A   Field B
-----------   -----------
A1             B1
A1            B2
A2            B3
A3            B4
A3      B5

It would become:

Output   
Field A      Field B
------------      -----------
A1         B1, B2
A2         B3
A3         B4, B5

Cognos Version 12.0.4

Hi,

I'm assuming this is a list report? You could drop a repeater into the second column of the list, and set up a master/detail link between the query of the list and the query of the repeater (based on Column A). Add Column B into the repeater (plus comma/space etc as needed).

Cheers!

MF.

Need to group similar items in a column of a second column in a single line  in a report.

As follows:

Input

Field A   Field B
-----------   -----------
A1             B1
A1            B2
A2            B3
A3            B4
A3      B5

It would become:

Output   
Field A      Field B
------------      -----------
A1         B1, B2
A2         B3
A3         B4, B5

Cognos Version 12.0.4

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.