Cubewise

Category: CubewiseSource

  • IBM Cognos TM1 – Multi Threaded Queries (MTQ) in TM1 10.2

    What is a Multi-Threaded Query? Users may want to improve the processing performance of queries by allowing queries to split into multiple processing threads.Multi-threaded queries allow IBM Cognos TM1 to automatically load balance a single query across multiple cores. This can improve efficiency and processing time for large queries and rules. Problems Solved by IBM…

  • Determining the exact version of TM1 you have installed

    First, you will need to navigate to the root directory where TM1 is installed.  In later versions of TM1 the default install path is C:Program Filesibmcognostm1_64 In Windows Explorer navigate to this directory then find the bin64 folder or bin folder in client or older server installs.  Once in the bin folder follow these instructions:…

  • Things you might not know about TM1 security – Part 2

    There’s more to security than read, write and none although for most intents and purposes these are the only modes that matter from an end-user perspective.  However, for object security squeezed in between write and admin are two additional security levels; hold and lock.  These confer additional rights beyond write access to the object. Hold:…

  • Anti-virus scanning software and TM1

    Or have you ever sought to mitigate or prevent virus-scanner related performance issues by ordering scanning exceptions only to have your windows admin or security team scoff at you and refuse to take any action without something official in writing from IBM recommending excluding TM1 from virus scanning?  Many of us have probably been there.…

  • Things you might not know about TM1 Security – Part 1

    Have you ever wondered what the ReadOnlyUser field in the }ClientProperties  cube actually does?  This is a numeric property that takes Boolean values of either 1 (true) or 0 (false).  This property has been around at least since v9 and probably even before. It isn’t used very often (or even as often as it actually…

  • Deprecated and discontinued functionality in IBM Cognos TM1

    Functionalities that have been removed as per a particular IBM Cognos TM1 version are listed below, by version. Version           Feature/Functionality 10.2.1             IBM Cognos Executive Viewer version 10.2.1 would be the last version of this product (more information). 10.2            …