In TM1, missing data usually means that there is a defect in the logic of your ETL script or you need to check your SQL. In SPSS Modeler, missing values arise for a variety of reasons and they must be considered carefully. You might expect that missing values imply errors or should those records be […]
Posts Tagged ‘TM1 certification’
Primary Practices for Examining Data
SPSS Data Audit Node Once data is imported into SPSS Modeler, the next step is to explore the data and to become “thoroughly acquainted” with its characteristics. Most (if not all) data will contain problems or errors such as missing information and/or invalid values. Before any real work can be done using […]
Data Consumption – Cognos TM1 vs. SPSS Modeler
In TM1, you may be used to “integer or string”, in SPSS Modeler, data gets much more interesting. In fact, you will need to be familiar with a concept known as “Field Measurement Level” and the practice of “Data Instantiation”. In TM1, data is transformed by aggregation, multiplication or division, concatenation or translation, and so […]
Importing Data into SPSS Modeler for the TM1 Developer
If you have a TM1 background it is a quick step to using SPSS Modeler -if you look for similarities in how the tools handle certain tasks like, for example, importing data. With TM1, source data is transformed and loaded into cube structures for consolidation, modeling and reporting using its ETL tool TurboIntegrator. In SPSS […]
Serviceability Auditing
Serviceability What is application serviceability? “Serviceability (also known as supportability,) is one of the -ilities or aspects (from IBM’s RAS(U) (Reliability, Availability, Serviceability, and Usability)). It refers to the ability of application support personnel to install, configure, and monitor an application, identify exceptions or faults, debug or isolate faults to root cause analysis, and provide […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]