Create a new Turbo Integrator Process For now we won’t set the data source for the TI Process because we want this to be a Cube View that we create as the first step (Prolog procedure). So the first thing is to create the view and assign dimensions subsets which will filter the rows of the data source that we will be sending into the source system. An example of … Continue Reading
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 are very different front ends. Advisor This is Executive Viewer put behind the Data Package … Continue Reading
There are four ways to maintain a dimension within TM1: Backend Editor Dimension Worksheets TI Process TM1 API (Possibly via 3rd Party tools) Most consultants previously recommended using Dimension and Rule Worksheets prior to recent releases of 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 … Continue Reading
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 2003 or Excel 2007 has been installed Open the setup file ‘setup.exe’ Select your language … Continue Reading
Hi Here’s a link to my preferred MDX source on the web: www.bihints.com Wim Gielis
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.
Ok in this quick tutorial I’m going to demonstrate how you would go about creating a TI Process which retrieves information from a source system. At my latest clients site we have a process which retrieves actual journals from PeopleSoft just from drilling on aggregate actual data. How it works: 1) The Drill Button – TM1 Cube viewer / Excel Slice / TM1 Web When you right-click on a cell … Continue Reading
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 Development – pre .net).
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 – how data is entered.
To begin download the latest version of TM1 from the ‘My-IBM’ site. You will need a login to access the site. (http://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 install you should probably check your computer/server has everything needed to install TM1 I’ll break … Continue Reading