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

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.x
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

Product:
Cognos Analytics 11.1.5 Jupyter notebook
Linux Red Hat Server 7.7

Problem:
During setup of SSL(TLS) support on the jupyter notebook, we can not run the build script.

Error message:
chmod: cannot access ‘/srv/proxy.key’: No such file or directory

Solution:
On the linux jupyter server. Connect to it with PUTTY or WinSCP.
Open the Dockerfile_hub file (it is in the folder where you unpacked the jupyter files e.g. /ibm/jupyter/dist/scripts)
check that after first “USER root” command there is this command line;
 COPY build-tmp/hub  /srv
if it is not, add it and remark out the same command line later in the file.

Save the file.
Then go to the /ibm/jupyter/dist/scripts/unix folder
Run ./build.sh

if there is no errors
Run ./startup.sh

Then continue with the setup of SSL for jupyter notebook.

More Information on how setup HTTPS for jupyter notebook:
https://www.ibm.com/support/pages/node/6116296
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_inst_jupyter.html

https://www.ibm.com/support/pages/jupyter-notebooks-1115-does-not-work-when-proxykey-has-insufficient-permissions

Product:
Cognos Analytics 11.1.5 framework manager
Product_version=11.1 R5
Microsoft Windows 2016 server

Problem:
When saving FM cognos configuration changes, you get a error.

Error message:
BMT-MD-0003 CST-AOM-0016 A SAX error with the message ‘Invalid document structure’ occurred while processing the request.

Solution:
Check the values Dispatcher URI for External Applications in Framework Manager configuration (<fm_home>/bin/cogconfigw.exe)
Under Environment locate setting Dispatcher URI for External Applications
check it to be in format: http://dispatcher.server.sample:9300/p2pd/servlet/dispatch

The value for http://dispatcher.server.sample:9300//p2pd/servlet/dispatch have a extra slash, change to http://dispatcher.server.sample:9300/p2pd/servlet/dispatch
and the save should work.

Product:
Cognos Analytics 11.1.5 framework manager
Product_version=11.1 R5
Microsoft Windows 2016 server
Problem:
When inside Framework Manager you select language, to create a new FM project, you get a error.
This after a install of FM to a new server, and try to connect to a BI server that was upgraded from CA 11.0.12 to CA 11.1.5 by an in-place upgrade.

Error message:
BMT-MD-0003 CCL-BIT-0005 A socket reported a communication error.
CAM_Connect=0xfffffff4 -12CAM-CRP-0026 The underlying socket: ‘xx.xx.xx.xx:9300’ returned an error.10056Could not connect the socket, errno: 0x2748(10056)

error in file cognosserver.log
[ ERROR ] CAM-CRP-1193 An error occurred while attempting to contact the active Content Manager to update the local CA information. Check your configuration to ensure that the configured URIs are valid and that there are services running at those locations. Reason: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
or in C:\Program Files\ibm\cognos\analytics\logs\p2pd_messages.log
[5/7/20 12:44:52:435 CEST] 0000029d com.ibm.ws.channel.ssl.internal.SSLHandshakeErrorTracker E CWWKO0801E: Unable to initialize SSL connection. Unauthorized access was denied or security settings have expired. Exception is javax.net.ssl.SSLHandshakeException: no cipher suites in common

Solution:
Go into the Cognos Configuration on the CA11 server and in the Framework Manager Configuration on the client computer.
Compare the listed of supported ciphersuites.

If the FM configuration is missing the setup on the CA11 server, add the missing chiper sets.
Save and try again.
In most cases you must have the same list on both FM configuration and the CA11 server cognos configuration.
Change the FM configuration to be exact as the CA11 server.
Save and try again.

Above the default setting for FM 11.1.5 version.

Above the default setting for CA 11.0.13 FP1.

More information:

https://www.ibm.com/support/pages/support-256-bit-cipher-suites-cognos-configuration