When the option to show/unshow the bookmark bar in Chrome is greyed out (on Windows), run REGEDIT, and delete the key ‘ComputerHKEY_LOCAL_MACHINESOFTWAREPoliciesGoogleChromeBookmarkEnabled’. Restart chrome and then you can use the key combo CTRL-SHIFT-B to show or unshow the bookmark bar.
Category Archives: Cognos
TM1 Server Memory Diagnostic Playbook
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”
Deleting empty rows – reset the last used cell in Excel
As you may know Excel file stores only the rows and columns up to the last one containing some data or formatting. So if you select the last cell (row = 1,048,576 rows and column 16,384 ) and enter same value and save the file, you might come up with some huge file size. AllContinue reading “Deleting empty rows – reset the last used cell in Excel”
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”
Configuring MTQ (Multi-Threaded Query) with IBM Cognos TM1
As of TM1 version 10.2, a new feature known as “multi-threaded queries”, or MTQ, is available. MTQ allows TM1 to take advantage of multiple processor cores to significantly increase the speed at which TM1 can perform calculations and queries by allowing queries to split into multiple processing threads, effectively using a parallel processing regime toContinue reading “Configuring MTQ (Multi-Threaded Query) with IBM Cognos TM1”
TM1 cube weird fed values without feeders causing incorrect rule calculation
If wonder why some leaf cells are fed even you do not have any feeder, you might troubleshoot it by following the next steps: 1. Stop TM1 server and delete all feeder files, then start TM1 server. This way you ensure all feeders are cleared from TM1 cache (yes TM1 caches feeders and show cellsContinue reading “TM1 cube weird fed values without feeders causing incorrect rule calculation”
Loading data and metadata from SAP BW into TM1 using Cognos Package Connector FAQ
It’s been several years I’m dealing with SAP BW in TM1. Though I went through a ton of errors and PMRs opened with IBM, I’m still facing new issues in my everyday work and I know the end will never come. I created this post to summarize the most critical moments and “how-to”. In allContinue reading “Loading data and metadata from SAP BW into TM1 using Cognos Package Connector FAQ”
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”
Run program as administrator in Windows without credentials or consent prompt
First of all this way is not recommended to implement on machines in a corporate network, but if you just want to disable that prompt on your personal home computer where you have less security requirements and understand programs you are running, this method will work for you. Disable prompting for consent / credentials whenContinue reading “Run program as administrator in Windows without credentials or consent prompt”
Notepad++ plugin manager & handy plugins
If Plugin Manager is missing in Plugin menu, you can install it manually. Download and unzip it. Place PluginManager.dll file in the Notepad++ plugins directory Place gpup.exe file in the updater directory Restart Notepad++ Enjoy! Some useful plugins: JSTool (format JSON data)
Cognos/TM1 