When publish from FAP program to TM1 cube with a Windows account you cannot login PDF Print E-mail
Written by Roger   
Thursday, 10 March 2016 13:32

Cognos Controller 10.2.1
Cognos TM1 10.2.2
Cognos BI 10.2.1

When publish from FAP program to TM1 cube with a Windows account you cannot login. But same account work when you access the TM1 cube from TM1 Architect.

TM1 and Controller are using CAM authentication against a BI server that is connected to the Company’s Active Directory.
The windows user account is in a different sub domain, than the TM1 and Controller servers, that are in an other sub domain in the Company Active Directory.
The FAP program cannot add sub domain information at login, as you can when you login to TM1 Architect.
If you use a Windows account that is in the same sub domain as the TM1 server, then the login works.

Check the name space connection string at the Cognos Configuration on the BI server. It should point to the top of the AD domain. If it point to a single AD server in the domain, that server cannot have access of the whole AD, and therefor miss the account. This because the sub domain info is not passed on from the FAP program.
Ensure that the AD connection point to the top of the domain, or to a load balancer in front of the AD servers.




How do I change the Cognos Analysis For Excel to be in English? PDF Print E-mail
Written by Roger   
Thursday, 10 March 2016 13:29

IBM Cognos TM1 10.2.2 CAFÉ
Cognos for Microsoft Office

In Citrix we have Microsoft Excel installed with English menu, but when a Swedish user login to Citrix server session, and then regional settings are in Swedish, and then the CAFÉ menu inside Excel are in Swedish. How do I change the Cognos Analysis For Excel to be in English?

CAFÉ menu dialog is controlled by Regional Settings.
You need change the Regional Settings to English to get English menu in CAFÉ.

If it is not desirable, you can change the name of the folder where the Swedish language files are, so the CAFÉ program will default to the English menus. Then you can keep local language in Regional Settings.

On the citrix server change the folder c:\program files (x86)\ibm\cognos\cognos for Microsoft office\sv  to be sv_notused.


How to get the advance Rules editor to work in 32-Bit TM1 Architect version 10.2.2? PDF Print E-mail
Written by Roger   
Thursday, 10 March 2016 13:18
Cognos TM1 10.2.2 TM1 Architect
Windows 2012 R2 Server

When open Advance Rule Editor in TM1 Architect 10.2.2 (64 bit) you get a MS error when you click on Validate icon, and then the TM1 Architect crash and you need to close it.
Inside ARE you have no name of the rule in the top toolbar, this is a sign that you are in the wrong version of TM1 Architect.

How to get the advance Rules editor to work in 32-Bit TM1 Architect version 10.2.2.

1) Verify that parameter AdvancedRulesEditor = T has been correctly set in the right tm1p.ini, which should resides in "C:\Users\<username>\AppData\Roaming\Applix\TM1"

2) Verify that the following component is installed:
Microsoft Visual C++ 2005 SP1 Redistributable Package (x64 or x32 depending on the OS version)

3) Verify that the following component is installed:
Microsoft .NET 3.5 SP1 Framework

In Server Manager, click Manage and then select Add Roles and Features to start the Add Roles and Features Wizard.
On the Select installation type screen, select Role-based or feature-based installation.
Select the target server.
On the Select features screen, check the box next to .Net Framework 3.5 Features.
On the Confirm installation selections screen, a warning will be displayed asking Do you need to specify an alternate source path?. If the target computer does not have access to Windows Update, click the Specify an alternate source path link to specify the path to the \sources\sxs folder on the installation media and then click OK. After you have specified the alternate source, or if the target computer has access to Windows Update, click the X next to the warning, and then click Install.

4) Run the following MSDOS command from directory "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727" :
regasm.exe "<TM1_install_root>\bin\TM1RuleEditor.dll"

Start TM1 Architect from C:\Program Files\ibm\cognos\tm1_64\bin\tm1a.exe, to run the 32 Bit version.

5) If point 4 does not work, then retry with the /codebase parameter :
regasm.exe /codebase "<TM1_install_root>\bin\TM1RuleEditor.dll"

6) If nothing works, take a look at the installation log file in <TM1_install_root>\instlog. Its name should be isconfig-PLANANALYTICS-date_time.log or isconfig-TM1CLIENT-date_time.log :
verify that the registration of TM1RuleEditor.dll was OK.

7) Check whether this problem occurs on both Architect and Perspectives. If the problem occurs only with Perspectives then there must be some problem related to Excel installation. If so, then contact IBM Cognos Customer Support.

Important warning:
Advanced Rules Editor is no more supported since 10.1.1

- Supported environments ending with Cognos TM1 10.1.1 :

Cognos is ending support for the following environments and/or features in an upcoming release.
Components Advanced Rules Editor in TM1 Architect and TM1 Perspectives

- Deprecated and discontinued functionality in IBM Cognos TM1
Advanced Rules Editor in TM1 Architect and TM1 perspectives is no longer actively supported as of TM1 10.2 (note: capability is available "as is" in TM1 10.2)

When try to login to TM1 Application web (pmpsvc) you get an error 500 message PDF Print E-mail
Written by Roger   
Thursday, 10 March 2016 13:17


Cognos TM1 10.2.2
Windows 2012 R2 server

When try to login to TM1 Application web (pmpsvc) you get an error 500 message.
To surf to TM1WEB is works fine, and you can enter the TM1 application from TM1 architect.

Error message:
HTTP Status 500 -
type Exception report
message java.lang.NullPointerException
description The server encountered an internal error () that prevented it from fulfilling this request.
org.apache.jasper.JasperException: java.lang.NullPointerException

root cause

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.
Apache Tomcat/6.0.35

On the TM1 server – stop the IBM Cognos TM1 Application server.
In windows explorer go to folder C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\

Rename the file fpmsvc_config.xml to fpmsvc_config.xml.old
Rename the file fpmsvc_config.xml.new to fpmsvc_config.xml
Start the IBM Cognos TM1 Application server.

Surf to http://localhost:9510/pmpsvc
And enter new TM1 applications to the server.

The file fpmsvc_config.xml can have been corrupt when you added a new TM1 instance.


Values not shown in the cells that are not part of the TM1 Active Form PDF Print E-mail
Written by Roger   
Thursday, 10 March 2016 13:04


Cognos TM1 10.1.1 PLANANALYTICS-AW64-ML-RTM-10.1.7000.91-0
PLANANALYTICS_Update_name=IBM Cognos TM1
Windows 2008 R2

Values not shown in the cells that are not part of the TM1 Active Form in the TM1 WEB sheet.
They show nice in TM1 Perspective. But after uploaded to the TM1WEB, then there are no values.
The excel sheet is using Active Forms with formula
=TM1RPTROW($B$9;"FAP:S2.Account BS Items";"Kapital";;;;;;0)
And this at many places
=DBRW($B$9;$C$11;D$27;$C37;$B37;$C$14;$C$15;$C$16;$C$17 ;$C$18;$C$19;$C$20;D$25;D$26;$C$21;$C$12;$C$13;$C$22)
Then we added some new fields where we had this formula
=DBRW($B$9;$C$11;D$27;$C28;$B28;$C$14;$C$15;$C$16;$C$17 ;$C$18;$C$19;$C$20;D$25;D$26;$C$21;$C$12;$C$13;$C$22)
This cell only show the data value in Excel TM1 perspective but not on the web.

Enter the cube name in an empty cell.
Change the static (not Active Form) DBRW to point to that cell for the cube reference.
Then publish it to the TM1WEB then it works better.
New formula;
=DBRW($C$24;$C$11;D$27;$C28;$B28;$C$14;$C$15;$C$16;$C$17 ;$C$18;$C$19;$C$20;D$25;D$26;$C$21;$C$12;$C$13;$C$22)
The first ref is for the cube name.
DBRW function for Active Form and Static Cell cannot use the same CUBE cell reference, then it becomes wrong in the Converting to WEB BASED page.
Syntax Description:
DBRW(cube, e1, e2[,...en])
The arguments are described in the following list.
Cube The name of the database cube from which to retrieve the value.e1,...en
Dimension element names that define the intersection of the cube containing the value to be retrieved.
Arguments e1 through en are sequence-sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension, and so on. These arguments can also be the names of aliases for dimension elements.
Numeric element names must be enclosed in quotation marks.

http://www.ibm.com/support/knowledgecenter/SSHM9K_10.2.2/ com.ibm.swg.ba.cognos.ug_cxr.10.2.2.doc/r_cxr_dbrwfunction.html






CogKnowHow Newsletter

Please register to the site before you can sign for a list.
No account yet? Register