Posts Tagged ‘TM1 Careers’

IBM SPSS Modeler and Duplicate Data

Transactional datasets (especially those originating from databases) may contain duplicate records that must be removed before any modeling can begin.  There are simply two situations where duplicate records occur are: Datasets ARE erroneous (causing the same record to multiple times) Datasets ARE NOT erroneous (but records appear multiple times because information is collected different moments […]

Missing Data – “Nothing from nothing” – leaves something?

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

Data Indiscretions

Data loaded into a TM1 or SPSS model will, in most cases, include files consisting of thousands (or hundreds of thousands) of records. It is not reasonable, given the number of fields and records in files of this size, for you to visually inspect all fields in every record (of every file) for missing or […]

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

Exposing TM1 Top

So what is TM1 TOP? Definition and Access The TM1 Top utility empowers you to dynamically monitor “threads” running in an instance of a Cognos TM1 server. TM1 Threads are of three possible “types”: User Threads – Name of an actual user that is logged into TM1 Chore Threads – A chore running on the […]

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