TM1 Server Memory Diagnostic Playbook This playbook discusses select scenarios for TM1 Server memory consumption and growth and will provide guidance on how to diagnose causes of TM1 Server memory growth and an understanding of how TM1 Server has allocated memory. The following provides guidance on capturing logs/data/usage and techniques for identifying causes for TM1Continue reading “TM1 Server Memory Diagnostic Playbook”
Category Archives: Cognos TM1
IBM Cognos Analtyics caching data issues when reporting on PA (TM1) cubes
Using CA 11.0.10 and PA 2.0.3 I was building a CA report fetching some numeric and text data from TM1 cube, I encountered an issue with comments (text values), when I change some comment in TM1, the CA report either still shows the old value or the comment completely disappears. I tried to clear theContinue reading “IBM Cognos Analtyics caching data issues when reporting on PA (TM1) cubes”
IBM Planning Analytics / TM1 DebugUtility
There is undocumented function DebugUtility which is usually used by IBM support to perform different actions. Here are some examples what you can do: ## Wipe TM1 cache for all cubes DebugUtility( 125, 0, 0, ”, ”, ” ); ## Wipe TM1 cache for the specified cube DebugUtility( 125, 0, 0, ‘CubeName’, ”, ” );Continue reading “IBM Planning Analytics / TM1 DebugUtility”
Perspectives Action button – recalculate before running TI process
If you have an action button in your TM1 Prespectives report that runs some TI and that TI uses the entered values in the given Perspectives report, the sheet needs to be recalculated in order those values to be available in the TI process. Simply go to action button properties, open Calculate tab and selectContinue reading “Perspectives Action button – recalculate before running TI process”
TM1 division operator (backwards slash)
In TM1 even though you can use both “” (back slash) and “/” (forward slash) for division, it’s highly recommended to use the first one – “” (back slash). The difference: “/” (forward slash): Division by zero using this operator returns an undefined value. “\” (back slash): Division by zero using this operator returns zero.Continue reading “TM1 division operator (backwards slash)”
TM1 – (TR3117) Unable to retrieve security objects. Please verify credentials.
You may get “(TR3117) Unable to retrieve security objects. Please verify credentials” while connecting from TM1 to for example SAP BW. Basically TM1 uses old good Transformer to get the data/metadata. This error means the username/password are incorrect. Usually it happens when user’s password get changed. To update the password, open your TI process, goContinue reading “TM1 – (TR3117) Unable to retrieve security objects. Please verify credentials.”
TM1 attribute cube rule
If you create any dimension attributes, TM1 will create “}ElementSecurity_” cube to store the attribute values. You can use it cube almost like a regular cube (there are just little restrictions). For example you can create a rule to calculate some attributes. This approach can be used to allow users to edit element attributes inContinue reading “TM1 attribute cube rule”
TM1Web 10.2 + CAM security – Multiple URLs for different TM1 servers.
http://didenko.ca/blog/wp-content/plugins/syntax-highlighter-compress/scripts/shBrushJScript.js In this post I will explain how to enable multiple TM1Web URLs for different TM1 servers. In my example, TM1 is configured to use CAM security (IntegratedSecurityMode=5). But you can follow similar steps for other security modes. The result I needed to achieve was to be able to access TM1ServerName1 using the URL likeContinue reading “TM1Web 10.2 + CAM security – Multiple URLs for different TM1 servers.”
IBM Cognos Framework Manager: Show Object Dependencies and Analyze Publish Impact
You can find objects that depend on other objects, or show the dependencies of a child object. Simply right-click any object and choose Show Object Dependencies. NOTE: if you need to find a query item dependencies you should check it for both the query item and query subject contains that query item. Because if thereContinue reading “IBM Cognos Framework Manager: Show Object Dependencies and Analyze Publish Impact”
TM1 Server does not show up in clients (Architect, Perspectives, TM1Web)
Noticed in TM1 10.2.2 If trying to connect to TM1 Server from network, it does not show up in the list of available servers. However TM1 Server is visible in a local client. Make the next changes in IBM Cognos Configuration where TM1 Admin Server is installed: Support pre-TLS v1.2 clients = True Restart TM1Continue reading “TM1 Server does not show up in clients (Architect, Perspectives, TM1Web)”
Cognos/TM1 