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 […]
Posts Tagged ‘TurboIntegrator’
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 […]
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 […]
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 […]
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 […]
Loading Cubes – with Cognos TM1 Performance Modeler
So we’ve created a sample, simple cube in Modeler (this cube has only 2 dimensions) and we want to load some data. To do that, you can (like in TM1 Architect) right-click on the folder “Processes”: And then provide a name for the new process: Performance Modeler now presents the “edit process” panel with the […]
IBM Cognos TM1 TurboIntegrator – Comment Your Code
“Either positive or negative comments are good because it shows I am still relevant” – Justin Guarini In all of my years of coding and testing TurboIntegrator scripts, my biggest pet peeve has to be opening a TI script and seeing lines and lines of unstructured, un-commented code. I’ve heard all the excuses: “self-documenting”, […]
Cognos TM1 Models – focusing on the “value add”
TM1 Models will all consist of 4 functional components. These will be Absorb, Configure, Calculate/Consolidate and Consume. Remember: Each component must be kept distinct! Components are purpose based not technology based! Focus on which components add value to the business not ones that are generic to any business! Now let’s have a look at each […]
Cognos TM1 – Information Staging
Exchanging Information Most enterprise TM1 applications will need to exchange Information with external systems. With TM1’s TurboIntegrator, you can setup a direct connection (with supported datasources) and move information in and out of TM1 objects at scheduled times or “on demand”. An alternative to going the “direct route” is using a method referred to […]
IBM Cognos TM1 – ExecuteProcess
Another advanced (and handy) feature to be aware of is the TurboIntegrator ExecuteProcess function. This is a very useful function. It allows you to execute a TI process from within a TI process. (Obviously, you cannot have a process call itself). The format is as follows:
TM1 TurboIntergrator
TM1 TurboIntergrator TM1 TurboIntegrator (or TI) is the programming or scripting tool that allows you to automate data importation, metadata management, and many other tasks. In my recent book: IBM Cognos TM1 Developers Certification Guide- (http://www.amazon.com/IBM-Cognos-Developers-Certification-Guide/dp/1849684901), I discussed advanced techniques for TurboIntegrator (TI) scripting in regards to the current IBM Cognos […]