Quote from: hamlet on 06 Aug 2025 02:17:14 PMI have a simple report (in report studio), version 11.2.4. A few columns have quantity or dollar amounts (all numbers).  The user requirement is that they want to export the report in excel data format and the number columns need to be in the excel format 'Number' (not excel format 'general').  So far easy enough, but then there is a second requirement: they also want to have the number values to have no commas for the thousands separator.  I can't figure out how to satisfy both of these requirements.  In Cognos I set format to 'Number' and set thousands separator = 'No'.  But that does not transfer over to excel, it comes in as excel format 'Number' WITH the thousands separator. 

I tried to convert the number to a character string, this satisfies requirement #2 (removes comma) but does not satisfy requirement #1 (excel format = number).

Any ideas on this?

There are some limitations on what formatting options in a Cognos report Excel supports, including the decimal and group separators in numbers. In short, I don't think you can do this easily. One option might be to fire a macro after the Excel output has been generated, but this wouldn't take into account people rendering the reports interactively.

Details of the formatting restrictions are below:

https://www.ibm.com/docs/en/cognos-analytics/11.2.x?topic=format-unsupported-cognos-analytics-watson-formatting

Cheers!

MF.

I have a simple report (in report studio), version 11.2.4. A few columns have quantity or dollar amounts (all numbers).  The user requirement is that they want to export the report in excel data format and the number columns need to be in the excel format 'Number' (not excel format 'general').  So far easy enough, but then there is a second requirement: they also want to have the number values to have no commas for the thousands separator.  I can't figure out how to satisfy both of these requirements.  In Cognos I set format to 'Number' and set thousands separator = 'No'.  But that does not transfer over to excel, it comes in as excel format 'Number' WITH the thousands separator. 

I tried to convert the number to a character string, this satisfies requirement #2 (removes comma) but does not satisfy requirement #1 (excel format = number).

Any ideas on this?

Quote from: MFGF on 31 Jul 2025 11:53:39 AMIt looks like the attachment was stripped off the post - probably when the forum moved a few years ago. Let me ask Lynn if she still has it. It was posted over 10 years ago, and Lynn and I have moved continents since then, but it might still be in her document list if we're lucky.

Cheers!

MF.

Quote from: tupac_rd on 24 Jul 2025 08:50:32 PMHey guys, I know this is a very old thread, but I am not able to download the attachment. Is there a trick for that.

Ok. Lynn and I managed to find the attachment. I have just edited Lynn's original post and re-added the attachment, so it is now available to download.

Hope this helps!

MF.

Quote from: KapilKhampariya on 02 Aug 2025 07:57:20 AMSubject: Requesting Cognos 11.1.7 VM Image for Personal Learning

Message:

Hi everyone,

I'm a learner looking to build hands-on skills with IBM Cognos Analytics and Framework Manager. Since IBM no longer provides a direct trial download with Framework Manager included, I'm searching for a pre-configured VirtualBox or VMware image that has:

IBM Cognos Analytics 11.1.7 (or similar)

Framework Manager installed and working

Sample database (like GO Sales or any other)

Ideally running on Windows Server or Linux

⚠️ This would be strictly for personal and educational purposes only — not for commercial use.

If anyone has a VM or can guide me to a trusted download source (even a private link or old community share), I'd really appreciate it.

Thanks in advance!

Best regards,
Kapil

Hi,

IBM doesn't offer any free demo install options these days. They do have an on-demand cloud offering with a free 30-day trial, but this will be the latest version (12.0.4), not 11.1.7.

https://www.ibm.com/products/cognos-analytics

That's probably the best you can do.

Cheers!

MF.

What Cognos errors to alert on?

Over the weekend we had a significant outage due to an error we were not expecting/alerting on - CM-SYS-5001.
Is there a list anywhere of all the errors that admins should be alerted about?

I've asked IBM but am not hopeful tbh.

And I know it is a bit open ended but any help would be appreciated.

Subject: Requesting Cognos 11.1.7 VM Image for Personal Learning

Message:

Hi everyone,

I'm a learner looking to build hands-on skills with IBM Cognos Analytics and Framework Manager. Since IBM no longer provides a direct trial download with Framework Manager included, I'm searching for a pre-configured VirtualBox or VMware image that has:

IBM Cognos Analytics 11.1.7 (or similar)

Framework Manager installed and working

Sample database (like GO Sales or any other)

Ideally running on Windows Server or Linux

⚠️ This would be strictly for personal and educational purposes only — not for commercial use.

If anyone has a VM or can guide me to a trusted download source (even a private link or old community share), I'd really appreciate it.

Thanks in advance!

Best regards,
Kapil

Quote from: tupac_rd on 24 Jul 2025 08:50:32 PMHey guys, I know this is a very old thread, but I am not able to download the attachment. Is there a trick for that.

It looks like the attachment was stripped off the post - probably when the forum moved a few years ago. Let me ask Lynn if she still has it. It was posted over 10 years ago, and Lynn and I have moved continents since then, but it might still be in her document list if we're lucky.

Cheers!

MF.

This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38410.0

I cannot use CLUSTER nor HEAT nor HEXBIN types to cluster 25.000 points on a map of Greece.  Is there any limitation? Is there a D3 ready to download extension visualisation that we can use to have a descent clustering in maps? Or even LEaflet.JS?   The only link that I can find is reported as suspicious by hybrid-analysis.com (crowdstrike FALCON malware analysis): https://codesandbox.io/p/sandbox/ext-vis-leaflet-s06mkr?file=%2Fsrc%2FLeaflet.js%3A144%2C78.    What is the point of having Cognos if we end up in D3 or leaflet use.....  the cognos was supposed to be used by non IT users ....   Anyway Please Help!

Hey guys, I know this is a very old thread, but I am not able to download the attachment. Is there a trick for that.