New Tool for Importing Cognos Planning into TM1

Are you using Cognos Enterprise Planning and looking to move to IBM Cognos Performance Management/TM1?  There is a new tool for importing Cognos Planning into TM1 as part of your migration.

You might want to check out the new IBM Planning Import capabilities of TM1 10.2.  Both Express and Enterprise versions of TM1 have the import tool.  The tool allows you to leverage components of your Planning models and bring them into TM1 as starting blocks.  Please note that it does not pull your entire model in and you will need to redesign components of your model.  Look at the migration like you are moving into a new house.  When you move, some of your furniture won’t fit.  The rugs may be the wrong color and that old recliner from college should be thrown out.  Well, the same is true for your models.

importing Cognos Planning into TM1

Here’s how the import works:

  • Generate Cognos Planning Contributor .XML application definition of the model from Planning
  • Import converts the XML output from Cognos Planning into a folder of .json type files
  • Import .json files into Cognos TM1 Performance Modeler, with the Action > Import Cognos Planning model option
  • Creates dimensions, cubes, and links

There's definitely going to be some redesign work so don’t think it’s an easy button, but it should help! Remember you must be on 10.2 or higher of TM1 to have the import functionality. 

For more information on planning your upgrade and the licenses you will need, contact Lodestar Solutions 813-254-2040.

Cognos TM1 Sales Compensation Model

As much as sales people say, “I’m not a numbers person. I’ll just let you accountants handle that”, you start messing with how their commissions/T&E are calculated and you’ll see them become the best actuaries that MIT ever turned out.  Below we talk about a Sales Compensation Model.

How IBM Cognos Performance Management Can Help You

  • Utilize IBM Cognos Performance Management (TM1) to plan, calculate and track commissions and sales personnel performance.
  • Use historical data to get baseline.  Who are your best performers?
  • Plot out your design to allow insight to compare commission costs and productivity from one comp plan to another.  Are you really saving money if you lose your better performers?  Did setting a maximum dollar limit on a T&E line item lower costs or increase them?
  • Track productivity of existing versus new sales people.  Are your new hires ramping up effectively?
  • How long does it take to make a new sales person profitable?  Does your cash flow allow you to hire more sales people and when should you plan for that?
  • If you are expanding your sales force, how are the additional sales affecting other operational departments that support this increase?  Do you need to increase headcount elsewhere?
  • What about inventory levels, supplier lead times and purchasing power of increased volume?

With IBM Cognos Performance Management, you are able to tie in all these factors to your financial forecasts.  If you are not doing this already, well then maybe these are good ideas to start your next phase for expanding your IBM Cognos footprint and get the most value out of your software investment.  Plus, with the latest version of TM1, you are able to design calculated scorecards using metrics cubes.  Wrap it up with BI and you have the perfect holiday gift for your CFO!

Cognos Insight vs Excel? Managing with personal analytics

Cognos Insight vs Excel? Managing with personal analytics

Think about the world we live in. Literally anything we want is at our fingertips. The latest weight loss super drug that just got banned in Bulgaria? It’s on Amazon. You’re in your Monday morning meeting and your manager “suggests” a book for you to read. Oh, that’s simple. Just slide your phone out of your pocket, slide down the search bar for (because you’ve already memorized the keyboard layout), type in the book, and add in the phone case and headphones you’ve been looking at. Hit submit and next thing you know, there’s a box on your door step when you get home from work on Wednesday.

Now that same ease is at your fingertips when it comes to personal analytics. How much water did I drink today? How is my performance in the gym or the 10k I’m training for going? How long is it taking me to get to work? If you can measure it you can improve it.

Have some fun and empower yourself by viewing your life just as you would in business. If you can measure it, you can improve it. Does a company think, “Oh we’re profitable… keep it up” or do they look to drill into their numbers to gain context? What are our biggest profit centers and how do we expand them? What are our areas of weakness and how do we either understand, fix, or minimize their under-performance. Whether you’re old school and prefer the familiarity of excel or you’re utilizing the power of a personal desktop application like Cognos Insight, anything is possible.

TM1 10.2 Security Changes

With TM1 10.2 security changes, TM1 10.2 now allows you to share/re-use the same dimension in multiple approval applications.  This is a nice feature, since it eliminates the need to maintain a duplicate dimension.  With that being said, there are changes to how security is structured and managed in this new version.  Please review the documentation in the link provided, as there will be changes automatically generated to models upgraded from versions prior to 10.2.

If you have additional questions regarding security in TM1 10.2 please reach out to us at  We have a fantastic services team ready to answer all of your questions.  Also if you have not joined our community yet, what are you waiting for?  Go to and join today!  it takes less than 1 min and you will ensure that you are among the first to know about how new programs and blogs.