In this blog I wanted to take some time to describe certain “behaviors” of Cognos TM1 TurboIntegrator processes. Access to Processes As of version 10.2 (or as of this writing), TM1 Server lists all processes (in alphabetical order) under the consolidation “Processes”. The visibility of processes can be controlled by implementing TM1 security. TM1 groups […]
Posts Tagged ‘Cognos’
Using Splunk with Cognos TM1
IBM Cognos TM1 offers powerful enterprise planning, forecasting, and analysis capabilities. These benefits are best realized by extending the solution across departments for a consolidated, integrated planning process, leveraging business-specific financial models that mirror business strategy. Our years of experience implementing TM1 have shown an increasing demand on support personnel to coordinate data transferring and […]
Predicting Project Success with IBM SPSS
A technology company has literally participated in thousands of projects over the years. At some point the group decided it wants to determine what factors or characteristics may influence the (hopefully successful) competition of current and future implementation projects. Thankfully, they have maintained records in on every project that they were involved in and that […]
Selecting your Modeling Approach with IBM SPSS Modeler
Coming from a TM1 background (more business than statistics), it is easy to get stated with modeling once you determine your modeling objective, and Modeler can help with that. IBM SPSS Modeler offers an intuitive interface that will appeal to a wide range of users from the non-technical business user to the statistician, data miner […]
Examining (Data) Relationships
The discovering of relationships within data (between fields) is an important part of any data mining project (in the Crisp-DM methodology, this is described as part of the “Data Understanding” stage). This “relationship discovery” is part of developing a predictive model but is also helpful in answering specific business questions -perhaps even what originally motivated […]
All about CLEM
SPSS CLEM is the control Language for Expression Manipulation, which is used to build expressions within SPSS Modeler streams. CLEM is actually used in a number of SPSS “nodes” (among these are the Select and Derive nodes) and you can check the product documentation to see the extended list. CLEM expressions are constructed from: Values, […]
Sampling Your Data
Another interesting feature of SPSS Modeler is its built-in ability to sample data. It is pretty typical to have (in one or more files) hundreds of thousands of records to process, and using complete sets of data during testing can take a huge amount of your time and is inefficient in terms of computer processing […]
TM1 vs. SPSS Modeler Comparison Continues – Setting to Flags
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 […]
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 […]
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 […]
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 […]