IBM TM1 | Data & Analytics
Data & Analytics Blog

Posts Tagged ‘IBM TM1’

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

IBM Cognos TM1 – Version Release Migration Testing

Here are several general considerations for testing functional areas of a new release of IBM Cognos TM1; (keep in mind that it is not intended to be an exhaustive or “end to end” testing plan. It also does not intend to offer remediation options should testing uncover issues). Functional areas of emphasis covered are: Server […]

Read more

IBM Cognos TM1 – Cube Naming Ideas

Start Early!  Another important design best practice that should be established early in the development process is establishing naming conventions for your cubes. In fact, it is highly recommended that you introduce your entire project user community – Architects, Modelers, Contributors, Analysts and Consumers – to all of your naming conventions, as part of a […]

Read more

Perficient Data & Analytics

Trends, best practices, and technical perspectives from data and analytics experts. Readers will gain valuable insights and strategies in harnessing the power of data to drive actionable intelligence for a digital transformation journey.

Archives