Posts Tagged ‘TM1 Consulting’

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

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

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

Performance Profiling with Cognos TM1

Profiling As my last post promised, I’m continuing the performance testing discussion with my thoughts on performance profiling. What is profiling? Profiling is the extrapolation of information about something, based on known qualities (baselines) to determine its behavior (performance) patterns. In fact, performance profiling is determining the average time and/or resources required to perform a […]

Baselines for Performance Testing

In my last post I introduced the concept of performance and performance testing. Without establishing baselines, performance testing is a waste of time. So what is a baseline and why is it important to performance testing? Baselines Measuring performance requires an initial state (how is the application performing at this time with these parameters?) and […]

IBM Cognos TM1 Server Environments and Model Migration

IBM Cognos TM1 employs a distributed, client-server architecture that consists of the IBM Cognos TM1 server to which a combination of different clients can connect. The TM1 Server manages access to the Cognos TM1 data directory for Cognos TM1 clients. The data directory is where files are migrated from and to and this “migration of […]

TM1 Modeling Best Practice – Optimally Locating Solution Logic

To insure that acceptable levels of performance and maintainability can be achieved, an “architectural purist” (like me) will want to recommend that when implementing your Cognos TM1 model, great care be taken when deciding where you implement the specific logic that the solution requires. Although there will always be “room for exception” (for example to […]

naviagation

Navigating Cognos TM1 Cube Types

navigation Cubes are to TM1 what tables are to relational databases.  Almost all data stored in TM1 is stored in and accessed from cubes. Do you know the difference between the types of these basic objects?   Let’s explore!     First, each and every TM1 cube must have at least two and up to […]