Product:

IBM Cognos Tm1 10.1.1 (version PLANANALYTICS-AW64-ML-RTM-10.1.7000.91-0)

PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0 ( TM1 fix pack1)

Windows 2008 R2 server

Symptom:

Inside Tm1web, you click on export icon and select export to pdf.

Select a Choose number of rows to export:

Select a Choose dimension titles to export:

click OK

Gives error message;

Error message:

Export in process. Please wait…

Error while Printing to PDF: No printers are installed. To install a printer click the File tab, and then click Print. Click No Printers Installed, and then click Add Printer. Follow the instructions in the Add Printer dialog box.

 

Cause:

The windows service account that is set for the IBM Cognos TM1 Excel Service, is not the same account used when installing TM1 server ( and the pdfcamp printer driver ).

 

Solution:

Stop IBM Cognos TM1 Excel Services

Uninstall the pdfcamp printer driver by run, D:\Program Files\ibm\cognos\tm1_64\bin\PDFCamp\unpdfx64.exe

Log off the TM1 server

Login to the TM1 server with the windows account that is use to run the TM1 Excel service.

Install the pdfcamp printer driver by run. D:\Program Files\ibm\cognos\tm1_64\bin\PDFCamp\setupx64.exe

Now the printer driver is there for the user running the service.

Set the PDFcamp Printer as default printer.

Start the IBM Cognos TM1 Excel Services.

Log off the server.

Test the TM1web function export to pdf.

Product:

IBM Cognos TM1 10.1.1

Windows 2008 R2 server

 

Problem:

How do I start TM1TOP on the server?

 

Solution:

There is different ways to start the TM1top application.

 

One is to start it direct from an CMD dialog.

Log on to TM1 server.

Right click on Command Prompt and select Run as Administrator.

Enter the following line (after you change the path to yours) and press enter

 

“d:\program files\ibm\cognos\tm1_64\bin64\tm1top.exe” -servername “tm1planning”

 

Change tm1planning to the name of your tm1 application e.g. planning sample.

If you have made a TM1TOP.INI file you want to use and placed it in folder TOPTEMP you can use this command:

 

“d:\program files\ibm\cognos\tm1_64\bin64\tm1top.exe” -i  d:\toptemp\tm1top.ini

 

A different way to do it is to copy the TM1TOP.EXE and TM1TOP.INI files in a folder call d:\toptemp

Then you need to add path to TM1 bin folder in you path on the server.

Right click on Computer icon and select properties

Click on Advanced System Settings

Click on Environment Variables

Scroll down system variables and select PATH

Click on Edit

At the end of the variable value add;

;d:\program files\ibm\cognos\tm1_64\bin64

Click OK

Click OK

Click OK

 

Go to the d:\toptemp folder in windows explorer

Click on the tm1top.exe file to start tm1top application.

 

The TM1TOP.INI file should have this values

 

adminhost=windowsservername

servername=tm1planning

logfile=tm1topplanninglog.txt

logappend=t

refresh=2

logperiod=10

 

(Important to not have any spaces in above tm1top.ini file)

adminhost=the name of the windows server where tm1 admin service are

servername=the name of the tm1 application

logfile=the name of the logfile you want to create

logappend=True to add error messages to the file every time you start the tm1top

refresh=2 seconds between updates on the screen

logperiod=10

 

Logperiod Specifies the time interval between updates being written to the log file, in seconds.

Setting this to zero disables logging.

For example, if the screen Refresh is set to 2 seconds, LogPeriod could be set to 10 seconds so that every fifth screen display will be output to decrease the amount of data written to the file.

The default value is 2 seconds.

 

The different commands in TM1TOP window:

 

N = Displays TM1 Top normal (thread status) mode.

S = Displays TM1 Top sandbox mode.

Q = Displays TM1 Top queue mode.

W = Writes the current TM1 Top information to a file.

X = Exits the TM1 Top utility.

H = Displays help text.

V  = Verifies a TM1 Top administrator session.

Displays a user name and password prompt so the TM1 administrator can log into the current session of TM1 Top and enter commands to cancel processing in other threads.

 

C = Cancels processing in another thread.

Note: Before using the Cancel command, an administrator must first log into the current session of TM1 Top by using the V (Verify) command.

 

K = Cancels a sandbox submission in the job queue for a specific job ID number.

Requires administrator login with the V (Verify) command.

 

Up, Down arrow keys = Use the up and down arrow keys to scroll the status display if there are more lines in the status than the height of the console window.

 

 

More Information

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_op.10.1.1.doc%2Fc_usingthetm1toputility_n160f47.html

Product:

Cognos TM1 10.1

Windows 2008 R2 Server

 

Symptom:

Start a new TM1 server and try to connect to it with the TM1 Architect program.

You get a error after you have enter name and password.

 

Error message:

The specified server is not found

 

Solution:

If the error message “The specified server is not found” is before the login dialog in TM1 Architect then the local firewall is blocking the TM1 port.

 

Go to Windows Firewall with Advanced Security

Go to Inbond rules

Create a rule to allow local TCP port “12346” to any ip address.

Enable it and restart the firewall.

 

If the error message “The specified server is not found” is after the login dialog in TM1 Architect then there is some other process using the same port.

 

Stop the TM1 service.

Open Tm1s.cfg in notepad

Check the port number used by TM1 application server at line PortNumber=12346

Start a commando prompt (cmd)

Enter netstat to find if that port is in use by enter below command:

netstat -a | find “12346”

 

If no row is shown, then the port is free to use.

 

If you see below row – then it is occupied, and you need to use other port.

TCP 0.0.0.0:12346     SERVERNAME:0    LISTENING

 

Change if needed port in TM1S.CFG and start the TM1 service.

 

More Information:

If you move a TM1 application to a new server, you need to check this lines in the TM1s.cfg file to ensure they point to the correct value for the new environment.

 

IntegratedSecurityMode=5 You can try mode 1 if you have problems to login.

ServerName=  Should be the same, the name of the TM1 application in architect

DataBaseDirectory= Should be the folder path to the datafiles (often same as before)

LoggingDirectory= Should be the folder path to the logfiles (often same as before)

AdminHost= Should be the new TM1 admin servername

PortNumber= Should be the same number, if it is available on the new server

ServerCAMURI= Should be changed to the new Cognos BI server’s dispatch address

ClientCAMURI=  Should be changed to the new Cognos BI server’s gateway

Product:

Cognos TM1 10.2

PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5000.367-0

LICENSE_TM1_version=LICENSE_TM1-AW64-ML-RTM-10.2.5001.0-0

Windows 2008 R2 Server

Cognos BI

Symptom:

Can not login to Cognos TM1 when using CAM security.

It works when using the TM1 native security.

Error message:

The forward URL does not exist or it has failed validation. Ensure that a valid forward URL is specified.

Cause:

The file variables_tm1.xml is on the wrong BI server.

 

Solution:

Copy your updated variables_tm1.xml file to all your Cognos BI servers in your solution.

Place the file in folder \\biservername\d$\Program Files (x86)\ibm\cognos\c10_64\templates\ps\portal

 

In short is the installation to get CAM to work for TM1 10.2 web different from previous version.

 

Unzip the D:\Program Files\IBM\cognos\tm1_64\webapps\tm1web\gateway_files\ tm1web_gateway.zip files.

Rename d:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\gateway_files\tm1web_gateway\templates\ps\portal variables_TM1.xml.sample to variables_TM1.xml.

Update variables_tm1.xml with the TM1 server name at line 23 instead of localhost:

<CRNenv>

<urls>

<url is-regex=”true”>http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebLogin.aspx</url>

<url is-regex=”true”>http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebLoginHandler.aspx</url>

<url is-regex=”true”>http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebMain.aspx</url>

<url>../tm1/web/tm1web.html</url>

</urls>

<cookies>

<param name=”cam_passport”/>

</cookies>

</CRNenv>

 

Update the tm1web.html file to Cognos TM1 Web server name at line 40:

// Update the following to point to the location of the TM1Web service(s)

var tm1webServices = [“http://localhost:8080”];

Change to:

var tm1webServices = [“http://tm1servername:9510”];

 

Copy the files to your Cognos BI installation:

variables_TM1.xml = Copy to d:\Program Files\ibm\cognos\c10_64\templates\ps\portal templates\ps\portal on your Cognos BI report server and content manager server.

Tm1web.html = Copy to d:\Program Files\ibm\cognos\c10\webcontent\tm1\web on your Cognos BI gateway server.

 

In tm1s.cfg file you need for each TM1 application add the values for:

 

ServerCAMURI=http://biservername:9300/p2pd/servlet/dispatch

ClientCAMURI=http://biservername/ibmcognos/cgi-bin/cognosisapi.dll

ClientPingCAMPassport=900

CAMPortalVariableFile=portal\variables_TM1.xml

DistributedPlanningOutputDir=.\tunit

ForceReevaluationOfFeedersForFedCellsOnDataChange=T

AllowSeparateNandCRules=T

 

The value CAMPortalVariableFile is not needed in the TM1S.CFG file for tm1web to work.

 

More (same) Information:

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.2.0.doc%2Ft_tm1_inst_tm1web_cogsecurity.html

Product:

Cognos TM1 10.1.1

Windows 2008 R2 server

Cognos BI 10.1.1 CAM security

Symptom:

When you surf to TM1 application web you get a error when you try to sign in.

(http://biserver.domain.se/ibmcognos/cgi-bin/cognosisapi.dll?…)

You have upgrade or installed a new TM1 10.1.1 server and connected it with a existing Cognos BI installation.

Error message:

PRS-PRH-0221

The file “portal\variables_plan.xml” could not be opened.

Cause:

The variables_plan.xml file is not on the correct location on the Cognos BI server.

 

Solution:

On the TM1 server find the folder D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\gateway_files

Unzip the file planning_gateway.zip to your Cognos BI server and your Cognos BI gateway server.

 

This should give that the files come to this folders:

planning.html  should in folder …\c10\webcontent

variables_plan.xml should in folder …\c10\templates\ps\portal

icon_active_application.gif  should in folder …c10\webcontent\ps\portal\images

Update the planning.html file to contain the name of the TM1 server at line 38

…

// Update the following to point to the location of the planning service(s)

var planningServices = [“http://tm1server.domain.se:9510”];

…

 

More information:

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.1.1.doc%2Ft_depl_tm1_cont_admin.html