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

#1
General Discussion & Gossip / LhaneORASE
Last post by ShaneORASE - Today at 02:38:54 AM
I appreciate how this post stays thoughtful and insightful while still feeling approachable and easygoing, because that combination usually makes discussions more engaging and encourages people to interact in a positive way.
 
在线购买无处方安定片 xxx Pornhub
#2
General Discussion & Gossip / Lewiskep
Last post by ShaneORASE - Yesterday at 11:38:17 PM
I enjoy how this post explains the topic in a clear and organized way while still keeping the discussion engaging overall.
 
adult xxx video porn site xxx sex video
#3
Upgrading to Cognos Analytics / Dichaelfal
Last post by Timsothymug - Yesterday at 08:39:09 PM
The overall feeling and structure of this post make it very easy to read and follow, while also keeping the discussion open enough for different viewpoints, which is something that always helps create more thoughtful and engaging conversations online.
 
cialis pills sexual xxx porn pills
#4
Warm greetings! Hope you're doing well.
 
Good day, I have a general inquiry about your business solutions Please get back to me at your earliest convenience using the contact details I have provided below Thank you. my whatsapp +971586234140
#5
Reporting / Re: Need help narrowing down t...
Last post by FerdH4 - 17 Jun 2026 06:37:37 AM
These AI inspired instructions worked for me which included creating a new data item which I had not tried in my earlier attempts to use the Minimum expression.

1. Open your report in Edit mode and go to Queries.
2. Create a New Data Item in your query and name it something like Unique_Record.
3. Set your expression using the following syntax:minimum([Column_to_Check] for [Grouping_Key_1], [Grouping_Key_2])(Replace Column_to_Check with the item you want to extract, and Grouping_Key with the core columns that define the unique entity).
#6
Reporting / Re: Need help narrowing down t...
Last post by FerdH4 - 15 Jun 2026 07:41:30 AM
Understood - as that is of course the appropriate (possibly only) long-term solution bus_pass_man.
#7
Reporting / Re: Need help narrowing down t...
Last post by bus_pass_man - 14 Jun 2026 01:35:01 PM
I think the problem should be defined as someone messed up and corrupted the table (and possibly others too) and the incorrect data needs to be removed rather than how do I work around the corruption.  As such, there needs to be at least one meeting, probably more, involving a manager, almost certainly many sunrays up the chain, so that people in authority know about the problem.   
#8
Reporting / Need help narrowing down to un...
Last post by FerdH4 - 11 Jun 2026 11:20:15 AM
Good Day Cognos Experts,

I have a table which (thank goodness) has a unique key but appears that logical duplicates are being created in that table in error by the source program.  The downstream result is in the Report output I'm getting duplicate rows in my report because of later Joins I must do using either Study ID or Exam Number.

The three most relevant fields in this table are:
1. Study ID (by design almost unique)
2. Exam Number (no design intent to be unique)
3. Event Log ID (actual internally sequentially assigned key to the table and thus always unique). 

Offending records in this table look like this:
Study ID   Exam Number       Event Log ID
3261991    00000XR260044096  608448
3261991    00000XR260044096  608449

As shown above I've got two records where 100% of the data is identical except for the Event Log ID value.  I only want my Query to output a single occurrence of what appears to be duplicate records.  If I had a choice,  I think I'd prefer to use the "first" record.   

What can I do within the confines of my Query to focus the attention on just one of these two duplicates? 

I've tried adding "Minimum" to the left of the field Expression Definition like Minimum([Event Log ID]) but that didn't make any difference.  Maybe I've used that expression wrongly.

Thanks for sharing hints with me.
#9
Report Studio / Re: Cognos 10.2 Report Studio ...
Last post by hxp417 - 10 Jun 2026 06:17:32 PM
Quote from: timness on 07 Jun 2022 07:58:43 PMIE Tab in Chrome works on Windows 10, but not Windows 11 (unless someone knows how to get the Report Studio popup to work).

I've recently got IE tab in Chrome to work for Cognos Report Studio 10.2.2, in Windows 11.

In IE Tab settings, I use "IE 11 Standards Mode", in the "Popups & Tabs" section, I checked all the boxes.

By the way, the IE Tab version: 19.3.5.1