Product:
Cognos Analytics 11.1.6
Microsoft Windows 2016

Problem:
How do i install CA 11 on Windows 2016?

Check here how to install CA11.1.x https://www.ibm.com/support/pages/how-install-cognos-analytics-111x

Here are the new features of 11.1.6 http://ibmblueview.com/cognos-analytics-11-1-6-whats-new/

Suggested Solution:
Download the software from IBM; ttps://www.ibm.com/support/pages/downloading-ibm-cognos-analytics-11160
Download from Passport Advantage.

Part	Image	Category
IBM Cognos Analytics Server 11.1.6 Microsoft Windows Multilingual	CC5HYML	Required
IBM Cognos Analytics Installer 2.0.200319 Microsoft Windows Multilingual	CC5I5ML	Required
IBM Cognos Analytics Client 11.1.6 Multiplatform Multilingual	CC5I4ML	Recommended
IBM Cognos Analytics for Jupyter Notebook 11.1.6 Linux x86-64 Multilingual	CC5IHML	Required
IBM Cognos Analytics for Jupyter Notebook 11.1.6 Microsoft Windows Multilingual	CC5IIML	Recommended
IBM Cognos for Microsoft Office 11.0 Microsoft Windows 32-bit Multilingual	CNPX0ML	Recommended
IBM Cognos for Microsoft Office 11.0 Microsoft Windows 64-bit Multilingual	CNPX1ML	Recommended
IBM Planning Analytics for Microsoft Excel 32-bit 2.0.47 Microsoft Windows Multilingual	CC469ML	Recommended
IBM Planning Analytics for Microsoft Excel 64-bit 2.0.47 Microsoft Windows Multilingual	CC46AML	Recommended
IBM Cognos Transformer 11.0.0.68 Microsoft Windows Multilingual	CC3L6ML	Recommended

Update the Microsoft Windows 2016 server to latest fix packs.

Download the latest fix pack for Cognos Analytics. You must install the fix pack.
https://www.ibm.com/support/pages/node/6207165

Set IE Enhanced Security Configuration to off, in Server Manager – Local server.

Set Data Execution Prevention (DEP) off (Turn on DEP for essential Windows programs and services only) and set Power Options to High Performance in Control panel.

For many cognos program, it may be needed to also install this on the server;

Install Microsoft Visual C++ 2010 SP1 Redistribution Package http://www.microsoft.com/en-gb/download/details.aspx?id=13523 https://download.microsoft.com/download/1/6/5/165255E7-1014-4D0A-B094-B6A430A6BFFC/vcredist_x64.exe

Install SQL 2012 native client https://download.microsoft.com/download/B/E/D/BED73AAC-3C8A-43F5-AF4F-EB4FEA6C8F3A/ENU/x64/sqlncli.msi

Install NET Framework 4.7.2 https://support.microsoft.com/sv-se/help/4054530/microsoft-net-framework-4-7-2-offline-installer-for-windows

Install IIS by in Server Manager go to Roles and Features and click on Add Roles and Features.

Select Web Server (IIS) and click OK

Select HTTP Activation and click Add Features.

Select HTTP Redirection and WebDav Publishing.

Select Windows Authentication and IIS Management Scripts and Tools.

Select WebSocket Protocol.

Copy the Cognos files to a file share that you can access from the windows server.

Start the installation by running the ca_instl_win_2.0.2003191.exe file.

Press next on most dialogs, on the dialog to choose a file click choose.

Select the casrv-11.1.6-2005071525-winx64h.zip file and click open and next.

Select IBM Cognos Analytics and click next.

Select “Make shortcut visible to all users in the start menu” and click next.

Select Custom and click next.

Select all and click next and click install.

The driver JAR file sqljdbc42.jar is the file you need for IBM® Cognos® Analytics. Download sqljdbc42.jar from https://download.microsoft.com/download/F/0/F/F0FF3F95-D42A-46AF-B0F9-8887987A2C4B/sqljdbc_4.2.8112.200_enu.exe

Copy file sqljdbc42.jar into folder c:\program files\ibm\cognos\analytics\drivers

Start Cognos Configuration as administrator, most localhost values should already be replaced with windows full servername. Ensure that all servernames are in lowercase minuscule.

Enter IP address to servers in configuration group if your servers have more than one network card.

Suggest you limit access to cognos analytics to people that are part of any of the cognos security groups. Inactivity timeout in seconds can be set to a higher value, like 28800, for cognos controller installations.

Create a namespace for you Active Directory connection.

If you want to setup LDAP follow this guides https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_ldapauthentication_process-element.html

Set the Namespace ID to the same as the namespace, and add the host and port to you DC.

 

Set Allow anonymous access to False.

Add the domain and any other cognos server names to the allowed CAF list.

Delete the DB2 content store and create a new Content Store for SQL server.

Enter the sql server name and port number and the other values.

If you use a lot of scheduled reports, you may benefit to have a separate notification database.

Setup mail connection http://cognospaul.com/2016/08/17/gmail-smtp/

Save and start the cognos service.

Test to login by surf to your server at http://caservername.domain.com:9300/bi/v1/disp

https://www.aramar.co.uk/blog/2020-april/cognos-analytics-11-1-6-packed-full-of-new-featu

On your IIS web windows server download and install the Application Request Routing.

https://www.iis.net/downloads/microsoft/application-request-routing

Install rewrite_amd64_en-US.msi and requestRouter_amd64.msi

Manual setup of IIS here https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

Get the script to run for IIS from folder C:\Program Files\ibm\cognos\analytics\cgi-bin\templates\IIS

open the CA_IIS_Config.bat file in notepad++

Enter you Cognos Analytics server and your jupyter notebook servername and port. Set True to use SSO. Save the file and run CA_IIS_Config.bat from a elevated command prompt.

Press Y

Test to surf to http://servername.domain.com/ibmcognos

To create a easy SSO, add this parameters to Cognos Configuration, under Security – Authentication – AD – Namespace – Resource Properties – Advanced properties:
singleSignOnOption  =   IdentityMapping

Save and Restart the cognos service.  (Your CA IIS script need to enabled SSO first).

Open firewall ports 80 and 443 for clients, and ports 9300, 9362, 4300, 5701, 9301 for additional Cognos servers.

Setup webdav in IIS;
https://www-01.ibm.com/support/docview.wss?uid=swg22002398&aid=1

To stop old dump files, open the cclWinSEHConfig.xml file from the C:\Program Files\ibm\cognos\analytics\configuration folder. Set “CCL_HWE_ABORT” value=”0″

Import Audit report samples, and create a Audit database.
https://www.ibm.com/support/pages/how-configure-audit-reporting-cognos-analytics 
Set logging to Basic.

How setup jupyter notebook:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_inst_jupyter.html

How setup SSL for Cognos:
https://www.ibm.com/support/pages/how-add-3rd-party-ca-allow-ssl-between-components-ibm-cognos-analytics-11

https://www.ibm.com/support/pages/configuring-ibm-cognos-analyticsbi-https-enabled-web-server

More Information:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_configuringcognos8.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_openid_namespace.html

Product:
Cognos Analytics 11.1.6
Product_version=11.1 R6
CAMAAA_ACM_version=11.1.6-25
Microsoft Windows 2016 Server

Problem:

When browse to IBMCOGNOS and login with SSO, you get a error;
Microsoft Visual C++
Runtime Library: Runtime Error! Program
c:\windows\system32\intersrv\w3wp.exe R6025 – pure virtual
function call

Cognos Installed from ca_srv_win64_11.1.6.zip file.

If you browse to http://servername:9300/bi/v1/disp, then the login works fine.

Solution:
Download a later version of CA11 from Fix Central
https://www.ibm.com/support/pages/node/6207165

interim fix: 11.1.6-BA-CA-Win64-IF001
Cognos Analytics 11.1.6 Interim Fix 1
The following files implement this fix.
casrv-11.1.6-2005071525-winx64h.zip (5.01 GB)

To upgrade;

Stop the Cognos service and put it to manual.
Export the cognos configuration as a backup.
Reboot your windows server, to ensure all cognos java process have stopped.
Start the installation again with ca_instl_win_2.0.2003191.exe and select the file casrv-11.1.6-2005071525-winx64h.zip.
Install on top of previous installation.

Open Cognos Configuration, save the configuration and start the services.

Test to surf to http://servername.domain.com/ibmcognos

More Information:
https://www.ibm.com/support/knowledgecenter/SSEP7J
https://www.ibm.com/support/pages/how-apply-interim-fix-cognos-111x-using-silent-install-method

Product:
Cognos Analytics 11.0.12
kit_version=11.0.12.18062512
kit_name=IBM Cognos Analytics
Microsoft Windows 2016 Server

Problem:
User can not login to Cognos.
Cognos service does not start.
https://www.ibm.com/support/pages/how-regenerate-cryptographic-keys-cognos-analytics-11

If you check, the CA certificate have expired.

You can check it by go to folder C:\Program Files\ibm\cognos\analytics\jre\bin
Start program ikeyman.exe
Click on open icon and go to folder C:\Program Files\ibm\cognos\analytics\configuration\certs
Open the file CAMKeystore

Enter the password (default: NoPassWordSet)
Double click on the personal certificate named encryption

There you see when the certificate is created and when it stop working, 2 years later.

Solution:
Start Cognos Configuration (on your Cognos Content Manager server) as an administrator.
First try by click SAVE icon, and then RESTART icon inside Cognos Configuration. If that does not help then do the other steps from Cognos Configuration program.
Stop the Cognos Service.

Export the Cognos Configuration to a text file. Select File – Export as.

Click Yes to export the content.
Name the file “backup.xml” and save it in the configuration folder.
Close Cognos Configuration program.
Move this files to a backup folder (c:\temp\backup)

C:\Program Files\ibm\cognos\analytics\configuration\cogstartup.xml
C:\Program Files\ibm\cognos\analytics\configuration\caSerial
C:\Program Files\ibm\cognos\analytics\configuration\certs\CAMCrypto.status
C:\Program Files\ibm\cognos\analytics\configuration\certs\CAMKeystore
C:\Program Files\ibm\cognos\analytics\configuration\certs\CAMKeystore.lock
C:\Program Files\ibm\cognos\analytics\temp\cam\freshness

Move this folder to a backup folder (c:\temp\backup\csk)
C:\Program Files\ibm\cognos\analytics\configuration\csk

In the c11\configuration folder, rename ‘backup.xml’ file to ‘cogstartup.xml’.
Open Cognos Configuration, save the configuration and start the services.

Repeat steps on all computers that have Cognos Analytics Server components installed.

Check the result by go to folder C:\Program Files\ibm\cognos\analytics\jre\bin
Start program ikeyman.exe
Click on open icon and go to folder C:\Program Files\ibm\cognos\analytics\configuration\certs
Open the file CAMKeystore
Enter the password (default: NoPassWordSet)
Double click on the personal certificate named encryption

Now is the Cognos self-signed certificate valid another two years.

More Information:
https://www.ibm.com/support/pages/how-regenerate-cryptographic-keys-cognos-analytics-11
https://www.ibm.com/support/pages/how-regenerate-cryptographic-keys-cognos-bi-1021-and-earlier
https://www.ibm.com/support/pages/node/523783

https://www.ibm.com/support/pages/how-add-3rd-party-ca-allow-ssl-between-components-ibm-cognos-analytics-11
https://www.ibm.com/support/pages/configuring-ibm-cognos-analyticsbi-https-enabled-web-server

Product:
Cognos Analytics 11.0.13
Microsoft Windows 2012

Problem:
How start cognos configuration when the icon is missing?

Solution:
Create a shortcut to this file
“d:\Program Files\ibm\cognos\analytics\bin64\cogconfigw.exe”
run the shortcut to start CA11 cognos configuration program.

More information:

https://www.itninja.com/question/find-ibm-cognos-installs

Product:
Cognos Analytics 11.1.x
Microsoft Windows 2019 Server

Problem:
How add links to webpage with instructions for the users?

Linking a website URL to my Cognos Analytics 11.0.4+ Welcome Page

Solution:
You can add a extra menu with links to your (HTML, PDF) pages.

On the CA11 server go to the folder C:\Program Files\ibm\cognos\analytics\samples\extensions

Create a new empty folder, called c:\extra.

 

Copy the SampleExtensionMenuUrlLinks.zip file to the c:\extra folder.

Unzip the file SampleExtensionMenuUrlLinks.zip.

Go into the new folder SampleExtensionMenuUrlLinks and open the file spec.json in notepad++

In this example there are two menu items you can edit to use for your needs.
Edit the “label”: “IBM website”, and “options”: {“url”: “http://www.ibm.com”} lines.

You need to have a document to share with the users, we copy a pdf file to a new folder c:\doc

on a server where you have IIS installed, so you can in inside IIS manager share this files.

Start IIS manager and go to your default site.

Mark the Default Web Site and right click and select Add Virtual Directory

Enter a alias as Doc and change the physical path to your folder c:\doc. Click OK when done.
Now you can place any files in this folder (like HTML or PDF) that you later can share in Cognos portal by updating the json file.

In our example we change the second label to Instructions and the second options to “http://windatacenter/doc/Instructions_cognos.pdf” – you need to change that line to use your windows server name (not my windatacenter) and the pdf file name to your pdf file name. Do not use a space in the file name. Save the spec.json file.

Go up to extra folder, and use 7zip to create a zip file again.

All files in the folder should be compressed to a zip file. You can give the zip file a new name if you like.

Now you need to update CA11 with this extension that will change the looks of Cognos Connection.

Login as administrator, click on manage and customization.

Click on tab Extensions, and click on the upload icon.

Select your newly created zip file and click open.

The extension is loaded into the Cognos store. You need to logout and in again to see the effect.

You get a new LINKS menu with two options, we have only changed the second one to Instructions. If you click on that the PDF should open.

You may get above message in Internet Explorer and need to click Open to open the pdf in a reader.

If you have issues, please try with chrome first – go to you Cognos Analytics web site.

Click on links.

Click on Instructions.

The pdf should open in chrome browser.
Any files placed in your c:\doc folder is accessible for any user that can browse to your IIS server.
You provide the direct links in Cognos to make it easier for the users to find a specific file.

More Information:

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ag_manage.doc/t_ag_manage_cust_home.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_mng_cust_cr_home.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ag_cust_extensions.html#cust_sample_extensions

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_mng_cust_manage.html

You can in Microsoft Word export a word doc to a HTML file, select export from file menu, and select change file type to “Single File Web Page” and click save as.

Select a easy name and select html or mhtml.

Copy the file to your web server (IIS) and then update the first link in the json file.

So it should be like this “options”: {“url”: “http://windatacenter/doc/cognos.mht”}

instead of “options”: {“url”: “http://www.ibm.com”}

Save the file, and do the zip and upload steps again. Logout and in to CA11 again, to see the new link.

Product:
Cognos Analytics 11.1.4
Microsoft Windows server 2019

Problem:
How alert Cognos users about a important change?

Solution:
Add a banner that show when the user login to Cognos Connection portal.

Log in to Cognos Analytics as a administrator and click on Manage.

Click on Configuration.

Click on System.

Scroll down to Advance Settings, and fill in values for Custom settings.
Add Key: Glass.enableBanner and as Value, true. Click Apply button.

Repeat for your message text.
Add Key: Glass.bannerMessage and as Value, Your Message!!. Click Apply button.

Log out and in to Cognos Analytics to see the result.

You can click the X on the right to remove the message for this session.

You can set Glass.disableAlertBanner = true to disable the entire banner, or Glass.disableWhatsNewAlerts = true to disable only the Whats New messages in the banner.

More information:
https://www.atlanticcognosanalytics.com/post/what-s-new-in-cognos-11-1-4-new-welcome-screen
https://www.ibm.com/support/pages/apar/PH18436

Creating and Setting a Default Welcome Page for Cognos Analytics 11.0.4+

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ag_cust_extensions.html#cust_sample_extensions

https://www.ibm.com/support/pages/customizing-alerts-banner

11.1.4:
Navigate to Manage > Configuration > System, and select Advanced Settings.
Key = Glass.bannerMessage Value = <your message> will add the additional message to the alert banner.

11.1.5:
Navigate to Manage > Configuration > System, and select Advanced Settings.
Key = Glass.maintenanceMessage Value = <your message> adds an additional message to the alert banner.