MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now Learn More
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?
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.
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
BSP Software Documentation |
MetaManager Documentation and Knowledgebase |
Version Control Documentation and Knowledgebase |
BSP Software | Resources | About Us | ||
MetaManager | BSP Software Training | BSP Software | ||
Integrated Control Suite | YouTube Channel | Micro Strategies Inc | ||
Security Migration | IBM Cognos | |||
Integrated Management Suite | ||||