Sending Cube Data into a Database

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Database, Datawarehouse, DB2, ETL, MySQL, ODBC, ODBCOutput, Oracle, SQL Server, Turbo Integrator. Bookmark the permalink. | Tagged Database, Datawarehouse, DB2, ETL, MySQL, ODBC, ODBCOutput, Oracle, SQL Server, Turbo Integrator | Leave a comment

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 are very different front ends. Advisor This is Executive Viewer put behind the Data Package … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Cognos Express, TM1, Xcelerator. Bookmark the permalink. | Tagged Cognos Express, TM1, Xcelerator | Leave a comment

Dimension Maintenance Methods

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Dimension, Dimension Editor, Dimension Worksheet, TM1. Bookmark the permalink. | Tagged Dimension, Dimension Editor, Dimension Worksheet, TM1 | Leave a comment

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 2003 or Excel 2007 has been installed Open the setup file ‘setup.exe’ Select your language … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, Installation and tagged Installation, TM1 9.5. Bookmark the permalink. | Tagged Installation, TM1 9.5 | Leave a comment

MDX Primer Tutorial

Hi Here’s a  link to my preferred MDX source on the web: www.bihints.com Wim Gielis

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged BIHints, MDX Use. Bookmark the permalink. | Tagged BIHints, MDX Use | Leave a comment

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.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Data Directory, Migration, VBA. Bookmark the permalink. | Tagged Data Directory, Migration, VBA | Leave a comment

Drill-Through Processes

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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Drill Through, DrillRules, SQL, TM1, Turbo Integrator. Bookmark the permalink. | Tagged Drill Through, DrillRules, SQL, TM1, Turbo Integrator | Leave a comment

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 Development – pre .net).

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged API, TM1, VBA. Bookmark the permalink. | Tagged API, TM1, VBA | Leave a comment

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 – how data is entered.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Currency, Currency Conversion, Forex, Group Currency, Local Currency, Rules, TM1. Bookmark the permalink. | Tagged Currency, Currency Conversion, Forex, Group Currency, Local Currency, Rules, TM1 | Leave a comment

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. (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

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Installation, TM1 9.4. Bookmark the permalink. | Tagged Installation, TM1 9.4 | Leave a comment