Skip to main content

Posts Tagged ‘center of excellence’

Center of Excellence – Solution Assessments

The goal of a Practice Center of Excellence (CoE) Solution Assessment is to conduct an impartial review of a particular component (or components) of an identified solution or architecture or to address a particular application design pattern strategy concern. The assessment team will identify the purpose and scope of the assessment prior to beginning the […]

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 Bulk Data Loading

Bulk Absorption Options From a pure architectural perspective, what is sometimes referred to as “bulk uploading” sometimes is (mistakenly) considered to be part of reporting or included in the data consumption component of a TM1 application design.  Loading and/or updating data is part of an applications absorption or configurations components and should be handled with […]

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 […]

Obstacles on the Road to Excellence – the Three-C’s

  Establishing an organizations center of excellence (COE) takes vision and a strong commitment to overcoming obstacles.  Three common obstacles often encountered on the journey towards excellence are: Complacency, Complexity and Conservatism. Complacency Complacency is the notion that “this works, it’s manageable, so why change it?” This attitude comes from the old saying, “if it’s […]

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 […]

Performance Testing Your Cognos TM1 Application

Performance testing a TM1 model begins with understanding performance testing in general. Performance testing is an iterative process and the expected outcome (acceptable performance) will be based upon both the TM1 application and the environment it is deployed in.  The goal of performance testing is to identify response times, throughputs, and resource utilization of the […]

Creating Rules with Cognos TM1 Performance Modeler

The website reads: “Rule creation is greatly simplified in Cognos TM1 Performance Modeler. The Rules Editor includes Content Assist features that present contextually relevant elements or information while creating a rule. Additionally, Cognos TM1 Performance Modeler automatically generates rules and associated feeders when you define a calculation dimension or create a link.” So, let us […]

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…” 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 […]

5 Guiding Principles of a Successful Center of Excellence (CoE)

A Center of Excellence (CoE), sometimes referred to as a “competency or capability center”, is typically a small team within an organization working cross-functionally to build on the organizations past experiences to avoid reinventing the wheel after each project. A few ways the CoE accomplishes this is by: Providing leadership Best practice knowledge share Offering […]

What is a Center of Excellence? – White Paper

If you have been reading any of my earlier posts, you’ll know that I am always happy to evangelize the concept of a practice or organization “Center of Excellence” – or “CoE”. I believe that the establishment of and commitment to a practice CoE shows that an organization is committed to continuous improvement and ultimately, […]

Load More