Data & Intelligence

Desktop analytics – IBM Cognos TM1 and Insight

So just how easy is it to perform simple forecast modeling using Cognos Insight? Let see.

First, I took an MS Excel file and did a “Get Data” and “Import Data…”

1

On the “way in”, Insight let me examine my file and exclude fields I didn’t care about and also (most importantly) tell it which fields I wanted to use as:

  • dimensions and which would be my
  • measures.

After the import completed, Insight automatically creates a cube for me and displays it in the Data panel of my desktop. From there, it was easy enough to do some “cleanup”. For example, right-clicking to rename the cube and its dimensions to what makes more sense to me (Insight based its names on the first row of my file) and I was also able to “rearrange” my cube dimensional order to a more “optimal” order.

2

Then, I reviewed each of my cube dimensions and edited them to add or rename appropriate roll-ups, add additional elements, etc. (Note: you can “key in” values or even import from exterior data sources):

3

4

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

The data I imported included a value for actual (sales) and a budget. I wanted to add a new value to calculate any “gap” between what the budget was and what the actual value was, so I edited the version dimension and added “Gap” as a new element:

5

My last step was to add some rules to the model.

But, before I start coding my rules, I know that I will want to be adding some “budget drivers” – to automatically create a budget for certain accounts – based upon a rate, so I created my own rate cube.

Again from the Data panel, I choose “Blank Cube”. Insight gives me a blank cube with 2 dummy dimensions (all cubes require at a minimum, 2 dimensions) and from there, I simply “dragged” the period and model dimensions from my forecast cube to my new “DriverRates” cube (Insight asked me if I wanted to share or duplicate the dimension and I chose “share”).

6

Now I need some rates, so I clicked over to “Tab 2” (on the Insight desktop) and “dropped” my new cube there. It was easy and fast to “past in” some driver rates.

7

Now the rules.  From the desktop I selected “Set Cube Rules…” to access the Insight rules editor.

The rules editor allows me to add my rules – the first to do a simple gap calculation (actual less budget) and the second to drive the budget amount for a particular account (in my example I simply choose to use a similar model as a base line and apply a particular rate pulled from my rate cube:

8

So, now with some quick ”dragging and droping” on the Insight desktop, I have a forecast model showing my results with the calculated budget vs. actual “gap” and a budget driven a rate for a particular account:

9

There are so many features offered in Insight – so much to explore (I feel more blog posts to come), but for now, in about 20 minutes, I have created a simple model I can use to monitor and adjust my budget!

I give IBM Cognos Insight “two thumbs up!”…

About the Author

Mr. Miller is an IBM certified and accomplished Senior Project Leader and Application/System Architect-Developer with over 30 years of extensive applications and system design and development experience. His current role is National FPM Practice Leader. His experience includes BI, Web architecture & design, systems analysis, GUI design and testing, Database modeling and systems analysis, design, and development of Client/Server, Web and Mainframe applications and systems utilizing: Applix TM1 (including TM1 rules, TI, TM1Web and Planning Manager), dynaSight - ArcPlan, ASP, DHTML, XML, IIS, MS Visual Basic and VBA, Visual Studio, PERL, Websuite, MS SQL Server, ORACLE, SYBASE SQL Server, etc. His Responsibilities have included all aspects of Windows and SQL solution development and design including: analysis; GUI (and Web site) design; data modeling; table, screen/form and script development; SQL (and remote stored procedures and triggers) development and testing; test preparation and management and training of programming staff. Other experience includes development of ETL infrastructure such as data transfer automation between mainframe (DB2, Lawson, Great Plains, etc.) systems and client/server SQL server and Web based applications and integration of enterprise applications and data sources. In addition, Mr. Miller has acted as Internet Applications Development Manager responsible for the design, development, QA and delivery of multiple Web Sites including online trading applications, warehouse process control and scheduling systems and administrative and control applications. Mr. Miller also was responsible for the design, development and administration of a Web based financial reporting system for a 450 million dollar organization, reporting directly to the CFO and his executive team. Mr. Miller has also been responsible for managing and directing multiple resources in various management roles including project and team leader, lead developer and applications development director. Specialties Include: Cognos/TM1 Design and Development, Cognos Planning, IBM SPSS and Modeler, OLAP, Visual Basic, SQL Server, Forecasting and Planning; International Application Development, Business Intelligence, Project Development. IBM Certified Developer - Cognos TM1 (perfect score 100% on exam) IBM Certified Business Analyst - Cognos TM1

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up