Product:
Cognos Analytics 11.0.7
Microsoft Windows 2012 server

Issue:
When you surf to Cognos Connection in a new setup of CA11 you get different error messages

Surf to: https://servername.domain.com/ibmcognos
Error: This page cant be displayed
Make sure the web address is correct
Look for the page with your search engine
Refresh the page in a few minutes

Surf to: https://servername.domain.com/ibmcognos/ibmcognos/ibmcognos
Error: server error in /ibmcognos application
the length of the URL for this request exceeds the configured maxUrlLength value.

Surf to: http://servername.domain.com/ibmcognos/bi/
Error: The website declined to show this webpage
Most likely causes:
This website requires you to log in

Surf to: https://servername.domain.com/ibmcognos/bi
Error: A blank page in Internet Explorer

Solution:
Go to Internet Information Services Manager
Check if you have set a HTTP redirect on the default web site, remove and try again.
Check if you have bindings on the default web page, if HTTPS is setup to a specific server name. Try with HTTPS set to a blank host name in the IIS Site binding setting.
Check if you have marked Require SSL for the Default Web Site, in IIS.

Product:
Cognos Analytics 11.0.12 Framework Manager
Microsoft Windows 2012 server

Problem:
When connecting to the Cognos Gateway from Framework Manager, you get an error after login.

Error message:
Script Error
An error has occurred in the script on this page
Line: 43
Char: 3
Error: ‘requirejs’ is undefined
Code: 0
URL: https//caservername.domain.com/ibmcognos/bi?b_action=xts.run&m=portal/ close.xts
Do you want to continue running scripts on this page?

Possible solution:
If SSO is enabled, and the client computer is in a different domain than the server computer, you can get similar errors. Turn off SSO on the IIS server and try again.

If SSO was enabled while running the script tool to setup IIS for CA11, you can disabled it again in IIS Manager. During the execution of the tool, SSO is configured. To disabled it, perform the following:
1. Open IIS Manager.
2. Expand the web site and alias that was created.
3. Single click on the bi folder.
4. Click on URL Rewrite.
5. Find SSO Login. Single click on it and on the right hand action pane, click on disabled Rule.
6. Find Legacy SSO. Single click on it and on the right hand action pane, click on disabled Rule.

Can also be that you have enter the wrong URI for the gateway inside Cognos Configuration for Framework Manager.
Update Gateway URI to be https://caservername.domain.com:443/ibmcognos/bi/v1/disp
Save and try again.

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg22000097

Product:
Cognos Analytics 10.0.12 Framework Manager
Microsoft Windows 2012 server

Problem:
Error when importing certificate file to cognos keystore with IKEYMAN.EXE.

You have setup SSL to the IIS server for the Cognos gateway. To be able to connect with client tools you import certs to cognos keystore.

Go to folder C:\Program Files (x86)\ibm\cognos\model\jre\bin
Click on IKEYMAN.EXE to start the program
Open the certificate store file from folder C:\Program Files (x86)\ibm\cognos\model\configuration\certs
Enter the password
Click Import to import your certificate file
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_pa_use_ibmkeymgmt.html

Error message:
An IO exception has occurred
DER input, integer tag error

Solution:
The format of the certificate is wrong, please try a pfx file instead.

Error message:
An IO exception has occurred
invalid keystore format

Solution:
Wrong format selected when you open the file, please try PKSC12 instead.

More information:
https://www-01.ibm.com/support/docview.wss?uid=swg21339658

Product:
Cognos Analytics 11.0.10
Microsoft Windows Server 2016

Issue:
When you try to insert a picture in a report, I get a error that WebDAV is missing.

Possible Workaround:
Enter the path and name of the picture direct in the dialog.
Enter ../samples/images/alex_active.png

ca11 error3

The pictures have moved to C:\Program Files\ibm\cognos\analytics\webcontent\bi\samples\images
from previous folder C:\Program Files\ibm\cognos\c10_64\webcontent\samples\images.

Start File Manager and check where the pictures are stored on your server. Copy any company pictures to a common folder that is accessible from the web.

Install webdav:
http://www-01.ibm.com/support/docview.wss?uid=swg22002398
More Information:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_frmat_rep_insert_graphics.html
The webdav only works on the IIS server:

http://www-01.ibm.com/support/docview.wss?uid=swg21984684

Product:
Cognos Analytics 11.0.x
Microsoft Windows Server 2012 R2

Issue:
Before a upgrade, got a error, when doing a Export of Content in Cognos Connection.
This is in a multiserver Cognos BI setup, where there are more than one CM (Content Manager) server – that as best practice are setup to share a file share folder for deployments.

Error messages:
CM-CFG-5081 The deployment folder does not exist in the file system.

Possible solution:
Login to the active Content Manager server.

ca11 error2
Check in Cognos Configuration, that Environment – Deployment files location : point to ../deployment. If it points to a file share like \\servername\deployment, then you need to check that the windows services IBM Cognos is run by is a Windows user and not Local System.
Access to file shares is only possible when the IBM Cognos services is run by a Active Directory user account (a service account). If you use local system, then the cognos program can not access file shares on other servers.

Change to ../deployment.
Save and restart the services from inside Cognos Configuration.
Test to run the export again.

Check in folder c:\program files\ibm\cognos\analytics\deployment that the file exists.

Product:
Cognos Analytics 11.0.12 kit_version=11.0.12.18062512
Microsoft Windows Server 2012 R2 (Windows NT 6.2)

Issue:
After upgrade of CA11, when you save the Cognos Configuration you get a error message.
This is in a multi server installation, and this can happen if the Cognos services are started in the wrong order.

Error message:

ca11 error1

Solution:
Reset the certificates on the server where you have the error.

1. Stop the running of your cognos service in Cognos Configuration.
2. On the Content Manager computer, click ‘File > Export As’. (and the other cognos servers)
3. Choose ‘Yes’ at the prompt and save the file. For example, name it ‘backup.xml’ which will be stored in the c11\configuration folder.
4. Close Cognos Configuration.
5. On the Content Manager computer, create a backup of the following files and directories before moving them to a different, secure location (as during the cryptographic keys regeneration process they will be re-created):

The files are:
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

The directory is
c:/program files/ibm/cognos/analytics/configuration/csk

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

8. Repeat steps 1-7 on all computers that have Cognos Analytics Server components installed.
If needed – if it is only one CA11 that have issues, start with only change on that server.

You can surf to http://ca11cm_servername:9300/p2pd/servlet to see if the CM is up.

Text is from this website:
http://www-01.ibm.com/support/docview.wss?uid=swg21995088

How to upgrade CA11

http://www-01.ibm.com/support/docview.wss?uid=swg21994915

Product:
Planning Analytics 2.0.3 (Tm1)
Cognos Analytics 11.0.9 (Cognos BI)
Microsoft Windows 2012 R2 Server

Issue:
When a user is added to a AD group, that then is added to Cognos group, and the Cognos Group is added in the TM1 application as a group. And that group is given access to cubes and dimensions inside TM1. When user login to TM1WEB, he can not see the cubes.
If you look inside TM1 Architect, there is no X for him under the Cognos\group. So Cognos have not understand that he belongs to a AD group.

Solution:
IBM Cognos service run as local system in Windows server.
The Active Directory is setup to allow user to login but not to see other users details, like groups.

ad1

You need to at Namespace – Resource Properties – Binding credentials enter the name and password of a user that have the rights to READ the Active Directory and see what groups a user belongs to.

ad2

When you right click on namespace in cognos configuration and select test, you will first validate the user and there after try to get a list of the groups the user belongs to.

ad3

You need the binding credentials if AD is not configured to allow anonymous bind.

ad4

In TM1 you can add the Cognos group or the AD group direct into TM1 Architect under security – client/groups. Click on Groups and Add New Group. Click on your namespace and search for the group you want to add. When it is added it will look similar, as in the picture above.
If a user is successful to login and belongs to a group, there will be a X under that group for that user. User AD/roger can we see belongs to the Cognos group “TM1 users”.

ad5

Then you have to, inside your TM1 application, give the groups the access they need to the different cubes and dimensions.

More Information:
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.inst_cr_winux.10.2.2.doc/t_inst_activedirectoryserver_process.html

https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.10.2.2.doc/c_controllingaccesstotm1objects_n60007.html

https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.3.0/com.ibm.swg.ba.cognos.prfmdl_ug.10.3.0.doc/c_prfmdl_setting_up_security.html

Product:
Cognos Analytics 11.0.9
Microsoft Windows 2012 R2 Server

Issue:
Does Cognos BI send a mail when you click on TEST of notifications i Cognos Configuration?

Solution:
Yes, cognos configuration test mail function, will send a mail to the default sender with the default sender as sender.
If you enter a valid mail address at the company as the default sender, and click test, that person will have a mail.

Under Data Access – Notifications set it up like this:
SMTP mail server: smtpserver.company.com:25
Account and password: (can be blank if the SMTP server allow resend of anonymous mail)
Default sender: roger@company.com (use the mail address to a person at the company)
SSL Encryption Enabled: False

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21445621
http://www-01.ibm.com/support/docview.wss?uid=swg21339824

Product
Planning Analytics 2
Microsoft Windows 2012 R2 Server

Problem
How to avoid the time out for users of TM1?

Solution (copied from the web)

IIS server:
HTTP Response Headers at the ibmcognos/samples/images level – set common headers to Expire Web Content to After 5 days.
At the Default Web Site – Limits – set Connection time-out (in seconds): to 900.

to1

At Application Pools – ICAPool – Advanced Settings, change Idle Time-out (minutes) to 60.

TM1 SERVER IDLE:
Default: 900 seconds ( 15 minutes )
Location: tm1s.cfg
Setting: IdleConnectionTimeOutSeconds=900
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_idleconnectiontimeoutseconds_tm1.html

TM1 SERVER REST/HTTP:
Default: 20 minutes
Location: tm1s.cfg
Setting: HTTPSessionTimeoutMinutes=20
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_httpsessiontimeoutminutes.html

CAM SECURITY:
Default: 3600 seconds ( 60 minutes )
Location: Cognos Configuration > Security > Authentication
Setting: Inactivity timeout in seconds
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.ig_mob.10.2.0.doc/t_mig_sec_st_cam.html

TM1 WEB:
Default: 20 minutes
Location: \tm1_64\webapps\tm1web\WEB-INF\web.xml
Setting: <session-timeout>20</session-timeout>
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/t_paw_troubleshooting_web_timeout.html

PMPSVC:
Default: 60 minutes
Location: Cognos Configuration > TM1 Applications
Setting: Session timeout (min)
( this setting updates the \tm1_64\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml session-timeout )
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_tm1_inst_contrib_c8security_session_timeout_vals.html

PMHUB / PLANNING ANALYTICS FOR EXCEL:
Default: 3600 seconds ( 60 minutes )
Location: http://localhost:9510/pmhub/pm/admin , Configurations > PMHub Session
Setting: MaxInactivityTimeout

Session timeout in TM1 portal
The TM1 Application Web session-timeout can be adjusted in the following file:
D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\web.xml
Scroll to the bottom of this file and modify the session-timeout to the minutes you desire:
<session-config>
<|– Default to 5 minute session timeouts –>
<session-timeout>5</session-timeout>
</session-config>
Save the files and restart the IBM TM1 Application Server Service.
Session timeout in Cognos Analytics

1. Launch Cognos Configuration and navigate to “Local configuration -> Security -> Authentication”

2. Modify the “Inactivity timeout in seconds” from the default 3600 to your desired time (for example 7200 = 2 hours”).

3. Save the configuration and restart the Cognos service for the changes to take effect

Note:

  • Most web server timeout settings will come into effect long before the 1 hour time limit, but in the even that no such timeouts exist, this setting acts as a backup.
  • Furthermore, if the web server hosts other sites that do not have such a timeout, the Cognos portal can be secured by setting this to a shorted time frame so that only Cognos users are affected
  • The Cognos timeout is set to a value that is less than the timeout set on in-built portal. Make sure you set the value of “Inactivity timeout in seconds” in Cognos configuration to a value which is greater than the Inactivity timeout of your in-house portal.

Error
Unable to successfully log in to TM1Web: Session timed out. Please login again…
Problem(Abstract)
Whenever a user logs into TM1Web the session immediately (falsely) times out.
Cause
The web server has an underscore in the machine name.

More information:

https://www.ironsidegroup.com/2011/06/27/session-timeout-101/

http://www-01.ibm.com/support/docview.wss?uid=swg22002419

3 Ways to Optimize Cognos Timeout Settings

 

Product:
Planning Analytics 2.0.3
TM1SERVER_APP_version=TM1SERVER_APP-AW64-ML-RTM-11.0.3.119-0
Cognos Analytics 11.0.9 kit_version=11.0.9.17121514
kit_name=IBM Cognos Analytics
Planning Analytics Workspace version 29
Microsoft Windows 2012 R2 Server

Problem:
How make SSO with Planning Analytics for Excel work?

Contact IBM Cognos Support to get the latest instructions on how to setup PAX.

https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_tm1_inst_pax_cam.html

Solution:
Setup of Content Store database in SQL server
See here how: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.qrc_inst.10.2.2.doc/t_qrc_inst_sqlserver_createacontentstore.html

Setup of Cognos Analytics 11
See here how: http://cogknowhow.tm1.dk/archives/1056
Ensure that all servernames in Cognos Configuration uses FQDN, dvs servername.domain.com, this is a must for PAW setup.

The manual for CA11
http://www-01.ibm.com/support/docview.wss?uid=swg27047187

Setup of IIS and Cognos Analytics 11 Gateway
See here how: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

Check that SSO is working, to the Windows Active Directory, by surf to http://caservername.domain.com/ibmcognos/bi

Check the .\webcontent\default.htm and .\webcontent\index.html files. Update the last line starting with <meta http-equiv=”refresh” as shown below, (where <alias name> is the alias used in the CA_IIS_config.bat script file). Add /ibmcognos/ in most cases.

pax3

Important that Windows Authentication is on the /ibmcognos/sso folder in IIS manager and that you may need to add Advance properties singleSignOnOption: IdentityMapping in Cognos Configuration for CA11 at security – authentication – namespace – active directory.

If Cognos Application Firewall is used, then you need to add the TM1 servers here also with port 9510.
Open Cognos Configuration for CA11. Go to Local Configuration – IBM Cognos Application Firewall. Click on Valid domains or hosts to add the PAservername to the list of approved domains.
pax10
Click OK, save the new Configuration and restart the Cognos Analytics services. If above is not done, you get error DPR-ERR-2079 when you logout of TM1WEB.

Download of Planning Analytics 2.0.3
List of files
http://www-01.ibm.com/support/docview.wss?uid=swg24044001

Parts and Platforms Installation category Part number
IBM Planning Analytics 2.0.3 Microsoft Windows Multilingual Required CNN7AML
IBM Planning Analytics Client 32-bit 2.0.3 Microsoft Windows Multilingual Optional CNN7BML
IBM Planning Analytics Client 64-bit 2.0.3 Microsoft Windows Multilingual Optional CNN7CML
IBM Planning Analytics Workspace 2.0.3 Multiplatform Multilingual Optional CNN7DML
IBM Planning Analytics Workspace 2.0.3 Microsoft Windows Server 2016 Multilingual Optional CNN7EML
IBM Cognos TM1 Package Connector for Business Intelligence 10.2.2 Microsoft Windows Multilingual Optional CN1Z7ML
IBM Cognos Analytics Server 11.0.7 Microsoft Windows Multilingual Optional CNK1EML
IBM Cognos Analytics Samples 11.0.7 Microsoft Windows Multilingual Optional CNK1XML
IBM Cognos Framework Manager 11.0.7 Microsoft Windows Multilingual Optional CNK1MML

Download from here
http://www-01.ibm.com/support/docview.wss?uid=swg24044081

Setup of PA 2.0.3
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/tm1_inst.pdf

Check that Print Spooler Service is running in your Windows 2012 server.
Install NET Framework 4.6.1 (NDP461-KB3102436-x86-x64-AllOS-ENU.exe) in the Windows server, from here: https://support.microsoft.com/en-us/help/3102436/the–net-framework-4-6-1-offline-installer-for-windows
Install C++ 2010 x64 redistribution (vcredist_x64.exe).

Run the installation from the unziped file in D:\install\pa 2.0.3\tm1_winx64h_2.0.3.119_ml.tar\winx64h\issetup.exe

Go into Cognos Configuration for TM1 (PA2.0.3)
pax1
Under Environment point to the CA11 server.
Set gateway URI to be to the CA11 gateway like this http://caservername.domain.com:80/ibmcognos/bi/v1/disp
Set External Dispatcher URI to http://caservername.domain.com:9300/p2pd/servlet/dispatch
Set Content Manager URI to http://caservername.domain.com:9300/p2pd/servlet

At IBM Cognos TM1 you can tune your WebSphere Liberty Profile;
Set Ping timeout in seconds to a value like 480 seconds.
Set Maximum memory for Websphere Liberty Profile in MB to 4096, if TM1 Web or TM1 Application Web are getting unresponsive and Planning Analytics logs contain some errors java.lang.OutOfMemoryError.

At TM1 Applications leave the Maximum memory in MB at default 768.
Enter TM1 Application Server Gateway URI to http://paservername.domain.com:9510/pmpsvc and External server URI to http://paservername.domain.com:9510.
Consider to change Session timeout to a higher value.
Set TM1 Application Server Dispatcher URI to http://paservername.domain.com:9510/pmpsvc/dispatcher/servlet

At TM1 Clients change the Cognos Insight ping frequency (seconds) to a higher value like 90. See separate page about timeout values http://www-01.ibm.com/support/docview.wss?uid=swg22002419
Skip the Logging, Security, IBM Cognos Application Firewall – they have limited function in this version of PA2.

Start the SDATA and Proven_Techniques example TM1 instances.
We use Proven_Techniques to test SSO, because it have a short TM1S.CFG file, so it is easy to add fields.

Setup of SSO
http://www-01.ibm.com/support/docview.wss?uid=swg22000283

Open C:\Program Files\ibm\cognos\tm1_64\samples\tm1\Proven_Techniques\tm1s.cfg in notepad++.
Add the lines;
IntegratedSecurityMode=2
ServerCAMURI=http://caservername.domain.com:9300/p2pd/servlet/dispatch
ClientCAMURI=http://caservername.domain.com:80/ibmcognos/bi/v1/disp
Save the file and restart the TM1 instance Proven_Techniques.

Exit TM1 Architect.
Erase the tm1p.ini file from here C:\Users\%username%\AppData\Roaming\Applix\tm1 to allow it to get the new values.
Open C:\ProgramData\Applix\TM1\tm1p.ini in notepad and add the values AllowImportCAMClients = T
CognosGatewayURI = http://caservername.domain.com:80/ibmcognos/bi/v1/disp
PAX2
Save the file.

Add users
Start Tm1 Architect, double click on Proven_Techniques to login.
Enter ADMIN as user to login. Right click and select Security – Client/Groups. From menu Clients select Add New Client.
pax4
Click on your namespace name, in out example AD.
pax5
Click on TYPE in top right corner to enter the name of the user.
pax6
Enter the domainnamespace/username. Namespace name is the name you gave it in CA11 cognos configuration. Username most be the users name correct spelled as it is entered in Active Directory.
Click on yellow arrow to add the user, and click on OK.
pax7
Mark the user to be ADMIN, so he can then add other users later.
Click OK and exit TM1 Architect. Now you turn TM1 application to security mode 5,and then this user can login and add additional users in TM1 architect.

Open C:\Program Files\ibm\cognos\tm1_64\samples\tm1\Proven_Techniques\tm1s.cfg in notepad++.
Change the line to 5
IntegratedSecurityMode=5
Save the file and restart the TM1 instance.

Unzip the file C:\Program Files\ibm\cognos\tm1_64\bi_interop\bi_interop.zip to a separate folder like c:\install
There should be two folders
templates
webcontent
Go and update this files with the PA server name and PAW server name;
C:\install\webcontent\planning.html
Update the following to point to the location of the planning service(s)
var planningServices = [“http://paservername.domain.com:9510″,”http://pawservername.domain.com”];
C:\install\webcontent\pmhub.html
Update the following to point to the location of the pmhub service(s)
var pmhubURLs = [“http://paservername:9510″,”http://paservername.domain.com:9510″,”http://pawservername.domain.com”];
C:\install\webcontent\tm1\web\tm1web.html
// Update the following to point to the location of the TM1Web service(s)
var tm1webServices = [“http://paservername.domain.com:8080”, “http://paservername.domain.com:9510”];
Save the files.

The files in C:\install\templates\ps\portal should not be changed.
pax8
pax9
If variables_TM1.xml is not referenced in TM1S.CFG file, then it is most likely not used.

Copy the files and folders in C:\install\webcontent ontop the C:\Program Files\ibm\cognos\analytics\webcontent folder.
Go into C:\Program Files\ibm\cognos\analytics\webcontent\tm1\web\tm1web.html and see that it is the updated file.
Copy the files and folders in C:\install\templates to the C:\Program Files\ibm\cognos\analytics\templates folder.
Replace files as needed.

Copy the C:\Program Files\ibm\cognos\analytics\webcontent\tm1 folder to C:\Program Files\ibm\cognos\analytics\webcontent\bi folder. So you also got a TM1 folder under /webcontent/bi.

Copy the updated files planning.html, pmhub.html, default.htm and index.html from C:\Program Files\ibm\cognos\analytics\webcontent to folder C:\Program Files\ibm\cognos\analytics\webcontent\bi.

Restart IIS with iisreset from a CMD prompt.
Surf to http://paservername.domain.com:9510/tm1web to check that it works.

The first time you start TM1 Application portal, then it will connect to the PA and BI setup. You must surf to http://paservername.domain.com:9510/pmpsvc to set it up.
Enter the host name and the list of TM1 server names should be filled out. Select the proven_techniques from the list.
pax11error
If it looks like above – please try a different version of web browser.
pax11firefox
Above is the correct look, you get in FireFox.
pax12
Press F12 inside Internet Explorer to find the Emulation in use.
Above you see it is using Document Mode 7. The blue text “via intranet compatibility settings” tell us that it is the compatibility settings in internet options on your computer that give the issue. Open it and clear all values out. pax36Test again.
pax13
Change the mode to Edge and it may work for you.
Press OK to save the values to TM1 Application Portal.
pax14
When it is working it should look like above, if you are ADMIN in the Proven_Techniques application you should see all the icons to the right.
This configuration is stored in C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml.

TM1 Operations Console is configured in a web interface. This UI presents multiple options of configuration, including the references to the Cognos Analytics environment.
Surf to http://paservername.domain.com:9510/pmhub/pm/admin
pax15
Expand configurations and select PMHub Security.
At CAMBIURL enter http://caservername.domain.com:9300/p2pd/servlet/dispatch
At CAMGatewayURL enter http://caservername.domain.com:/80/ibmcognos/bi/v1/disp
The values should save automatically in a few minutes.
pax16
Surf to http://paservername.domain.com:9510/pmhub/pm/opsconsole
to check that it works.

TM1 PMPSVC and PMHUB must be setup before you can get PAW to work.

You must setup PAW before PAX are setup.

Download of PAX from here
http://www-01.ibm.com/support/docview.wss?uid=swg27049597
(cor_win32_2.0.29.10_ml.tar.gz)
Installation of PAX
Install NET Framework 4.6.1 (NDP461-KB3102436-x86-x64-AllOS-ENU.exe) from here: https://support.microsoft.com/en-us/help/3102436/the–net-framework-4-6-1-offline-installer-for-windows

Check that Microsoft Office have the primary interop assemblies (PIAs) for Excel installed.
You can download the PIAredist.exe for Office 2010 from here https://www.microsoft.com/en-us/download/details.aspx?id=3508
In Office setup it is named NET Programmable support.
pax17
PIA – Primary Interop Assemblies (PIA) redistributable package for your version of Microsoft Outlook. The PIA is only needed if you have Outlook 2007 or 2010. PIA is not needed for Office 2013 or Office 365, it is part of the Office installation package as .NET Programmability Support for Office. In all version of Office you also need to make sure the .NET Programmability Support is installed (Control Panel – Program and Features – locate Microsoft Office installation, click on Change and Add/Remove features and expand Outlook, it is the first option you can check the box and install it)

Run the file D:\install\pa 2.0.3\pax\cor_win32_2.0.29.10_ml.tar\win32\issetup.exe
pax18
If your excel is 32 bit then you get this error if you select the wrong file. File cor_winx64h_2.0.29.10_ml.tar is for 64 bit excel.
pax19
Click Next
pax20
Select I Agree and click Next
pax21
Click Next
pax22
Click Next
pax23
Click Next
pax24
Click Next
pax25
Click Finish.

Configure PAX
Start Microsoft Excel to configure IBM Planning Analytics
pax26
Select tab IBM Planning Analytics and click on Options
pax27
Click on IBM
pax28
Select IBM Planning Analytics and click on ADD button
pax29
Enter your servername http://paservername.domain.com:9510   (this will make the SSO to work)

PAX should connect to the PAW (Planning Analytics Workspace) URL, like http://pawservername.domain.com:80/ to get the “set editor” to work.

Enter a friendly name, like PMPSVC Connect.
Click on Test Connection
pax30
Click Save
If the test fails, check that servername is correct spelled, and check that Windows Firewall on the server does not block port 9510.
Click OK
pax31
Now you can in Excel click on Connect – Your Friendly name – proven_techniques to start working with that.
pax32
Now you can drag views from PA2 (TM1) into the spreadsheet.

How to use it http://www.element61.be/en/resource/ibm-planning-analytics-excel-pax
pax33
To get “Replace members” to work you need to install PAW.

If you use a TM1 instance that use securitymode=1 (like example SData) then “set editor” will work.
pax34
Above when you point PAX to the PA server and use a PA (TM1 instance) that uses SSO.

If you in PAX connect to PA (Tm1) server at address http://paservername.domain.com:9510/ or http://paservername.domain.com:9510/pmhub/pm then the settings inside pmhub security will tell pax where to go to authenticate.

pax35

if you in PAX connect to PAW like http://pawservername.domain.com then the setting in paw administration (http://pawservername.domain.com:8888) will point to the authentic provider.

Then the value in C:\Program Files\ibm\cognos\analytics\webcontent\pmhub.html and C:\Program Files\ibm\cognos\analytics\webcontent\tm1\web\tm1web.html, can also be important to make it work.  Note that this files are also in folder C:\Program Files\ibm\cognos\analytics\webcontent\bi.

 

Setup of PAW
Ensure you use only FQDN to the servers.

First time you start PAW, you point it to a Native TM1 instance with security mode 2. Then you add your CAM users with TM1 Architect. Set this CAM users to be ADMIN in that instance, and they will be the first ADMIN in PAW. Switch that TM1 instance over to security mode 5. Change in IBM Planning Analytics Workspace Administration Tool from TM1 to CAM authentication mode. You must use security mode 1 first, before you can use PAW with security mode 5.

In IBM Planning Analytics Workspace Administration Tool, you should have this settings:

TM1 Admin Server URI: https://paservername.domain.com:5898

TM1 Application Server Gateway URI: http://paservername.domain.com:9510

Authentication Mode: CAM

IBM Cognos BI Gateway URI: http://caservername.domain.com:80/ibmcognos

IBM Cognos BI Dispatcher URI: http://caservername.domain.com:9300/p2pd/servlet/dispatch

IBM Cognos BI Authentication Namespace ID: AD (the same namespace id you have entered in Cognos Configuration for CA(BI)).

Click Validate and Update.

If above is correct set, then PAX should work pointing to http://pawservername.domain.com

Please note that above setup is for PAW version 29. Other versions of PAW may require other configuration.

See here how to set PAW up http://cogknowhow.tm1.dk/archives/1090

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg22000283
http://www-01.ibm.com/support/docview.wss?uid=swg21958925
https://msdn.microsoft.com/en-us/library/kh3965hw.aspx
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_ig_cor_overview.html

#Cognos Analytics and #Planning Analytics Integration – Walkthrough – Part 2