Vlad Didenko

Google Chrome Show bookmarks bar greyed out

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.

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 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”

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”

Windows 10 Custom user profile name, Another user on this device uses this Microsoft account, so you can't add it here

This post is about how to create a custom user profile name (instead of the first 5 characters from your Microsoft Account name) and how to delete the existing profiles, which is needed if you previously created a profile using your Microsoft Account and now want to delete that profile. Creating a custom user profileContinue reading “Windows 10 Custom user profile name, Another user on this device uses this Microsoft account, so you can't add it here”

CMD list folders and file sizes, find the largest folders and files

Quite often we need to check which folder is taking the most space, here is one a line cmd command to do this: List folders from the smallest to the largest cmd /v /c “set zeropad=000,000,000,000,000,&for /f “delims=” %a in (‘dir /ad /b’) do @set bytes=!zeropad!000&(for /f “tokens=3” %b in (‘dir /s “%a” 2^>NUL ^|Continue reading “CMD list folders and file sizes, find the largest folders and files”

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”