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.

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

Why wait? 1M could be yours on Reel Cash Vault. Your turn starts here! Play Now Here -> is.gd/MgWM73

loasoiwyef.space — це український підбірка, який представляє найкращі новинні портали країни. Тут ти знайдеш надійні інформаційні ресурси, де публікуються офіційні новини, аналітика та ключові події з України та світу.
 
На сайті представлені:
 
- Офіційні новинні портали з актуальною інформацією.
- Аналітика та експертні матеріали з ключових тем.
- Регіональні новини.
 
Якщо тобі важливо отримувати інформацію з надійних джерел, каталог loasoiwyef.space стане чудовим помічником!

rent a car banjaluka https://drivelity-balkans.com/car-rental-banja-luka

Reading through this material was quite helpful. You highlighted the most important aspects while keeping the narrative completely neutral, which I always value in online content.
 
casino en ligne retrait immediat

I think AI can absolutely help get you started, but I would be cautious about assuming it can replace the need for a good metadata model, trusted data, and people who understand the business.

AI can probably help generate a first draft of a report, suggest visualizations, identify relationships, maybe even write sql or explain what it sees in the data. That is valuable in speeding up the development of reports for sure.
But the bigger issue it still takes human brains and a good foundation of the data to create reports with trusted data and real numbers and too many people are missing that point. 

I have seen that: Most companies do not struggle because they cannot create more reports. They struggle because the data foundation is messy or the meaning of the data is unclear.

So I see AI as an accelerator, not a full replacement. It can help create reports faster, but trusted reporting still requires trusted data, good modeling, governance, and human judgment.

I genuinely enjoyed reading this carefully written piece. The neutral approach you took helps clarify the main points beautifully, making it very easy for the audience to digest.
 
casino en ligne retrait instantane

What makes this post stand out is the way it combines easy understanding, strong organization, and an approachable tone, which together create a reading experience that feels both useful and easy to enjoy while still leaving room for conversation and different interpretations.
 
meilleur site paris sportif hors arjel

Your future begins with today. Make it count! Start Spinning Here => is.gd/zbf5p4