Meta

Month: November 2016

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.

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.

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.

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.

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.

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

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.