InfoCube and Daptech to Merge
InfoCube, a Sydney-based management accounting and business analytics specialist, and enterprise planning software experts Daptech will merge their businesses to create InfoCube Consulting (Australia) Pty Ltd. Commencing trading on July 9, the new entity will continue to provide clients such as Woolworths, Goodman Fielder, News Limited, Schneider and Hunter Douglas with superior Cognos service and […]
News & Announcements – June 2012
IBM Business Analytics User Group (Mid-June) A great way to see what is happening right now in the IBM Business Analytics space. Our Team are all registered for the Sydney User Group next week. Register now, stop by and say hi. “The IBM Business Analytics User Group (BAUG) is for users of IBM Cognos, SPSS, […]
TM1 to Cognos Express Translation
Just thought I would write up a small but simple translation guide for the TM1 Experts who are now diving into the new world of Cognos Express. Xcelerator This is the new name for the TM1 Excel Add-in and also the new name for TM1 Web. This can cause some confusion since TM1Web and Perspectives […]
Dimension Maintenance Methods
There are four ways to maintain a dimension within TM1: Most consultants previously recommended using Dimension and Rule Worksheets prior to TM1 9.1 where the User Interface has been updated, presently there is no defined best practice and opinions are divided. Backend Dimension Editor Dimension Worksheets TI Process Pro Con Pro Con Pro Con Quick […]
Installing TM1 9.5
Heres a quick tutorial on how to install TM1 9.5, after these instructions are the same instructions with images to aide in the installation process. Please leave a comment if this helps or if I have missed a step. Installing TM1 9.5 Make sure Microsoft IIS is installed with the latest ‘.net’ framework Make sure Excel […]
Compare data directories
I made this recently to compare two TM1 Data Directories. Its rather self explanatory. The Inputs are: Path to Production Path to Dev And with this it produces a list of all files that are in one but not in the other.
API CellGet Function
Please be aware that this code is not some of my better work, its from about 2 years ago from a pet project of mine. Enjoy. In Sumary this code connects to a server to get a value from a Cube, then disconnects. (This is not very efficient but shows all fundamentals of TM1 API […]
Adding Financial Local/Group Currency Logic
The purpose of this article is to describe how to add a Local/Group Currency system to a new TM1 cube; this can be core requirement for International Companies and is relatively common. To explain the Group/Local split, Group – the company’s home country currency – used primarily for Reporting Local – the branch/profit-centre’s currency – […]
Installing TM1 9.4
To begin download the latest version of TM1 from the ‘My-IBM’ site. You will need a login to access the site. (https://www-01.ibm.com/software/data/cognos/) At the time of writing this the most current version of TM1 is 9.4 MR1 with FP2 being the latest hot fix. Once you have downloaded the version of TM1 you wish to […]
Adding Items to the TM1 Web Right Click Menu
Within the TM1Web/Scripts folder open the ‘tm1webbook.js’ file within notepad or the preferred editor. You should probably create a backup of this file before making any changes. 1. The Menu Item ID Press “ctrl+F” to bring up the find dialog – search for “var COPY” On a blank line here create a name for your button […]
Naming Conventions and Syntax
Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public Subsets, Processes, Chores and Applications are all named on creation. All too often naming conventions are disregarded within the initial development stages of a TM1 implementation. Usually an attempt is made to bring these in at a […]
Dimension Worksheets
Dimension Worksheets are a great way to manage medium sized dimensions and attributes/aliases. All Worksheets (Dimension and Rule) are held in the local data directory set in the ‘Options’ form found in Server Explorer under ‘File’. To create a new Dimension via Dimension Worksheets
Modifying a Dimension – Backend Editor
There are a few ways to update a dimension within TM1, the first is the simplest and most commonly used. To update a Dimension using the Dimension Editor: Right Click on the Dimension Click “Edit Dimension Structure” Right Click any where and click “Insert Element” Type the name of the element Check the […]
API Tutorial (not .net)
TM1 API Programming – Initial Steps: At the start of a TM1 API project a few steps are necessary to get connected, 1. Include the TM1 API Module 2. At the Beginning of the Project use the ChDir and ChDrive function and set the Selected Directory to the Directory that contains TM1api.dll or put the bin dll […]
TM1 Security (Pre 9.4)
Overview Security within TM1 is limited to assigning a client to a group then a group to one or many levels and selections of objects. The levels of objects are: Tier 1: Cubes Applications Processes Chores Tier 2 – Dimensions Tier 3 – Elements Tier 4 – Cube Cells/Intersections of Elements The level based security […]
TM1 in a Unix Environment
Over the last 2 years more and more companies have looked at going 64-bit as their complex business modelling requires much more from a hardware perspective for TM1. TM1 supports two 64-bit Operating Systems these are UNIX and Windows 64-Bit. Since it’s more than likely that the admin users of TM1 are used to working […]
TM1 9.4 Presentation
Attached is the presentation I did for the Sydney TM1 Usergroup organized by Amendra Pratap. This covers most of the new 9.4 features.