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

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

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.

Update: the IBM support confirms that publishing to channels works and to personal chat does not work

Friends, We are on 11.1.x and use PowerPlay Studio Explorer for our cubes. We are having browser compatibility issue when viewing the cube views. Newer versions of FireFox do not render the nested crosstab format correctly. Please see the attached screen shot and help with any solution recommendation you may have for the browser compatibility with  PowerPlay Studio Explorer.

Thanks,

Vivek


 

Just for my basic understanding, is someone using the MS teams integration (Embedding a report in Microsoft Teams) and can publish to channels and personal chat?

Yeah, it's the 11.0 viz that's the problem then.

In case you have any influence, 11.2.4 and 12.0.4 are LTS releases.  It looks like 11.2.4 general support ends in 3 days (https://www.ibm.com/support/pages/lifecycle/search?q=cognos%20analytics).  Extended support is available.  There is not yet a LTS release for 12.1.x.  If release cycle is typical, that should be available in October.  In my experience, using a release before LTS is somewhat risky.  LTS tends to have fewer problems* and remains stable and receives patches over the 2-4 years after release.  So, if they are moving to 12.something soon, hopefully it's 12.0.4.

* ...but 11.1.7 (LTS) was broken when released.  I had to wait for IF 1021, then FP2 (or FP3?) to get a product I could use.

I don't know what this is but I'm gonna look because it sounds interesting - "Did you drag your labels column to the "colors" box on the viz?"

As for "And why 11.2.3?  I think 11.2.4 is the LTS release." - we have a long history of running behind on Cognos upgrades but I've heard word that we might be moving to 12.something later this year.  Unfortunately, I don't control the environment - I'm just a user. :(

The issue really is "the specific color". :( :(

Thanks Statesman!

If anybody is using Cognos packages for Deltek Costpoint then you know how difficult it is to make reports using those packages and how much performance issues are caused by it.

I recently made self-service BI packages for it which allows you to make more than 80% of reports simply by drag and drop things in one single query no matter how many tables are involved. I made it for GL, AP, AR, Sales, Purchasing, Project Reporting, Time & Expense.

Please feel free to contact me if anyone needs any help. I also remade reports which were taking days to run and now the new reports run in seconds!