Monthly Archives: July 2012

Back to Basics – Regions in Rules

If there is one basic technical best practise which makes TM1 Solutions more straight-forward thus sustainable which is most often not utilised it is #Regions in cube rules. Regions work the same way as grouping rows within Microsoft Excel, except the grouping is done automatically around a set of key words. This is actually a feature in many scripting environments and is called code folding, it is added to a rule like so: #Region *The title … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Code Folding, Cube Rules, IBM Cognos Express, IBM Cognos TM1, Region, Sales Calculations, TM1 Best Practise, TM1 Cube Rules, TM1 Development. Bookmark the permalink. | Tagged Code Folding, Cube Rules, IBM Cognos Express, IBM Cognos TM1, Region, Sales Calculations, TM1 Best Practise, TM1 Cube Rules, TM1 Development | Leave a comment

Cognos Insight – Aligning using the Grid

Just found a cool little trick when organising widgets on a Cognos Insight Dashboard thanks to the team at IBM. You can hold shift while dragging or resizing widgets in Cognos Express to bring up the positioning grid. This makes alignment ridiculously easy. Cognos Insight – Olympic Medals – Australia – Swimming Click here for a 30-Day Free Trial of IBM Cognos Insight

This entry was posted in Cognos Insight, Training Material and tagged Cognos Insight, IBM Cognos Insight, Olympics Data, Tips & Tricks. Bookmark the permalink. | Tagged Cognos Insight, IBM Cognos Insight, Olympics Data, Tips & Tricks | 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 10.1 – IBM Cognos Insight Review Pt 2

In the first part of this review we had a look at the workings of IBM Cognos Insight and how it can effortlessly “munch down” a multitude of file formats an “crap out” a sexy looking dashboard. The scariest part of this is that it really works – and it looks great! The Pro’s Instant Data Visibility Brilliant for data reconciliation and quick ‘n’ easy to step through. I can see this … Continue Reading

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

The [Black Box] Killer

In the past when corporate finance came across a “Big” Data problem, very often the solution was created by a member of the team particularly good with VBA and access databases. They would often slave away for days on end creating the solution to this particular problem. This solution was usually needed due to row contraints in MS Excel 2003 or complexity around managing the next weeks/months data load. Today … Continue Reading

This entry was posted in Cognos Insight and tagged Big Data, Business Process, IBM Cognos Insight, IBM Cognos TM1. Bookmark the permalink. | Tagged Big Data, Business Process, IBM Cognos Insight, IBM Cognos TM1 | 1 Comment

Free Trial of Cognos Insight – Big Data Analytics

A free trial of Cognos Insight is available for download on Analytics Zone – Download Now. What is Analytics Zone? Analytics Zone is a community portal focusing on Big Data Analytics. Its a great place for connecting with other analysts and data scientists, downloading modelling (Not “Project Runway”) resources, tutorials and catching up with the latest Big Data Bloggers.  

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1 and tagged Analyst, Big Data, Cognos, Data Scientist, IBM Cognos Insight, IBM Cognos TM1, Insight. Bookmark the permalink. | Tagged Analyst, Big Data, Cognos, Data Scientist, IBM Cognos Insight, IBM Cognos TM1, Insight | 2 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

Rolling Forecast in IBM Cognos TM1

Recently, a client has asked to implement a rolling forecast model to move towards a more dynamic way of forecasting so as the periods move forward so does your forecast so you are always forecasting 12 / 18 months out in to the future. With a rolling forecast the number of periods remain the same so as each period is traded it drops out of the forecast and another period … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, Training Material and tagged Corporate Planning, Forecasting in TM1, IBM Cognos TM1, Rolling Forecasts, TM1 Cube Rules. Bookmark the permalink. | Tagged Corporate Planning, Forecasting in TM1, IBM Cognos TM1, Rolling Forecasts, TM1 Cube Rules | 1 Comment

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 solutions. InfoCube founder and managing director, John Vaughan said the merger would complement the strengths … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 10.1 and tagged Active Form, Analysis, Assistance, Budgeting, Comparative Analysis, Corporate Planning, Daptech, dynamic reporting, IBM Cognos, IBM Cognos Insight, IBM Cognos TM1, Implementing TM1, InfoCube, Management Accounting, Management Consulting, TM1 10.1, TM1 Consultants. Bookmark the permalink. | Tagged Active Form, Analysis, Assistance, Budgeting, Comparative Analysis, Corporate Planning, Daptech, dynamic reporting, IBM Cognos, IBM Cognos Insight, IBM Cognos TM1, Implementing TM1, InfoCube, Management Accounting, Management Consulting, TM1 10.1, TM1 Consultants | Leave a comment