Product:
Cognos Analytics 11.1.6
Microsoft Windows 2016 server

Problem:
How do I put the company name on the CA start page?

Solution:
Logon to your Cognos Analytics server and go to folder C:\Program Files\ibm\cognos\analytics\samples\themes. Unzip SampleTheme.zip in a new folder.

Open spec.json file in notepad++

Change the company name to your name and save the file.

You need to change the logo png files to your company logo with a picture software. Go to the images folder.

You must keep the size the same of the original png file.

The logo_large.png are 364 x 200 pixels.
The logo_small.png are 54 x 30 pixels.
Open your company png file in Windows Paint, and select change size. Enter the new format.

Save as large.png
Change the format again to small, and save that picture as small.png
Copy the two png files to your sample images folder.

Remove the old logo_large.png and logo_small.png files.
Rename your files to logo_large.png and logo_small.png respectively.

Rename the folder to your company name, in our example PAC.

Open spec.json again in notepad++

Change the name to your company name, in our example PAC.
Save the file.

Go to the folder above, e.g. samples.

Zip your new folder to a zip file.
Login to Cognos Analytics as a administrator.

Click on Manage and Customization.

Under Themes, click on upload team icon.
Find your new file and select it.

When it is loaded into Cognos Analytics select it and click apply.

You need to logout and in again to have the new team shown.

 

 

If you want to change more, like the background picture and text, you can do this https://quebit.com/askquebit/IBM/creating-and-setting-a-default-welcome-page-for-cognos-analytics-11-0-4/

Upload the Samples_for_Install deployment archive. (To ensure you have all demo reports)
Use Manage > Administration console to open IBM Cognos Administration.
On the Configuration tab, click Content Administration.
On the toolbar, click the New Import button.
Select Samples_for_Install in the first step of the New Import wizard and complete the remaining steps of the wizard.

Find the SampleWelcome.zip file in folder C:\Program Files\ibm\cognos\analytics\samples\extensions
Extract the zip file in a separate folder. Change the name of the folder to Welcome.

Open spec.json file in notepad++

Search and replace Sample_Welcome with Welcome.

Replace the titles to your company name.
Save the file.
Go into the image folder.

Change logo_large.png to your logo in format 374×200 pixels.
Change welcome_background.jpg to a picture of your office in size 1920×1280 pixels.
You can find free pictures at https://pixabay.com/
You can resize a picture at https://www8.lunapic.com/editor/
Go to the C:\Program Files\ibm\cognos\analytics\samples\extensions\Welcome\js\views folder and update the SampleWelcomeView HTML file with correct path.

You may remark or update the other text in HTML file for you company information.

On line 10 set <!–  …..  –> to remove the video link in the example file.

save the file.


Go up one folder, and zip the welcome folder to welcome.zip file.

Login to Cognos Analytics as administrator.
Click on Manage.
Click on Customization.
Click on Extensions.

Click the upload icon.
Find your zip file in C:\Program Files\ibm\cognos\analytics\samples\extensions folder.
Open it and see the extension load.

You need to change the home page to make it be visible.

Go to Manage-Customization-Views-home and select the new view PAC.
Click Apply.
Log out and in again.

The selection of Themes control the text in the top blue banner.
The selection of view, tell what extension will be used at the main canvas (perspective).

You can preview at http://servername.domain.com/ibmcognos/bi/?perspective=sampleWelcome

You can set that users that belong to a cognos group, will see a specific view.

Go to Manage – Accounts – Cognos – Analytics Explorers – Customization – Home page Default – PAC.
Click Apply.

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

http://queryvision.com/kb/supporting-portal-pages-portal-tabs-ibm-cognos-analytics-11-x/
https://www.ibm.com/support/pages/node/553135
https://www.ibm.com/support/pages/how-users-default-home-page-changed

https://quebit.com/askquebit/IBM/creating-and-setting-a-default-welcome-page-for-cognos-analytics-11-0-4/

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