Typically, a TM1 project will include work to create reports. Most finance groups will have a number of Excel workbooks that they are using for both their forecasting and planning as well as for reporting. These workbooks will become the “templates” for designing your TM1 input sheets and reports. For the reports, you will be […]
Posts Tagged ‘cognos TM1’
Documenting and Unit Testing IBM Cognos TM1 Components
As some will say, documentation is key, but a tedious task to do. Now if you’re like me, you may hate documentation. Lets be honest, who wants to spend hours upon hours documenting code another developer should be able to understand in no time at all. Well that’s what I thought in the past, but […]
Cognos Version 8-8.4 No Longer Supported! Now What?
Effective September 30th If your organization is currently running IBM Cognos Software version 8.0-8.4 these versions will soon be retired and no longer maintained by IBM. This means your production issues and bug fixes will no longer be supported for these following versions: Cognos Business Intelligence V8.4.1 Cognos Data Manager V8.4.1 Cognos Business Intelligence Analysis […]
Using Cognos Analytics to Improve Quality of Healthcare
The healthcare industry pressures and technology maturity are starting to converge, and as they do the organizations that are equipped to capture data, integrate and analyze it from multiple systems will be able to generate greater insights that will drive a shift from volume-based to value-driven healthcare that improves consumer engagement and care delivery. IBM […]
Automation of Cognos TM1 Data Loading
In one of my earlier posts I recommended an approach for loading larger amounts of data into TM1 applications, and provided a high-level explanation of this approach, which I call the “File Route” solution. Some More Thoughts I like this load-strategy because, in following best practice guidelines, it leverages TM1’s proven ETL tool, TurboIntegrator to […]
Cognos TM1 Reporting Solution Strategy
Solve, then Evolve All Cognos TM1 implementations require a strategy to deliver an appropriate reporting solution. This is the plan that will ensure that each business user will have access to all the TM1 data that they need, in the most usable format and in a timely manner. This plan must be based upon environmental […]
Autonomous Performance Tuning
I was recently asked by a former colleague of mine to help conduct an appraisal of a large scale Cognos TM1 development project that is planning on sourcing all kinds of data from a large Oracle RDMS. In addition to the “normal” review objectives (is the design appropriate? are best practices being followed? will the […]
IBM SPSS Syntax -using Functions to perform Data Transformations
I recently finished another productive mentoring session exploring Data Transformations using SPSS Syntax. We had so much fun using some basic SPSS, I just had to share, so: Getting back to my Predictive startup example, we now have a new version of the quarterly hours file. This one includes a few new columns (“variables” to […]
IBM SPSS Statistics Syntax – Restructuring Your Files
Continuing my discussion on the use of SPSS Syntax scripting to perform file operations, today I’ve investigated how to use SPSS to perform some very general physical file restructuring. Why is this important? It’s important because it again shows how SPSS can be used to arrange the data pool into the most effective format based […]
IBM SPSS Syntax for File Operations
My start-up predictive analytics organization “Predictive Performers” wants to do some internal planning. We receive extract files from an an accounting service each month that provide the total hours billed per each of our consultants, along with each consultants hourly rate. The files are saved to a folder on our network: The files also breakout […]
IBM Vision 2013 – 2 thumbs Up!
I just returned from the IBM Vision Conference in Orlando, Florida. I attended a session in every available timeslot from Monday morning to Wednesday afternoon and it was worth every single minute of my time! Although there were too many sessions and presenters to mention, here are my “top picks”: Designing Solutions with IBM Cognos […]
Adding Emptoris & TeaLeaf to The Holistic Commerce Suite
As IBM’s Premier Partner delivering Smarter Commerce solutions Perficient knows how to create a seamless and unified omni-channel commerce experience that leverages commerce, social and mobile technologies to provide the operational excellence needed to deliver a consistent brand experience that deepens your client relationships. Perficient is one of a very small delivery partner that are […]