Tag Archives: ETL

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged ETL, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged ETL, TI Process, Turbo Integrator, TurboIntegrator | Leave a comment

Automating Data Transfers between TM1 Servers

Replicating a Cube from a one TM1 Server into another has never been easier. Follow the steps below to copy a cube from one server to another (this includes synchronising TM1 Dimensions). This process uses the ODBO Provider for TM1 and generated MDX. I was going to show how to create an MDX Query for the desired cube but as it turns out you can select ODBO Cube as the data type … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged ETL, ExecuteProcess, IBM Cognos, IBM Cognos Express, IBM Cognos TM1, TI Process, TM1 Training, Turbo Integrator. Bookmark the permalink. | Tagged ETL, ExecuteProcess, IBM Cognos, IBM Cognos Express, IBM Cognos TM1, TI Process, TM1 Training, Turbo Integrator | 7 Comments

TM1 Contributor – Single Security Hierarchy

Currently on-site at client installing TM1 Cognos Express. The client wishes to use the contributor application to utilize workflow in the forecast. Doing so can creates a number of limitations, namely security and secondly cube design. Within TM1 Contributor/Cognos Express Planner you apply security based on a single dimension hierarchy for the application you have created, however the elements within the entire security dimension cannot share more than one top … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 Contributor, TM1 pre 10.1, Training Material and tagged Contributor, David Payten, ETL, Fluffy Mittens, IBM Cognos TM1, Sample Code, TI Process, TM1 Process, TM1 Tutorial. Bookmark the permalink. | Tagged Contributor, David Payten, ETL, Fluffy Mittens, IBM Cognos TM1, Sample Code, TI Process, TM1 Process, TM1 Tutorial | 1 Comment

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

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 later time, often too late – it will  never be considered as a value-add enhancement … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Best Practice, ETL, Rules, TM1Naming Conventions, Turbo Integrator. Bookmark the permalink. | Tagged Best Practice, ETL, Rules, TM1Naming Conventions, Turbo Integrator | Leave a comment