Consider the scenario where you have to convert information held in a “categorical field” into a “collection of flag fields” – found in a transactional source. For example, suppose you have a file of transactions that includes (among other fields) a customer identifier (“who”) and a product identifier (“what”). This file of transactional data indicates […]
Posts Tagged ‘FPM’
Cognos TM1 – View and Subset Maintenance Considerations
TM1 TurboIntegrator is the programming or scripting tool that allows you to automate data importation, metadata management, and many other tasks. Scripts built with TurboIntegrator or “TI”, can be saved, edited and, through the use of chores, be set up to run at regular intervals. TI scripts can be used to process existing TM1 data […]
Guidelines for Deploying Cognos TM1 Rule Changes
Objective Making modifications to TM1 rule files can (potentially) affect both the TM1 application and the TM1 server (that the application is running on). Rule modification or reprogramming can cause loss of data, changes in how the application responds (performance) and unexpected changes in memory consumption. In addition, it can be difficult to effectively test […]
Cognos TM1 Off-Site Testing Recommendations
General Coordination From a general testing perspective, consider the following: Identify and visit the test site before the planned testing days Establish an “onsite” coordinator – usually someone associated with the facility (hotel or facilities manager, perhaps) who will be responsible for any facility provided accommodations Inspect and Validate any and all facility provided accommodations […]
Software Remediation Excellence
Overview The purpose of this post is to provide a strategy for approaching and resolving a “concern” that has been identified within a application. Overall, the idea is to “add structure” to the process of responding to defects (remediation) in your application. Steps to Remediation Using a resolution methodology referred to as CERT, the steps […]
Estimating Hints for Cognos TM1 Report Development
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 […]
Reengineering the Forecasting Process with Predictive Models
Reengineering the Forecasting Process with Predictive Models Forecasts usually start as historical performance which is then reviewed and adjusted based upon anticipated events. More mature forecasting may also incorporate generally accepted business rules “programmed in” to help “drive” the data into a forecast. Over the years I’ve deployed uncountable applications which provide the ability to […]
A Case for a Center of Excellence
Center of Excellence (CoE) A Forrester survey (“The EA View: BPM Has Become Mainstream”, Forrester Research, Inc.) indicated: “Of companies experiencing clear measurable improvement in FPM, 49% have a CoE in place” With that in mind, I attended a presentation by Sandy Kemsley, (an accomplished FPM Analyst and Consultant) entitled, “Maximizing FPM […]