Product:
Cognos Planning 10.1.1 Fix Pack 7
Cognos BI 10.2.1 Fix Pack 12
Microsoft Windows 2012 R2 Server
Microsoft SQL 2012 database server
Symptom:
How to setup the Cognos Planning 10.1.1 on a new Windows server?
Error message when start the CAC:
An error has occurred while starting IBM Cognos Planning Administrator

Main form failed to initialize

Error Details:

Unable to determine if the Planning Table exist in Content Manager.

Please ensure the Planning Service is running.

sendRequest failedFaoled to send the SOAP message

 

In the file C:\Users\%username%\AppData\Local\Temp\PlanningErrorLog.txt

GUID  Stack   Date Time       Component     Version Information   Module           File            Procedure        Line Number  Source Error Number Error Description        User Domain\User Name    Machine Domain\Machine Name      Previous User Domain\Previous User Name Previous Machine Domain\Previous Machine Name            Process Id        Thread Id

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   1          2016-11-25 14:50:49.096 UTC +60         epcTransport   10.1.6307.4     default TransportClient.cpp   invoke 201            epcTransport::default::TransportClient.cpp::invoke::201     -2147467259            Unexpected: missing HRESULT parameter  DOMAIN\USERNAME            DOMAIN\SERVERNAME    None\None      None\None      4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   2          2016-11-25 14:50:49.112 UTC +60         epcTransport   10.1.6307.4     default TransportClient.cpp   invoke 245            epcTransport::default::TransportClient.cpp::invoke::201     -2147467259            Unexpected: missing HRESULT parameter  DOMAIN\USERNAME            DOMAIN\SERVERNAME    DOMAIN\USERNAME            DOMAIN\SERVERNAME    4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   3          2016-11-25 14:50:49.112 UTC +60         epcTransport   10.1.6307.4     default RemoteDispatcher.cpp            invokeRemoteMethod 71            epcTransport::default::TransportClient.cpp::invoke::201     -2147467259            Unexpected: missing HRESULT parameter  DOMAIN\USERNAME            DOMAIN\SERVERNAME    DOMAIN\USERNAME            DOMAIN\SERVERNAME    4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   4          2016-11-25 14:50:49.112 UTC +60         epcTransport   10.1.6307.4     default RemoteDispatcher.cpp            invokeRemoteMethod 89            epcTransport::default::TransportClient.cpp::invoke::201     -2147467259            Unexpected: missing HRESULT parameter  DOMAIN\USERNAME            DOMAIN\SERVERNAME    DOMAIN\USERNAME            DOMAIN\SERVERNAME    4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   5          2016-11-25 14:50:49.112 UTC +60         epcTransport   10.1.6307.4     default OSProxy.cpp   invoke 120            epcTransport::default::TransportClient.cpp::invoke::201     -2147467259            Process exception       DOMAIN\USERNAME         DOMAIN\SERVERNAME            DOMAIN\USERNAME         DOMAIN\SERVERNAME    4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   6          2016-11-25 14:50:49.112 UTC +60         EAdminUI_10 10.1.6307.9     MTSEAdminDB                     MTSPlanningTablesInCmExist         100            epcTransport::default::TransportClient.cpp::invoke::201     -2147352567            Unable to determine if the Planning Tables exist in Content Manager.  Please ensure the Planning Service is running.~~~~Unexpected: missing HRESULT parameter            DOMAIN\USERNAME         DOMAIN\SERVERNAME            DOMAIN\USERNAME         DOMAIN\SERVERNAME    4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   7          2016-11-25 14:50:49.127 UTC +60         EAdminUI_10 10.1.6307.9     frmMain                     CreatePADTables            110      epcTransport::default::TransportClient.cpp::invoke::201     -2147352567            Unable to determine if the Planning Tables exist in Content Manager.  Please ensure the Planning Service is running.~~~~Unexpected: missing HRESULT parameter            DOMAIN\USERNAME         DOMAIN\SERVERNAME            DOMAIN\USERNAME         DOMAIN\SERVERNAME    4392    3196

{BAFF3619-FB57-4A0F-BB6C-E7084625CFEB}   8          2016-11-25 14:50:57.955 UTC +60         EAdminUI_10 10.1.6307.9     frmMain                     Form_Load     310            epcTransport::default::TransportClient.cpp::invoke::201     -2147352567            Unable to determine if the Planning Tables exist in Content Manager.  Please ensure the Planning Service is running.~~~~Unexpected: missing HRESULT parameter            DOMAIN\USERNAME         DOMAIN\SERVERNAME            DOMAIN\USERNAME         DOMAIN\SERVERNAME    4392    3196

 

Cause:

Not DB_OWNER of the Cognos Planning Store database. Need to open SQL Management studio and make the SQL login for Cognos Planning to be DB_OWNER for that database.

 

Solution (how to install Cognos Planning on Windows 2012):

On the Microsoft SQL 2012 database server create three empty databases

Cognos_cs

Cognos_ps

Cognos_audit

 

Create two SQL logins and set unique password that only contain letters and numbers.

SQL login user: Cognos that should be DB_OWNER on database Cognos_cs and Cognos_audit

SQL login user: Cognosep that should be DB_OWNER on database Cognos_ps

You must also make the Cognosep user have the SQL server role of SysAdmin.

 

The SQL account that is for Cognos Planning need to be able to create and backup databases, therefor does it need a lot of power in the database.

 

Cognos planning cannot use Windows authentication for the SQL databases.

 

In our example, we will have one server 01 for Cognos BI and the Planning Gateway.

And a second server 02 for the Cognos planning server and admin parts.

Microsoft Windows server name must be short, Cognos Planning does not work with server name longer than 15 characters.

 

On the Microsoft Windows 2012 servers, you need to install this:

The Cognos BI server need to have IIS role and features installed.

 

Common HTTP Features with the all sub-components

Like this;

Static Content

Default Document

Directory Browsing

HTTP Errors

WebDav Publishing

 

Health and Diagnostics with the following sub-components

HTTP Logging

 

Performance with the following sub-components

Static Content Compression

 

Security with the following sub-components

Request Filtering

Basic Authentication

Windows Authentication

 

Application Development with the following sub-components

CGI

ISAPI

 

Management Tools with the following sub-components

IIS Management Console

IIS 6 Management Compatibility

IIS 6 Metabase Service

 

For cognos.cgi usage, the CGI Role service must be installed.

For cognosisapi.dll usage, the ISAPI Extensions Role service must be installed.

For WebDAV use, the WebDAV Publishing Role service must be installed.

All above is from control panel – server manager – local server.

 

On both Cognos Planning and Cognos BI server should you;

Turn off IE Enhanced Security Configuration in Server Manager

 

Cognos planning requires that the option “Turn on DEP for essential windows programs and services only” is selected. Turn off DEP, like this:

From the Start Menu, select Computer and then select Properties.

In the System Properties window, click Advanced System Settings in the left options pane.

In the Advanced System Properties dialog, select the Advanced tab.

On the Advanced tab, click Settings in the Performance section.

From the Performance Options dialog, select the Data Execution Prevention tab.

Select the first option Turn on DEP for essential Windows programs and services only.

Click OK to save the changes.

 

Setup Internet options from the Control panel to have trust to the new Cognos servers.

Click on security tab.

Select local Intranet and click on sites.

Select all 3 include all selections

Click on Advance button

Enter the name of the server like: http://servername.domain.com and press add.

Click on close.

Click on OK

Click on OK again to leave the dialog.

 

Best is if above setting for Internet explorer is scripted so all Cognos Planning users have it.

 

Install Microsoft SQL 2012 administration tools from the D:\install\SQL 2012 Std x64 SP1\setup.exe (our where ever you have the SQL media available)

Run setup of the SQL server but only select to install the Administration tools and client connectivity.

(This is needed by the Cognos Planning product and so you can create SQL aliases)

Update to the same Service Pack as you have on your SQL 2012 server.

Then you need to download and install Microsoft SQL Server Native client 2005 driver from file sqlncli_x64.msi

Also, you need to download and install Microsoft SQL Server 2005 Backward compatibility driver from file Server2005_BC_x64.msi

 

It is good to install 7zip so you can unpack the Cognos media files from tar.gz compression.

 

Install Cognos BI all server parts to folder D:\Program Files\ibm\cognos\c10_64

from files like bi_svr_64b_10.2.1_win_ml.tar and up_bisrvr_winx64h_10.2.5012.26_ml.tar.

On the same server install only the gateway part of Cognos Planning to the same location D:\Program Files\ibm\cognos\c10_64 from file pln_gtw_10.1.1_mp_ml.tar, this will work even do the Planning is a 32-bit application.

 

Install the latest service pack for Cognos to same folder.

in the folder D:\Program Files\ibm\cognos\c10_64\instlog you have this files:

ts-BISAMPLES-10.2-5000.275-20161206_1111.ats

ts-BISRVR-10.2-5000.275-20161206_1058.ats

ts-PLANGATE-10.1-6235.51-20161206_1139.ats

ts-UPDATE_BISRVR-10.2-5012.26-20161206_1143.ats

ts-UPDATE_PLANNING-10.1-6307.12-20161206_1142.ats

 

(ATS files show when and what that is installed on a Cognos BI server).

 

Setup the IIS as pointed out for a Cognos BI installation, like this;

http://www.ibm.com/developerworks/data/library/cognos/infrastructure/web_servers/page599.html

 

Go into Cognos Configuration for Cognos BI and setup and at the Environment tab set:

Deployment file location to a share like \\servername\share\deployment

If you have more than one server then you should have a common share.

Full access to the share should in Windows server be to the service account running the Cognos BI service and the Active Directory group containing the Cognos BI administrators and developers.

 

Gateway URI should point to the BI server http://server01.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll

Dispatcher URI for gateway should point to the BI server http://server01.domain.com:9300/p2pd/servlet/dispatch/ext

External and Internal dispatcher URI should point to the own server

http://server01.domain.com:9300/p2pd/servlet/dispatch

Dispatcher URI for external applications should point to BI server

http://server01.domain.com:9300/p2pd/servlet/dispatch

Content Manager URI should point to primary content manager on BI server

http://server01.domain.com:9300/p2pd/servlet

 

On IBM Cognos tab the maximum memory for TOMCAT in MB should be adjusted to 6144.

On a Cognos BI report only server it can be less amount of MB.

 

Under Environment – Logging, right click and select New Resource – Destination.

Enter the name Audit and type Database.

Create a Microsoft SQL server Database connection named Audit.

Point it to the new Cognos_Audit database you have created.

Only the Cognos BI servers need to point to the SQL Audit database.

 

Under Security – Authentication – create a new namespace for Active Directory. Set the namespace ID to be the same as the Recourse name.

Host and port should be the domain like this: domain.com:389

This will make Cognos BI to use the first available Microsoft Windows Domain Controller for the check of user’s authentication.

To make SSO work – under Advance Properties add:

Name: singleSignonOption   Value: IdentityMapping

 

Set IBM Cognos Application Firewall – Enable CAF validation to False.

 

Remove the DB2 content store and create a new SQL data access.

Use Microsoft SQL Server database with SQL login. SQL login works best at the first startup of Cognos BI services, when it should create the database tables in the empty Content store.

 

Under Notification setup enter a SMTP mail server in your organization, like: SMTPRELAY.domain.com:25

Set the Default sender to a mail account in your domain like: cognos@domain.com

 

There is no need to create a planning store on the planning gateway computer.

 

Save and start the Cognos BI service. Exit the Cognos Configuration program.

 

Go to Administrative tools – Services.

Open properties for the IBM Cognos services.

Change the Log on, from Local System account, to a windows service account that is local admin on all the Cognos servers.

After you click OK you need to restart the IBM Cognos service to ensure that the account works.

 

To prevent big dump files on the Cognos BI server when a report crash, please change the value inside the D:\Program Files\ibm\cognos\c10_64\configuration\ cclWinSEHConfig.xml file.

From 2:2 to 0:0 at

<configuration>

<env_var name=”CCL_HWE_ABORT” value=”0:0″/>

</configuration>

 

More info about Cognos BI setup:

https://allthingscognos.wordpress.com/2014/08/05/maintenance-of-ibm-cognos-10-bi-servers/

 

Cognos BI admin tools are installed to D:\Program Files (x86)\ibm\cognos\c10

From files like fm_10.2.1_win_ml.tar, bi_trfrm_10.2.1_win_ml.tar and cubedes_10.2.1_win_ml.tar.

Install the latest Service pack to Cognos BI 10.2.1 from

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

 

In folder D:\Program Files (x86)\ibm\cognos\c10\instlog there should be files like this;

ts-BIMODEL-10.2-5000.275-20161206_1106.ats

ts-BITRSFRMR-10.2-5000.275-20161206_1130.ats

ts-DCUBEMODEL-10.2-5000.275-20161206_1134.ats

ts-UPDATE_BISRVR-10.2-5012.26-20161206_1151.ats

 

Go into Cognos Configuration for Cognos BI 10 and set gateway URI to http://server01.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll and set Dispatcher for external applications to the local bi server that is http://server01.domain.com:9300/p2pd/servlet/dispatch

Save and exit the Cognos Configuration.

 

You need to download the .JAR files from Microsoft download center site:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

or search for “Microsoft JDBC Driver for SQL Server” via your favorite search engine.

Follow the Microsoft instructions to download and install.

Once done, locate the .JAR files sqljdbc4.jar and sqljdbc.jar then copy:

– sqljdbc.jar (SQLServer 2005)

– sqljdbc4.jar (SQL Server 2008 & 2012)

to <Install_Cognos>\v5dataserver\lib

and <Install_Cognos>\webapps\p2pd\WEB-INF\lib

You need to stop/start Cognos BI service to load the jars on startup.

 

On the Cognos Planning server 02 you need to install Cognos Planning server and admin tools only and the latest service pack from files like pln_adm_10.1.1_win_ml.tar, pln_srv_10.1.1_win_ml.tar and up_planning_win32_10.1.6307.12_ml.tar.

 

You should install to folder D:\Cognos. From Microsoft Windows 2012 later service packs the support for 8.3 file names is removed, and that is needed for Cognos Planning. Therefor you must install Cognos Planning to a different folder than D:\Program files (x86)\ because Cognos Planning does not support files or folders that have more than 8 characters.

 

During install you should point to a shared Analyst folder like: \\server02\share\analyst

During install of Cognos Planning Administrator you must also mark “to be run on a Citrix environment”.

 

Then you should in install log folder D:\cognos\c10\instlog have this files;

ts-PLANSRVR-10.1-6235.51-20161214_2106.ats

ts-PLANADMIN-10.1-6235.51-20161214_2112.ats

ts-UPDATE_PLANNING-10.1-6307.12-20161214_2114.ats

 

You should run a batch script to ensure that the Cognos Planning files are registries on the Microsoft Windows server.

Save below line of text in a REGDLL.CMD file in folder d:\cognos\c10\bin\

FOR %%1 IN (*.DLL) DO REGSVR32 /S %%1

Save below line of text in a REGOCX.CMD file in folder d:\cognos\c10\bin\

FOR %%1 IN (*.OCX) DO REGSVR32 /S %%1

Open a command prompt as administrator and run above CMD files.

 

When installation is done, you should take a backup of the \\server02\share\analyst folders to a d:\temp\backup folder. You may need to restore this files if you fail to start Planning Analyst later.

 

Then on the Cognos Planning server 02 you need to create a local SQL alias for the planning data store. The name should be same as last installation or a very good common name.

Start SQL server configuration manager

Expand SQL native Client 11.0 Configuration (32 bit) – alias

Right click and select New Alias

Set Alias name to: planningds

Set port no to: 1433

Leave protocol at: TCP/IP

Set server to: SQLSERVERNAME

Press OK.

To make sure it works – setup the same alias for the 64-bit SQL client.

 

Setup Cognos planning configuration to have a common deployment files location like this

\\server01\share\deployment

Set the Gateway URI to the BI server like this http://server01.domain.com:80/ibmcognos/cgi-bin/cognosisapi.dll

Set the External and Internal dispatcher URI to point to the Cognos Planning server itself as this

http://server02.domain.com:9300/p2pd/servlet/dispatch

Dispatcher URI for external applications should point to BI server

http://server01.domain.com:9300/p2pd/servlet/dispatch

Content Manager URI should point to primary content manager on BI server

http://server01.domain.com:9300/p2pd/servlet

plan2

On the first Cognos Planning server all IBM Cognos Service should be active (true)

Data Movement service enabled= True

Dispatcher service enabled=True

Planning administration console service enabled= True

Planning data service enabled= True

Planning job service enabled= True

Planning Web service enabled= True

 

If you install more Cognos Planning Windows servers that should act as Job servers then only 3 service should be active on them, like this:

Data Movement service enabled= True

Dispatcher service enabled= True

Planning administration console service enabled= False

Planning data service enabled= False

Planning job service enabled= True

Planning Web service enabled= False

 

On the planning tab you need to change Analyst maximum workspace size in KB to 512000

 

You need to delete the DB2 planning store and create a new Planning Store for data access with Microsoft SQL server database. Cognos Planning does only work with SQL user login to database.

Version should be SQL server 2008.

Enter the database servername and port like this; databaseservername.domain.com:1433

Enter the SQL login user and password.

Cognos Planning only support user and passwords that contain A-Z and numbers, no special characters is allowed.

Point to your new database: Cognos_ps

 

If not SQL server 2012 is shown inside Cognos Configuration as an option, you can add support to it by update the D:\cognos\c10\bin\epEAdminSQL7Resources.xml file.

Make a backup copy of the c10_location\bin\epEAdminSQL7Resources.xml file.

Open the c10_location\bin\epEAdminSQL7Resources.xml file in a text editor.

Find the entry for Resource ID=”2k8DefaultProviderDriverString” and locate the <![CDATA[SQLNCLI10]]> entry.

Change the entry to read <![CDATA[SQLNCLI11]]>.

Save the file and close it.

In Cognos Configuration, you must still select Microsoft SQL Server 2008 from the Version list. However, you must supply connection parameters for your Microsoft SQL Server 2012 database.

After you make this change, you cannot use a Microsoft SQL Server 2008 database for your Planning store. You must change the <![CDATA[SQLNCLI11]]> entry back to <![CDATA[SQLNCLI10]]>, if you need to revert to using SQL Server 2008.

 

The first section of the epEAdminSQL7Resources.xml file looks like this after the change:

<Resources>

<Resource ID=”2k5DefaultProviderDriverString” Context=”Customization” Hint=”The SQL Server 2005 default string used in the ADO connection string that is generated for a new Application.”>

<![CDATA[SQLNCLI]]>

</Resource>

<Resource ID=”2k8DefaultProviderDriverString” Context=”Customization” Hint=”The SQL Server 2008 default string used in the ADO connection string that is generated for a new Application.”>

<![CDATA[SQLNCLI11]]>

</Resource>

<Resource ID=”2k12DefaultProviderDriverString” Context=”Customization” Hint=”The SQL Server 2012 default string used in the ADO connection string that is generated for a new Application.”>

<![CDATA[SQLNCLI11]]>

</Resource>

<Resource ID=”AllDefaultProviderDriverStrings” Context=”Customization” Hint=”All supported default strings used in the ADO connection string that is generated for a new Application.”>

<![CDATA[SQLNCLI,SQLNCLI10,SQLNCLI11]]>

</Resource>

<Resource ID=”Create container DDL” Context=”Customization” Hint=”%1 is container name, %2 is folder name”>

<![CDATA[CREATE DATABASE [%1] ON PRIMARY ( NAME = [%1_dat],  FILENAME = N’%2%1_dat.mdf’,  SIZE = 10MB,  FILEGROWTH = 10% )     LOG ON  ( NAME = [%1_log],  FILENAME = N’%2%1_log.ldf’,  SIZE = 10MB,  FILEGROWTH = 10% )]]>

</Resource>

<Resource ID=”Post Create Container Script” Context=”Customization” Hint=”This will run after the database is created. %1 is the databasename”>

<![CDATA[

— USE [%1]

— EXEC sp_grantdbaccess [DOMAIN\USER]

— EXEC sp_addrolemember [db_datareader], [DOMAIN\USER]

— EXEC sp_addrolemember [db_datawriter], [DOMAIN\USER]

— EXEC sp_addrolemember [db_ddladmin], [DOMAIN\USER]

]]>

</Resource>

 

You must also change the value in epEAdminSQL7Resources.xml file for SIZE to a large value that match the size of the model database size on the new Microsoft SQL server, can be 512 Mb or 2048 MB. If not correct set you cannot create new Planning applications.

<![CDATA[CREATE DATABASE [%1] ON PRIMARY ( NAME = [%1_dat],  FILENAME = N’%2%1_dat.mdf’,  SIZE = 2048MB,  FILEGROWTH = 10% )     LOG ON  ( NAME = [%1_log],  FILENAME = N’%2%1_log.ldf’,  SIZE = 10MB,  FILEGROWTH = 10% )]]>

 

 

In folder D:\cognos\c10\bin\LANGUAGE\English copy file adminbifs.AMF to adminbif.AMF

And copy file adminodbc.AMF to adminodb.AMF, this to ensure Analyst can access the long-named files. Cognos Planning can only understand 8 characters’ filenames.

 

Ensure that the analyst folder is shared and set an AD group with all Planning admin and developers to have full access to the share. Ensure that the AD service account used by Cognos Planning have full access to the share for filesys.ini.

 

To be able to run Cognos Administrator Console you must set Cognos BI to use SSO, and add the users that should run CAC to the Cognos group “Planning Rights Administrators” inside Cognos Connection.

Then on the computer where you start CAC you need to in Internet Options add the Cognos BI server to be in trusted intranet zone, to make the SSO work.

 

You can install Framework Manager, the metadata modeling tool for IBM Cognos BI, to create models from published planning packages. To make it work you need to install Cognos Frame Work manager on the same server as you did install Cognos Planning. Install to folder D:\cognos\c10fm and configure Cognos Configuration URI for FrameWork manager to point to the Cognos BI server.

 

If you use the Generate Framework Manager extension or the Generate Transformer Model extension you will need to install Framework Manager and Transformer on the same machine that you have installed the Planning Admin tools on.

Since Framework Manager and Transformer are now different renditions they need to be installed into separate directory paths. To accommodate for this in Cognos Configuration browse to the Planning entry in the Cognos Configuration tree – at Component Properties at IBM Cognos BI Installation location, set the value to a path pointing to the directory that IBM Cognos Business Intelligence Framework Manager is installed in.

PLAN1

Note: A common mistake is browsing too deeply into the directory such as to the \bin location. Browse only to the parent directory such as \ibmcognos\c10 or in this example d:\cognos\ibm\c10fm.

 

If you did not install Cognos Analyst on the computer, you may need to add some of this values to windows registry to make Cognos Analyst work for you. (You can save them in text files with the ending .REG on your computer, then click on them to read in the values to your registry.)

 

This files can be created from the user who installed and run Cognos Analyst

Login to Windows as the user who installed Analyst:

From Start/Run menu of Windows, launch REGEDIT.EXE:

– Export HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101

– Go to HKEY_CURRENT_USER\Software\Cognos if it exists, then on the right pane, note the value of string value called “Analyst” if this exists.

For Windows 2008 64-bit, it is also necessary to create an additional registry key (string value “Analyst”) under HKEY_CURRENT_USER\Software\Cognos\Analyst and set it to the full path of the \bin directory (i.e. for version 10 <Install Location>\ibm\cognos\c10\bin\).

For Planning Manager, it may be necessary to create the following additional key:

HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101\Analyst\TableDefaults


Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\IBM\Cognos]

[HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101]

[HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101\PAD]

[HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101\PAD\{A395B1CD-AD3A-4165-A141-A208220B5F59}]

[HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101\PAD\{A395B1CD-AD3A-4165-A141-A208220B5F59}\ContributorAdmin]

[HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101\PAD\{A395B1CD-AD3A-4165-A141-A208220B5F59}\ContributorAdmin\Cognos Default UserName]

@=””

[HKEY_CURRENT_USER\Software\IBM\Cognos\Planning101\PAD\{A395B1CD-AD3A-4165-A141-A208220B5F59}\ContributorAdmin\Create App Wiz Show Welcome]


Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Cognos]

“Analyst”=”d:\\cognos\\c10\\bin\\”


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Cognos]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Cognos\c10dot1dot132]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Cognos\c10dot1dot132\InstallStream]

“Install Location”=”d:\\cognos\\c10\\”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Cognos\CognosRCP]

“AppsLocation”=”d:\\cognos\\c10\\crcp\\CognosRCP\\rcp\\applications”

“NoUpdate”=”Yes”


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst]

“-“=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\AnalystHelp]

“EN”=”d:\\cognos\\c10\\webcontent\\documentation\\EN”

“DE”=”d:\\cognos\\c10\\webcontent\\documentation\\DE”

“FR”=”d:\\cognos\\c10\\webcontent\\documentation\\FR”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\AnalystMessageLibs]

“EN”=”d:\\cognos\\c10\\bin\\Language\\English”

“DE”=”d:\\cognos\\c10\\bin\\Language\\German”

“FR”=”d:\\cognos\\c10\\bin\\Language\\French”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Aplpipes]

“APL_UNICODE”=”d:\\cognos\\c10\\bin\\aplunicd.ini”

“APLNAME”=”PIPES”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\BX]

@=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Compatibility]

“FlagsAsMasks”=”0”

“PipesAsSpaces”=”Yes”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\CP]

“Enable”=”No”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Custom]

“WindowsTranslation”=”1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Dyalog]

“aplk”=”NONE”

“aplkeys”=””

“aplnid”=”0”

“aplt”=”NONE”

“apltrans”=””

“Dyalog”=”d:\\cognos\\c10\\bin”

“MAPCHARS”=”0”

“MAXWS”=”64000”

“session_file”=”d:\\cognos\\c10\\bin\\DEF_UK.DSE”

“wspath”=”d:\\cognos\\c10\\bin”

“YY_WINDOW”=”1950”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Main]

“Analyst”=”d:\\cognos\\c10\\bin”

“APLUNICODE”=”d:\\cognos\\c10\\bin\\aplunicd.ini”

“Debug”=”No”

“DefaultUser”=”Admin”

“Language”=”English (UK)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\MRU]

@=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Server]

“LocalServer32Cmd”=”d:\\cognos\\c10\\bin\\dyalog32.exe”

“LocalServer32Params”=”\”d:\\cognos\\c10\\bin\\AFW.dws\” INIFILE=\”HKEY_LOCAL_MACHINE\\Software\\IBM\\Cognos\\Planning101\\Analyst\\dyalog\” Server=No Planning=\”Software\\IBM\\Cognos\\Planning101\\Analyst\”  APPNAME=Analyst”

“WINEXEC”=”d:\\cognos\\c10\\bin\\dyalog32.exe Planning INIFILE=\”HKEY_LOCAL_MACHINE\\Software\\IBM\\Cognos\\Planning101\\Analyst\\Dyalog\” Server=Yes PLANNING=\”Software\\IBM\\Cognos\\Planning101\\Analyst\” APPNAME=Analyst”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\ServerList]

“DefaultServer”=”Hydra Server”

@=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\ServerList\Hydra Server]

“DefaultLibrary”=””

“DefaultUser”=”Admin”

“Hydra”=”Yes”

“WINEXEC”=”d:\\cognos\\c10\\bin\\dyalog32.exe Planning INIFILE=\”HKEY_LOCAL_MACHINE\\Software\\IBM\\Cognos\\Planning101\\Analyst\\Dyalog\” Server=Yes PLANNING=\”Software\\IBM\\Cognos\\Planning101\\Analyst\” APPNAME=Analyst”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Settings]

“ReporterOnly”=”0”

“Language”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\Sqapl]

“APL_UNICODE”=”d:\\cognos\\c10\\bin\\aplunicd.ini”

“SQAPLPATH”=”d:\\cognos\\c10\\bin”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Analyst\StartUp]

@=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web\epCacheEx]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web\epCacheEx\JceCache]

“Name”=”jcecache84”

“Path”=hex(2):25,00,54,00,45,00,4d,00,50,00,25,00,00,00

“CleanUpDays”=dword:00000001

“CleanUpPerProcess”=dword:00000001

“ShrinkPolicy”=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web\epCacheEx\JceCache\Plugins]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web\epCacheEx\JceCache\Plugins\Compression]

“Library”=”epCacheCompression.dll”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web\epCacheEx\JceCache\Plugins\Encryption]

“Library”=”epCacheEncryption.dll”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Components\Web\OfflineGrid]

“FilePath”=”d:\\cognos\\c10\\bin”

“DocPath”=”$(DocDir)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Contributor]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Contributor\Settings]

“Language”=”EN”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\epLogger]

“NTEventLogOnly”=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\epTraceLogger]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\epTraceLogger\unknown.DurationTimer]

“LogLevel”=dword:00000004

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos\Planning101\Planning]

“TempPath”=””


Login with service account that should run the Cognos Planning service

And set region settings to English UK. In Control panel select Region, and under Format select English (United Kingdom) and press Apply and OK. The most important is that all Windows servers that run the Cognos program should have the same regional settings.

 

And temp to point to d:\temp\eptmp folder. In Control panel select System, click on Advance system settings. Click on Environment Variables button.

Select TEMP and click on EDIT button to change it to d:\temp\eptmp

Do the same for TMP value.

Click OK.

 

The Cognos services should be set to startup type “Automatic (Delayed start)” on a Microsoft Windows 2012 server.

 

In IBM Cognos Planning version 10.1.1 and later, there is no longer a Planning Monitor Service that runs tasks. Instead, Cognos Planning tasks are controlled by the IBM Cognos Business Intelligence server’s Monitor Service.

To active this you need to enter this values;

In IBM Cognos Administration in Cognos BI, on the Configuration tab, click Dispatchers and Services.

Click the Cognos BI dispatcher that you want to configure. The list of services is displayed.

Find the MonitorService service. You may have to click the Next Page icon to find the service in the list.

Click the Set properties – MonitorService icon.

On the Settings tab, for the Advanced settings of the Environment Category, click Edit.

Select Override the settings acquired from the parent entry.

Create a new parameter named enable.session.affinity. Set its value to true.

Create another new parameter named session.affinity.services.

Set its value to serviceName=planningAdministrationConsoleService.

Click OK, then click OK again.

 

To prevent errors because of people login to the server with the service account this should be set;

Logon to the application server as an administrator

Launch the group policy editor (click “Start – Run” then type “gpedit.msc”)

Navigate “Computer Configuration -> Administrative Templates -> System-> UserProfiles”

Double-click on “Do not forcefully unload the user registry at user logoff”

Change the setting from “Not Configured” to “Enabled”.

 

The Cognos Planning Contributor client need to be reinstall at each workstation for every service pack you update on the Cognos Planning server.

The install of the Cognos Planning Contributor client can be scripted with a BAT file with this content:

msiexec /i “\\server01\share\contributorclient\cognosRCP.msi” TARGETDIR=”C:\ProgramData” ALLUSERS=2

msiexec /i “\\server01\share\contributorclient\contributor.msi”

 

(you need to create above share and give all users access to it, also any previous installed Cognos Planning client need to be uninstalled from the workstation before above file is run.)

The file CognosRCP.msi 64904 KB and Contributor.msi 59200 KB can be found on the Cognos Planning server in folder D:\cognos\c10\webcontent\rcp_installs.

 

Please ask the IT department to exclude the Cognos folders from the active anti-virus scan on the Microsoft Windows servers. That should be these folders and subfolders to exclude from scan;

D:\Program Files\ibm\cognos\c10_64

D:\Program Files (x86)\ibm\cognos\c10

D:\cognos\c10

D:\temp\EPtmp

 

If you have problem with large Cognos Planning Contributors models you may need to adjust MaxClientRequestBuffer in Windows registry.

The MaxClientRequestBuffer limits the cumulative bytes size of the request line and header fields sent in a request to IIS.  The default value has been significantly reduced by Microsoft in latest versions of IIS and Windows. Go to this key in regedit on the Windows server;

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w3svc\parameters

Then edit the MaxClientRequestBuffer key. If this key doesn’t exist, add it, and set its data type to REG_DWORD. Then, in the DWORD Editor, select Decimal value, and then enter the number of bytes for the buffer.

 

To make Planning fully working with SQL Server 2012 you have also to download and install “SQL Server 2005 Backward Compatibility Components” (SQLServer2005_BC.msi):

Go to “Microsoft SQL Server 2008 Service Pack 3 Feature Pack” page:

https://www.microsoft.com/en-gb/download/details.aspx?id=27596

Click Download

Select ENU\x64\SQLServer2005_BC.msi if your Windows is 64-bit

Select ENU\x86\SQLServer2005_BC.msi if your Windows is 32-bit

On a 64-bit Windows, only the 64-bit version of SQL Server 2008 Feature Pack installer can be launched: trying to run the 32-bit version of the installer on a 64-bit machine will fail with message “Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.”

 

If problems, check this links

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

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

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

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

To setup Cognos Planning 10.2.x with Cognos Analytics 11, see here

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

Product:
Cognos Planning 10.1.1
Windows 2008 R2 server
Microsoft SQL 2008 database

Symptom:
Can not create database to imported Cognos Planning application

Have installed Cognos Planning 10.1.1 on a new server and want now to move the old Cognos Planning 8.4 application to the new server.
Recommended way is to export deployment packages from the Cognos Planning 8.4 administration console, and then import the files in the new Cognos Planning 10.1.1

Workaround:
Take a backup of the Cognos Planning application database on the old SQL 2005 server.
Restore the database on the new SQL 2008 server.
Make the cognos SQL login to be dbowner on the cognos planning database.
From Microsoft SQL Server Management Studio
Select the cognos planning database
expand tables and select table dbo.adminoptions
right click and select “edit top 200 rows”
find in column optionid the following 3 rows and erase the value at optionvalue for these
PAD_GUID
PAD_NAME
PAD_NAMESPACE
(Consider to update the value for BACKUP_LOCATION to a windows folder on the new SQL server.)
Close SQL Server Management Studio

Go into Cognos Planning Administration on the New Cognos Planning server
Expand datastores down to Applications.
Right click on applications and select Link to existing Applications…
You will get a list of the available Cognos Planning applications databases.
(if the list is empty, you point the datastore to the wrong database server or have not done above change in adminoption table correct)
Mark one of them and enter a application ID in the right column.
(Application ID should only be of A-Z and numbers, and no spaces.)
Click Add

“Your Cognos Planning Application needs to be upgrade from Cognos Planning 8.4 to Cognos 10 Planning 10.1. This is a major functional upgrade and therefore Cognos recommends that you migrate and upgrade your existing applications via Deployments. To proceed with a deployed upgrade press No and refer to the product documentation.
Would you like to continue with an in-place upgrade?”
Press Yes

“Are you sure you want to do an in place upgrade of your Cognos Planning Application? The Application will be updated and will no longer be functional in Planning 8.4. Please ensure that you have backed up the Planning Application database before proceeding. The upgrade components create schemas and tables and populate them with data. Therefore users specified for connections must have been granted privileges to create and drop schemas and tables.
Do you want to proceed with the upgrade now?”
After you ensure you have backup of databases, Press Yes

“The application upgrade to version 10.1 was successful.
You must GTP your applications and set them online before they can be used.”
Press OK.
Expand the Cognos Planning application to –
development – application maintenance – Go To Production Options.
Check Location value to be a existing Cognos connection folder in the new Cognos Planning 10.1.1 installation.
Do a GTP.
Set the application ONLINE.
Repeat above for the other Cognos Planning applications you want to move and upgrade.

Try to upgrade and move the macros and admin links with use of a deployment package.
You need go through each macro and ensure path to applications are correct.

Ensure that your new applications are added to the Cognos Planning job cluster.

More Info
You must create a data store to the new SQL server in Cognos Planning Administration first.
http://publib.boulder.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.contrib_admin.10.1.0.doc%2Fcontrib_admin_id2297WP0192.html

You need also create a Job server cluster, and add your new Cognos Planning servers to this cluster.
http://publib.boulder.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.contrib_admin.10.1.0.doc%2Fcontrib_admin_id2297WP0192.html

You can not use “Upgrade Planning Administration Domain” with Cognos Planning 8.2 or newer installations. This is for upgrading from a older version of Cognos Planning.

Product:
Cognos Planning 10.1.1
Windows 2008 R2 server

Symptom:
How do I upgrade my analyst folders from Cognos Planning version 8.4?

Solution:
Create a file share on the new planning 10.1.1 server.
In our example we call it \\newplanserver\cognosplanning
Make everyone have full access to the share
(later change that to only allow planning administrators and service accounts to have access)

Copy you analyst models folders over to the new share from the old Cognos planning server.
(check inside Cognos Planning Analyst for the path to the files – under File -Administration – Maintain Libraries and Users)

Copy the LIBS.TAB file from the old planning filesys.ini share to the new share.
Disconnect from the old Cognos planning server, so you are not mapped to it any more.

Start New Cognos Analyst on the New Cognos planning server.
Select File – Administration – Upgrade – Existing Libraries
Browse to your local LIBS.TAB file.
Click on OPEN.

“Some of the libraries you are about to import has the same library number as libraries that already exists in analyst.
These libraries cannot be imported.
You can manually copy existing libraries to a different library number, and them manually connect to the old libraries via the Add Library functionality in the Admin screens.”

Click OK.

Now you have the Analyst libraries in the list of Maintain Libraries and Users.
But they have the old path, that is wrong and need to be changed.

Right click on a library in the list and select “Change Library Path…”

In the Find string you enter the part of the path you want to replace
can be \\oldservername\analystshare
In the replace with string you enter the new path to your librarys
in our case that is \\newplanserver\cognosplanning

Click Replace

“The path will be changed for xx libraries.
You can press Cancel to abort the operation.
OK to continue.”

Click OK

Now all the path are updated – they are shown in CAPITAL LETTERS.

To validate the path afterwards, just click Properties for each library since that will report if there are any problems.

IMPORTANT: We do not guarantee this process, you need to make sure you have valid backup of your Cognos planning files before starting the upgrade process.

Product:
Cognos TM1 9.5.2
Microsoft Windows 2008 R2

Problem:
When user surf to Cognos Application Web on the url http://tm1servername.domain.com:8080/pmpsvc
Then click on the icon for “update application” in the list they get the error
“Could not open specific application”

Cause:
The wrong cert file are in user catalog
C:\Users\%username%\AppData\Roaming\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7347.0\ssl
Copy the new certificates to this folder then it will work for that user.
Cognos Tm1 9.5.2 is not supported, so there is no provision agent.

Solution:
Copy the new cert to folder D:\NewSSLCerts
Create a bat file with this content:
d:
cd D:\NewSSLCerts
copy /B /Y D:\NewSSLCerts\*.* “%appdata%\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7347.0\ssl*.*”
copy /B /Y D:\NewSSLCerts\*.* “%appdata%\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7343.0\ssl*.*”
copy /B /Y D:\NewSSLCerts\*.* “%appdata%\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7278.0\ssl*.*”

Save the file as d:\updatecert.bat

Update the BAT file with correct path and ” characters.

Create a shortcut icon to that file on the users desktop by putting it in folder
C:\Users\Public\Desktop,   on a Microsoft Windows 2008 R2 server.
Let the user run the BAT file before starting administration of Cognos Application web.

If a new user start the administration program from the Tm1 application web (pmpsvc) in Tm1 9.5.2 he will get the error, but thereafter he maybe can update his user profile on his computer with above bat file.

More Information:

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

The version of the TM1 server installation can be determined be examining the contents of the cmplst.txt file and the file version of the tm1sd.exe file in the bin64 directory. The following is a list of version numbers from both the tm1sd.exe file and cmplst.txt file.
cmplst.txt file
Within the IBM Cognos TM1 install folder look for a file called cmplst.txt. The default installation location for TM1 10.1 and higher is typically C:\Program Files\ibm\cognos\tm1_64 and C:\Program Files\cognos\tm1 for 9.5.2 and lower.

Within this cmplst.txt file look for [Product Update Information]. If this section is missing or blank, then you have the RTM (first release) installed. If the section is populated, reference the table above to determine the service pack installed.
tm1sd.exe file
To find the version of the TM1 server, browse to the TM1 Server bin64 directory (or bin in 9.5.2), right click and select properties on the tm1sd.exe file. Examine the Product version field.

Note that TM1 9.5.2 and lower versions do not include a cmplst.txt file. You must determine the version of the TM1 Server by examining only the details of the tm1sd.exe file.

TM1 9.5.2 RTM – 9.5.20000.11857
TM1 9.5.2 Fixpack 1 – 9.5.20100.18046
TM1 9.5.2 Fixpack 2 – 9.5.20200.22178
TM1 9.5.2 Fixpack 3 – 9.5.20300.29580
TM1 9.5.2 Fixpack 3 Interim Fix 7 (http://www-01.ibm.com/support/docview.wss?uid=swg24039812) – 9.5.20328.42361

TM1 10.1 RTM
cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.1.6237.212-0
tm1sd.exe version – 10.1.00000.20166

TM1 10.1 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.6301.21-0
tm1sd.exe version – 10.1.00100.24600

TM1 10.1 Fixpack 1 Interim Fix 3
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.6301.86-0
tm1sd.exe version – 10.1.00111.37787

TM1 10.1.1 RTM
cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.1.7000.91-0
tm1sd.exe version – 10.1.10000.26473

TM1 10.1.1 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0
tm1sd.exe version – 10.1.10100.31864

TM1 10.1.1 Fixpack 2
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7102.32-0
tm1sd.exe version – 10.1.10200.39014

TM1 10.1.1 Fixpack 2 Interim Fix 4 (http://www-01.ibm.com/support/docview.wss?uid=swg24039813)
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7102.133-0
tm1sd.exe version – 10.1.10312.42293

TM1 10.2 RTM
cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5000.367-0
tm1sd.exe version – 10.2.00000.36339

TM1 10.2 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5001.145-0
tm1sd.exe version – 10.2.00100.39992

TM1 10.2 Fixpack 2
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5002.20-0
tm1sd.exe version – 10.2.00200.41411

TM1 10.2 Fixpack 2 Interim Fix 4 (http://www-01.ibm.com/support/docview.wss?uid=swg24039814)
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5002.1040-0
tm1sd.exe version – 10.2.00210.42310

TM1 10.2.2 RTM
tm1sd.exe version – cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5200.234-0
10.2.20000.50183

TM1 10.2.2 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5210.167-0
tm1sd.exe version – 10.2.20100.123

TM1 10.2.2 Fixpack 2
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5220.91-0
tm1sd.exe version – 10.2.2020055

TM1 10.2.2 Fixpack 3
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5230.146-0
tm1sd.exe version – 10.2.20300.93

TM1 10.2.2 Fixpack 3 Interim Fix 1009
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5230.1009-0
tm1sd.exe version – 10.2.20300.98

TM1 10.2.2 Fixpack 4
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5240.167-0
tm1sd.exe version – 10.2.20400.80

TM1 10.2.2 Fixpack 5
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5250.191-0
tm1sd.exe version – 10.2.20500.75

 

Information is from this site:

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

Product:
Cognos TM1 10.2.2
Microsoft Windows 2012 Server

Problem:
How do I list the Admin users in a TM1 application?

Solution:
There are different ways to get similar information;

List of users who have logged in to the TM1 application can be seen in the log file.

Here is a quick way to track user login/logout in TM1 using standard TM1 functionality, i.e. ACTIVE or blank STATUS Value from the }ClientProperties cube.

As of the TM1 9.1 release and later, the STATUS field is not automatically updated, so you will need to enable a background thread to keep the STATUS field up-to-date by setting the ClientPropertiesSyncInterval configuration parameter in tm1s.cfg file.

The background thread will wake up periodically and update the STATUS field for all clients indicating which are currently connected to the server. The configuration parameter ClientPropertiesSyncInterval is the number of seconds the background thread waits between updates. Example: ClientPropertiesSyncInterval=5

  • In the Server Explorer (TM1 Architect) , select View–>Display Control Objects from the top menu bar. Right click on Cubes and select Security Assignments.
  • Scroll down and ensure that Logging is checked for the }ClientProperties cube.
  • Select the tm1server and right click on View Transaction Log.
  • Select Cubes: }ClientProperties and the required date range.
  • Click Edit–>Select All–>Copy and then paste the records into an Excel spreadsheet.

The raw data in the Excel spreadsheet can be analyzed by creating a pivot table to count the number of OldValue or NewValue for each user (Key1) and for each day (LogTime). Convert the LogTime to a suitable month/year format to analyze the user login counts by month. Create your own Excel format for reporting TM1 User activity.

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

Use an external program to find the usages, try this to see if they can help you;

http://www.bspsoftware.com/products/metamanager/tm1/

https://www.motio.com/content/CognosTM1-free-software.do

Use a TI process to list the users in the security cube, into a different cube, this script below need to be edit to have the USERGROUPS you want to list, and then you have to look into the result cube, to see what GROUPS each user is part of. Should give that it is easy for you to see the number of user that are ADMIN in an application.

In each TM1 application, create a new TI process, and paste below code in PROLOG and EPILOG.

“edit” groups and save and run. You will have a new cube that will list users in group.

#————————————–

# Below code should be in PROLOG
# set default values
#————————————–

sTargetCube=’ClientMemberships’;
sClientDim=’Clients’;
sClientMemberDim=’ClientsMembership’;

sCube=’}ClientGroups’;
sDim=’}Clients’;

sGroup1=’ADMIN’;
sGroup2=’DataAdmin’;
#————————————–
# create dimensions if they do not exist
#————————————–

if (DimensionExists (sClientDim)=0);
DimensionCreate (sClientDim);
endif;

if (DimensionExists(sClientMemberDim)=0);
DimensionCreate (sClientMemberDim);
endif;
#——————————————–
# create cube if not exist
#——————————————–

If (Cubeexists (sTargetCube)=0);
CubeCreate (sTargetCube,sClientDim,sClientMemberDim);
endif;

#—————————————–
# create dimension hierarchy
#——————————————

#dimensiondeleteAllElements(‘ClientsMembership’);
dimensionelementInsertDirect( sClientMemberDim,”,’Sum’,’c’);
dimensionelementComponentAdddirect(sClientMemberDim,’Sum’,sGroup1,1);
dimensionelementComponentAdddirect(sClientMemberDim,’Sum’,sGroup2,1);

dimensiondeleteAllElements(sClientDim);
#————————————————————

# Below code should be in EPILOG
# check if client is member of group
#————————————————————-

i=1;
while(i<=dimsiz(sDim));
vClient=dimnm(sDim,i);
if(long(attrs(sDim,vClient,’}TM1_DefaultDisplayValue’ ))>0);
vClientName=attrs(sDim,vClient,’}TM1_DefaultDisplayValue’ );
else;
vClientName=vClient;
endif;

if(cellgets(sCube, vClient, sGroup1) @=sGroup1);
dimensionelementinsertdirect(sClientDim,”,vClientName,’n’);
cellputn(1,sTargetCube,vClientName, sGroup1);
endif;

if(cellgets(sCube, vClient, sGroup2) @=DimensionElementPrincipalName(  ‘}Groups’,sGroup2 ) );
dimensionelementinsertdirect(sClientDim,”,vClientName,’n’);
cellputn(2,sTargetCube,vClientName, sGroup2);
endif;

i=i+1;
end;
#——————————————————————
# end of code
#——————————————————————

 

List license usage of TM1 with the TM1S.CFG parameter LicenseMetricTime

LicenseMetricTime=00:14:36

The file is created under the folder \ C:\Program Files\ibm\cognos\tm1_64\slmtagraw.

File name is IBM Cognos TM1_10.2.0_medlem register20150113200502294.slmtagraw , see the content of this file last in this doc.

 

Based on the little documentation that exists (i.e. in the .cfg file), I believe this will generate an XML file for the ILMT tool to pick up which is required for sub-capacity license monitoring.

 

NOTE: ILMT https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM+License+Metric+Tool

is IBM software which is free and is required when PVU licensed software has been installed on a Virtual environment.

# LicenseMetricTime
# Sets the time of day the TM1 server will generate a License Metric Tag file.
# A License Metric Tag file is an XML file which contains information about license metrics consumed by software product instances.
# In the case of TM1 server, the reported authorized user metrics are the number of Modelers, Contributors and Explorers.
# The License Metric Tag files produced by various instances of TM1 servers are collected by the IBM License Metric Tool (ILMT) agent and aggregated to produce final metrics based on the TM1 product version.
#
# The format of the LicenseMetricTime parameter is dd:hh:mm where:
# * dd is the number of days from today that the system will start automatically producing License Metric tag files. For example, 00 is today, 01 is tomorrow.
# * hh:mm is the time of day in 24-hour format.
# Type: optional, dynamic
LicenseMetricTime=00:14:36

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg21959520&myns=swgimgmt&mynp=OCSS9RXT&mync=E&cm_sp=swgimgmt-_-OCSS9RXT-_-E

Use AUDIT logging to find when users are logged into the Applications.

You want to enable audit logging for the TM1 server, process the audit log, and review the details of the audit log.

 

This shows how to use the audit log, for your or use any TM1 server that you have available.

 

Open Windows Explorer, and then navigate to Tm1 folder for your application or the example application GreatOutdoors

Open the tm1s.cfg file in Notepad.

You want to enable the audit log and specify how frequently this log is to be updated.

Set the value of the AuditLogOn parameter to T.

Set the value of the AuditLogUpdateInterval parameter to 60.

The AuditLogUpdateInterval indicates the amount of time, in minutes, that TM1waits before moving the events.  The events are moved from the temporary audit file into the final audit log.

Save the file and close Notepad.

 

You may need to restart your TM1 applications service to make the changes in TM1S.CFG to take affect.

 

From the Start menu, point to All Programs\IBM Cognos\TM1, and then click Architect.

Expand TM1, and then double-click greatoutdoors.

You are prompted to log on to the GreatOutdoors TM1 server.

In the UserName box, type admin, leave the Password box blank, and then click OK.

Ensure that greatoutdoors is selected, and then from the Server menu, click Process Audit Log Events.

You are prompted to update the audit log with the latest events.

Click Yes, and then from the Server menu, click View Audit Log.

The Audit Log window opens.

Click Run Query.

The Results section of the Audit Log window shows a list of audit events.

You can further refine your results by choosing a different time period, as well as by specifying the event owner and type.

Close the Audit Log window.

 

Export the Audit log to Excel for further processing.

 

More Information on the file:

<?xml version=”1.0″ encoding=”UTF-8″?>

<LicenseMetrics version=”0.1″

xmlns=”http://www.ibm.com/xml/ns/licensemetrics”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”

xsi:schemaLocation=”http://www.ibm.com/xml/ns/licensemetrics licensemetrics.xsd”>

<Product>

<ProductName>IBM Cognos TM1</ProductName>

<ProductVersion>10.2.0</ProductVersion>

<ProductId type=”guid”>4acad4f5525b4bd0a78723fcd6cd6154</ProductId>

<InstanceId type=”installation_path”><![CDATA[C:\Program Files\ibm\cognos\tm1_64\bin64]]></InstanceId>

<InstanceName><![CDATA[medlem register]]></InstanceName>

</Product>

<Metrics>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group ADMIN is a modeling group: The predefined admin group ADMIN is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group DataAdmin is a modeling group: The predefined admin group DataAdmin is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group SecurityAdmin is a modeling group: The predefined admin group SecurityAdmin is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group TESTGROUP is a contributor group: Group TESTGROUP has WRITE permission on cube ClientMemberships.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>Number of Modeling groups</SubType>

<Value>3</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>Number of Contributor groups</SubType>

<Value>1</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>Number of Explorer groups</SubType>

<Value>0</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>AUTHORIZED_USER</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[Admin]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[User Admin is a Modeler. Belongs to group ADMIN. The predefined admin group ADMIN is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>AUTHORIZED_USER</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[Roger]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[User Roger is a Modeler. Belongs to group ADMIN. The predefined admin group ADMIN is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>Number of Modeling users</SubType>

<Value>2</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>Number of Contributor users</SubType>

<Value>0</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>Number of Explorer users</SubType>

<Value>0</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

</Metrics>

</LicenseMetrics>

Product:
CDM version 10.2.4
Microsoft Windows 2008 R2 server

Symptom:
Can not log on to CDM, the user get this error after selection of server
“Säkerhetsförhandlingsfel”

Error message in log file:
2016-10-19 14:19:03,628 [4] ERROR Ibm.CognosDM.Api.PluginsManager – CDCGN00500E (null) Plugin DashboardPlugIn was loaded. ErrorFormat 0
2016-10-19 14:19:03,675 [4] ERROR Ibm.CognosDM.Api.PluginsManager – CDCGN00500E (null) Plugin Filing was loaded. ErrorFormat 0
2016-10-19 14:19:03,675 [4] ERROR Ibm.CognosDM.Api.PluginsManager – CDCGN00500E (null) Plugin TasksPlugIn was loaded. ErrorFormat 0
2016-10-19 14:19:20,993 [1] ERROR Ibm.CognosDM.App – CDCGN00025E ExceptionToken: Unknown [LayoutPersistErrorException] Error 0 System.NullReferenceException: Object reference not set to an instance of an object.
at Ibm.CognosDM.Storage.Bases.UserDataSetBase..ctor(String storageLocation, String user)
at Ibm.CognosDM.Storage.DataSetInstances.get_UserSettings()
at Ibm.CognosDM.App.ApplicationExit(Object sender, ExitEventArgs e)

Check this as first step:
Can you also reset the IIS to see if it helps? Type “iisreset” in a Command Prompt window.

If the issue still persist, can you check whether the SSL certificate for CDM is still valid in IIS?

1. From the Start Menu, launch “Administrative Tools – Internet Information Services (IIS) Manager”
2. Highlight ‘Default Web Site’ or the Server name in IIS.
3. Click ‘Bindings’ or click on ‘Server Certificates’ – there you see Expiration Date direct.
4. Highlight your entry for ‘https’ and choose ‘Edit’
5. Click ‘View’
6. Check the Valid from/to dates

In this case the Certificate on the IIS for the default web site had expiry.

Solution:
Insert a new valid Certificate on the IIS server.

1. In the Internet Information Services (IIS) Manager console, under
Connections, select your server name.
2. Double-click Server Certificates.
3. Click Import.
4. Browse to and select the SSL certificate.
5. Enter the password for the certificate, and click OK.
6. Under Connections, select the website where the CognosDM-Server virtual directory is located. For example, select default.
7. Click Bindings. Select the https type, and click Edit.
9. In the SSL certificate window, select the certificate you imported, and click OK.
10. Close the Site Bindings window.
11. Select the CognosDM-Server website application.
12. Double-click SSL Settings.
13. Ensure that Require SSL is selected, and select Ignore in the Client certificates section.
14. Click Apply.

More information:
http://www.ibm.com/support/knowledgecenter/SSQK59_10.2.3/com.ibm.swg.ba.cognos.cdm_ig.10.2.3.doc/c_cdm_ig_ssl_certificates.html

Product:
Cognos Controller 10.2.1 Fix Pack 4
Microsoft Windows 2012 R2 server

Symptom:
Error when importing csv file with data, that have worked fine in previous version of Cognos Controller 10.1. The DiscardedRows are the same number as the Rowsread in Log Reports dialog.

Error message:
The value must be numeric.

The data we try to import contain a decimal value; e.g. 000.00

Solution:
Log on to the Cognos Controller server as the service account that run the Cognos Controller services.
Go to controller panel
Go to regional settings
Change to England (UK)
Click tab ‘Location’
Change this to ‘English (United Kingdom)’
Click tab “Administrative”
Click “Change system locale…” and change this to “English (United Kingdom)”:
Click “Copy Settings”
Tick the box “Welcome screen and system accounts”.
Tick the box “New user accounts”:
Click OK
Reboot the Controller application server

I think it is the value of Decimal symbol need to be changed from comma to a period that solves the issue.

The csv file that is imported to controller must be of a specific format.
Text file should use decimal point (not comma) for decimals and semicolon (not comma or
tab) as delimiter between the data fields.

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

Product:
Cognos BI 10.2.2
Microsoft Windows 2012 R2 Server

Question:
How to easy see if Content manager is up?

Solution:
Enter this in Internet Explorer
http://localhost:9300/p2pd/servlet
Change to localhost to your BI server name.

You get a text similar to this:

IBM Cognos Content Manager

IBM Cognos

Content Manager

Build: 10.2.6105.4
Start time: Tuesday, November 8, 2016 9:11:15 PM CET
Current time: Tuesday, November 8, 2016 9:21:28 PM CET
State: Running

More url you can use for testing:
# Get Dispatcher version
http://localhost:9300/p2pd/servlet/gc

# Determine if Content Manager is running
http://localhost:9300/p2pd/servlet

# Determine if Dispatcher (“pogo”) is alive
http://localhost:9300/p2pd/servlet/dispatch?b_action=/dbg

# View installed components
http://localhost:9300/p2pd/servlet/dispatch?b_action=cmplst

# Memory utilization
http://localhost:9300/p2pd/servlet/dispatch?b_action=/diagnostics

# Environment
http://localhost:9300/p2pd/servlet/dispatch/env

# Get load balancing statistics. Can also use this to verify the configuration of an install.
http://localhost:9300/p2pd/servlet/dispatch/p2plbDiag

# Pin requests for load balanced services to a specific Dispatcher (need to be logged in first)
http://localhost:9300/p2pd/servlet/dispatch/pin

# See if the Certificate Server is responding
http://localhost:9300/p2pd/servlet/dispatch/autoCAService

# Give some info if service is up — but that is easier to find with other command.
http://localhost:9300/p2pd/servlet/dispatch/testping

This is what you get with testping:

<?xml version=”1.0″?>

<SOAP-ENV:Envelope SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/” xmlns:bus=”http://developer.cognos.com/schemas/bibus/3/” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/”><SOAP-ENV:Header><bus:biBusHeader xsi:type=”bus:biBusHeader”><bus:tracking xsi:type=”bus:tracking”/><bus:dispatcherTransportVars xsi:type=”SOAP-ENC:Array” SOAP-ENC:arrayType=”bus:dispatcherTransportVar[]”><item xsi:type=”bus:dispatcherTransportVar”><name xsi:type=”xsd:string”>p2plb_result</name><value xsi:type=”xsd:string”>ok</value></item><item xsi:type=”bus:dispatcherTransportVar”><name xsi:type=”xsd:string”>p2plb_messagetimes</name><value xsi:type=”xsd:string”>1478636020024,1478636020024,1478636020024,0</value></item></bus:dispatcherTransportVars></bus:biBusHeader></SOAP-ENV:Header><SOAP-ENV:Body><l:p2plbPingResponse status=”ok” xmlns:l=”http://developer.cognos.com/schemas/p2pd/lb/1/”/></SOAP-ENV:Body></SOAP-ENV:Envelope>

# XML Parser Information
http://localhost:9300/p2pd/servlet/dispatch/xts.diag

# Determine if the SDK is installed by having the Dispatcher access the SDK WSDL file
http://localhost:9300/p2pd/servlet/dispatch?wsdl

# About IBM Cognos Connection
http://localhost:9300/p2pd/servlet/dispatch?b_action=xts.run&m=portal/about.xts

 

More information:

http://www.cogknowhow.com/index.php/knowledge-articles/36-tools/105-jvm-memory-utilization

https://community.watsonanalytics.com/discussions/questions/23687/what-diagnostic-urls-are-available-with-cognos-ana.html

Product:
Cognos TM1 10.2.2 café
Microsoft Windows 2012 R2 server

Symptom:
How setup CAFÉ on server so accessible from workstations?

Solution:
In PMHUB enter the name (server name) of the TM1 server in the HOST value for com.ibm.ba.pm.resource.tm1.dictionary.

This value is shown for the CAFÉ user when they try to login.
Default value is localhost.

To get to PMHUB surf to http://servername.domain.com:9510/pmhub/pm/admin

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