List of Contributions

Todd Schuman

Contact Details

My Content

1 to 20 of 25 total
Posted By Todd Schuman Apr 9, 2021 2:08 PM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jeanie, Have you tried conditional blocks? For example, create a radio button value prompt with with 2 options (show prompts, hide prompts). Set Auto Submit to True so that it refreshes the page when you change it. Create a conditional block and use a Boolean variable to check the value of the ...
Posted By Todd Schuman Apr 7, 2021 5:11 PM
Found In Egroup: Cognos Analytics
\ view thread
I'm using Chromium Edge ------------------------------ Todd Schuman ------------------------------
Posted By Todd Schuman Apr 7, 2021 4:40 PM
Found In Egroup: Cognos Analytics
\ view thread
It should be under advanced. Do you need to scroll down more? Hard to tell from your screen shot. ------------------------------ Todd Schuman ------------------------------
Posted By Todd Schuman Apr 7, 2021 8:19 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Rajitha, I would check the priority level. See below for "Resolving conflicts when a user has multiple roles". Find out what other roles are being used and lower them. Customizing roles - IBM Documentation ------------------------------ Todd Schuman ------------------------------
Posted By Todd Schuman Mar 5, 2021 9:20 AM
Found In Egroup: Cognos Analytics
\ view thread
Senturus has built a tool called "Report Insights", which consists of a Data Extraction Utility that pulls Cognos metadata into a database and a Cognos Data Module with associated reports. End-users view Report Insights reports from within Cognos. Report Migration Tool for Cognos, Power BI, Tableau ...
Posted By Todd Schuman Jan 11, 2021 8:04 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Eli, The best "out of the box" way to do this is using the Layout Component Reference. Reuse a Layout Object (ibm.com) This will allow you to define a master template with the header and footer you desire and apply the layout to all reports. You can then make changes to the master template and all ...
Posted By Todd Schuman Dec 28, 2020 8:59 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Vivien, The DNS line in your CM Crypto->Cognos config looks odd. It seems like you have multiple entries in here. Just put only the FQDN for the specific server here (CM for CM, GW for GW). Also, try and remove the IP from both servers as well as it can sometimes cause an issue. - ...
Posted By Todd Schuman Dec 18, 2020 8:27 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Vivien, Hard to diagnose in french, but you need to make sure the FQDN is the same throughout. The Configuration Group and Cryptography->Cognos tabs in Cognos Config are the likely culprits. Check these and try it again. -Todd ------------------------------ Todd Schuman ...
Posted By Todd Schuman Dec 14, 2020 10:11 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Ignacio, The only way to do this is with a bunch of string functions. There is no time format as far as I am aware, so you need to create a date/time format. Here are the steps: Create a timestamp. Since you didn't specify the need for a date, we can grab the sysdate Extract the hour, minute, ...
Posted By Todd Schuman Nov 3, 2020 7:51 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jenifer, There is nothing special in the properties or data containers, just a list and 11.1 line chart viz. What version are you running? I am on 11.1.7 FP1. I believe you would need at least 11.1.6 to take advantage of the multiple measures on a visualization enhancement that was added. ...
Posted By Todd Schuman Nov 2, 2020 8:17 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Jenifer, What about something like this... Create two new items called MonthCreate and MonthClose and use the function extract to pull out the month number. extract(Month, [CreateMonth] or [OpenDate]). Then do a count on each to sum them up. Count(MonthCreate or MonthClose for ID). That will give ...
Posted By Todd Schuman Oct 29, 2020 8:17 AM
Found In Egroup: Cognos Analytics
\ view thread
I discussed this with someone at IBM at the last conference in Miami. My understanding was that Active Reports are basically a dead product at this time. They will continue to support and offer functionality for AR, but there will be no more development or enhancements to this tool. This was due to ...
Posted By Todd Schuman Oct 27, 2020 9:48 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Bill, I can not longer test as I don't have a Mac now, but I recall being able to do this. Another option would be to install Parallels and run a Windows VM to use IE. -Todd ------------------------------ Todd Schuman ------------------------------
Posted By Todd Schuman Oct 26, 2020 9:59 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Sakshi, Uploaded files default to your My Folder when first uploaded. Based on your folder permissions, you should be able to move/copy anywhere in Team Content you have WRITE access. Not sure what you mean by "upload" reports as there is no desktop tool in Cognos, I assume you mean Upload ...
Posted By Todd Schuman Oct 22, 2020 8:30 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi Bill, It's been a while and I no longer use a Mac, but Chrome has an extension for MHTML viewing that you can use I believe. I found another tool that can view this file type but have not tested it. EML, MHT Viewer with Drive Google remove preview ...
Posted By Todd Schuman Oct 9, 2020 9:28 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi David, In Cognos 11.1, you shouldn't be unzipping that file. There is a separate installer that you run first, and when prompted, you select the server zip file and let the installer process the zip file. ------------------------------ Todd Schuman ------------------------------
Posted By Todd Schuman Oct 1, 2020 10:01 AM
Found In Egroup: IBM Business Analytics
\ view thread
I'm looking for some guidance on patching a Windows 2008 Server running Cognos 10.1.1 to support TLS1.2. According to this KB post, it can be done: https://www.ibm.com/support/pages/cognos-bi-and-tls-12-support https://www.ibm.com/support/pages/node/586435 IF 17 was applied over the top successfully, ...
Posted By Todd Schuman Sep 29, 2020 9:18 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi David, I don't believe there is any way to do this without some back-end modeling. Since you are using dashboards you will need to get into some query manipulation using Data Modules or FM (you didn't mention what the dashboard was sourced from). The easiest way is to take an exact copy of the query ...
Posted By Todd Schuman Sep 14, 2020 7:44 AM
Found In Egroup: Cognos Analytics
\ view thread
I have installed IF2 on Windows Server and RHEL and have confirmed it fixed the Chrome bug on both. ------------------------------ Todd Schuman ------------------------------
Posted By Todd Schuman Aug 24, 2020 8:59 AM
Found In Egroup: Cognos Analytics
\ view thread
When you add a visualization check in the top right corner. There should be a drop-down for the older charts there. If you used some of the late 10.2.2 early 11 rave visualizations, you might need to have your admin download them and upload them into the library. https://www.ibm.com/support/pages/ ...